Mongodb Complex Object Query

Question

I want to find distinct values of the cities from a collection containing objects as mentioned below:

{
location:{
              address:'XYZ',
              city:'New York'
         }
}

Can you help me with the query I need to fire? I know I have to use elemMatch and $exists. But my following query seem to work and returns an empty set:

db.collectionName.distinct({'location':{'city':{$exists: true}}})

Rohit Jain · Accepted Answer · 2012-12-17 06:37:14Z

3

db.collection.distinct takes the query as a 2nd parameter.

Here's how you should do it: -

db.collectionName.distinct('location.city', {'location.city': {$exists: true}})

Additionally, you can also use this distinct database command: -

db.runCommand({  "distinct": "collectionName", 
                 "key": "location.city", 
                 "query": {'location.city' : {$exists: true}}
              }).values

edited Dec 17, 2012 at 6:37

answered Dec 17, 2012 at 6:29

Rohit Jain

214k45 gold badges419 silver badges534 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Darshan Pandit Over a year ago

Thanks. It checks for a value as well. Mongodb is truely awesome :)

Eric · Accepted Answer · 2012-12-17 06:28:23Z

1

db.collectionName.distinct('location.city') should do the trick.

answered Dec 17, 2012 at 6:28

Eric

2,9241 gold badge23 silver badges25 bronze badges

Collectives™ on Stack Overflow

Mongodb Complex Object Query

2 Answers 2

1 Comment

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

Comments

Your Answer

Sign up or log in

Post as a guest

Related