leemengtaiwan
11/14/2017 - 1:35 AM

找出mongodDB裡某個field所有可能的值

找出mongodDB裡某個field所有可能的值

db.collection.distinct('x')

# add a query
db.getCollection('actions').distinct('action_type', 
        {"datetime": {"$gte": ISODate("2017-11-06T00:00:00.000Z"), "$lt": ISODate("2017-11-13T00:00:00.000Z")}}
    );
    
    
References
- https://docs.mongodb.com/manual/reference/method/db.collection.distinct/