Mongo DB find by field name with any value

Question

I am trying to find all documents that have this field, it doesn't matter what exact value it contains; I am only interested in the existence of it.

Here is an example:

{  
   "payload":{  
      "products":{  
         ...
      },
      "discount":{  
         "type":"1%",
         "value":"1",
         "name":"New Year Discount 1%"
      }
   }
}

I need to target any document that has a field with the name discount. How can I write a query to get such documents?

mickl · Accepted Answer · 2017-12-10 10:58:32Z

44

There's a $exists operator for that:

db.collectionName.find({"payload.discount": {$exists: true}})

answered Dec 10, 2017 at 10:58

mickl

50.1k9 gold badges71 silver badges99 bronze badges

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

Comments

sepehr · Accepted Answer · 2017-12-10 14:16:03Z

13

You're probably looking for the $exists operator:

db.collection.find({ "payload.discount": { $exists: true } })

edited Dec 10, 2017 at 14:16

answered Dec 10, 2017 at 10:59

sepehr

18.7k7 gold badges87 silver badges120 bronze badges

Collectives™ on Stack Overflow

Mongo DB find by field name with any value

2 Answers 2

Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related