MongoDB, how to retrieve elements which has not a matchable element into an Array?

Question

I have this kind of elements:

{  "_id" : 1,
  "docs" : [
    { "key": "blah", "count": 2},
    { "key": "wow", "count": 10}
  ]
},
{  "_id" : 2,
  "docs" : [
    { "key": "blah", "count": 11}
}

I want to retrive elements which has NOT the docs.key == "wow" defined. In this case the element "_id": 2.

Whith this query I get the opposite:

db.getCollection('myCollection').find(
  {
    "docs.key": "wow"
  }
);

I have tried combinations of $exists and aggregate but I don't find the proper solution.

Related but not the same: http://stackoverflow.com/q/5719408/316700, http://stackoverflow.com/q/16221599/316700 because in my example I an looking for an complex element into an Array. — fguillen, Mar 14 '16 at 17:44

score 4 · Accepted Answer · answered Mar 14 '16 at 17:46

4

You could do :

db.getCollection('myCollection').find({
    "docs.key": {$ne: "wow"}
});

answered Mar 14 '16 at 17:46

Till

4,183
3
16
18

Rahul · Answer 2 · 2016-03-14T18:19:17.783

0

Have you tried the $ne operator

db.getCollection('myCollection').find(
  {
    "docs.key": {$ne : "wow"}
  }
);

edited Mar 14 '16 at 18:19

answered Mar 14 '16 at 17:46

Rahul

15,979
4
42
63

`Error: count failed: { "ok" : 0, "errmsg" : "$not needs a regex or a document", "code" : 2 }` – fguillen Mar 14 '16 at 18:14

MongoDB, how to retrieve elements which has not a matchable element into an Array?

2 Answers2