Mongodb - Array containing element and not containing another one

Question

I'm trying to query one of my mongodb collection that looks like this:

> db.collection.find()
{name: "foo", things: [{stuff:"banana", value: 1}, {stuff:"apple", value: 2}, {stuff:"strawberry", value: 3}]}
{name: "bar", things: [{stuff:"banana", value: 4}, {stuff:"pear", value: 5}]}
...

My goal is to list all the object that have the things field containing an element with stuff=banana but no stuff=apple

I tried something like this:

db.transactions.find({
  "things": {
    $elemMatch: {
      "stuff": "banana", 
      $ne: {
        "stuff": "apple"
      }
    }
  }
)

But it's not working. Any ideas?

score 8 · Answer 1 · answered Mar 25 '14 at 10:56

8

The below query will get the list of all documents that have the things field containing an element with stuff=banana but no stuff=apple:

db.test.find({"$and":[{"things.stuff":"banana"}, {"things.stuff":{$ne:"apple"}}]})

answered Mar 25 '14 at 10:56

Anand Jayabalan

12,294
5
41
52

score 3 · Answer 2 · answered Mar 25 '14 at 08:59

3

Use the $not and $and operators:

db.collection.find({

   $and:[
    {"things": {$elemMatch: {  "stuff": "banana"  }}},
    {"things": {$not: {$elemMatch: { "stuff": "apple"}}}}
  ]

});

answered Mar 25 '14 at 08:59

Roberto

8,586
3
42
53

score 3 · Answer 3 · answered Mar 25 '14 at 11:43

3

Use $in and $nin to include and exclude

db.transactions.find({
  "things.stuff": {
    $in: ["banana"], 
    $nin:["apple"]
  }
})

answered Mar 25 '14 at 11:43

Shreyance Jain

914
7
12

Mongodb - Array containing element and not containing another one

3 Answers3