Query where array of object does not contain property equal to string value

Question

Given the following document, how can I query for a document where meta does not contain an object with a specific name?

{ "_id" : 1, "meta" : [ { "name" : "alpha", "date" : ISODate("2015-09-08T19:51:03.275Z") } ] }

I'm looking for the opposite of this:

db.content.find({'meta.name': 'alpha'})

I want to query for the same document like this:

Find me the document where 'meta.name' !== 'beta'.

Related: To $nin or not to $nin as you seem to misconceive that you need such operators when working with arrays as that post discusses. — Blakes Seven
– Blakes Seven, Commented Sep 9, 2015 at 2:05

Mario Trucco · Accepted Answer · 2015-09-09 01:57:41Z

3

Try

 db.content.find({'meta.name': {$ne: "beta"}})

since $ne works for nested arrays too

answered Sep 9, 2015 at 1:57

Mario Trucco

2,0213 gold badges34 silver badges45 bronze badges

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

Comments

TharunRaja · Accepted Answer · 2015-09-09 12:58:16Z

0

Came through few such questions previously.Assuming your collection as 'test'. Try this instead

db.test.find({"_id":1, "meta":{$elemMatch :{"name":{$ne:"beta"}}}});

answered Sep 9, 2015 at 12:58

TharunRaja

7071 gold badge7 silver badges28 bronze badges