How can I provide multiple criteria for an attribute within an element of array in mongo query?

Question

I have a collection with following documents:

    {
       "_id": 1,  
       "books": [  
         {  
           "id":"Sherlock Holmes",  
           "category":"Novel"  
         },  
         {  
           "id":"10 tips for cook",  
           "category":"Tips"  
         }  
       ]  
    },  
    {  
       "_id": 2,  
       "books": [    
         {
           "id":"10 tips for cook",  
           "category":"Tips"
         }  
        ]  
    },  
    {
       "_id": 3,  
       "books": [  
         {  
           "id":"Sherlock Holmes",  
           "category":"Novel"  
         }  
       ]  
    }

I want to query document contains both books with id "Sherlock Holmes" and "10 tips for cook", where its "_id" is 1.

I've tried with $in and $elemMatch but the results are those three. I only need one in this case.

Do you have any solutions?

What MongoDB version are you using?

Konstantin Yovkov
– Konstantin Yovkov

2015-05-15 08:48:54 +00:00
Commented May 15, 2015 at 8:48 — Konstantin Yovkov
– Konstantin Yovkov, Commented May 15, 2015 at 8:48
I use MongoDB v2.4.5

Thánh Ma
– Thánh Ma

2015-05-15 10:36:09 +00:00
Commented May 15, 2015 at 10:36 — Thánh Ma
– Thánh Ma, Commented May 15, 2015 at 10:36

thegreenogre · Accepted Answer · 2015-05-15 08:53:28Z

4

Use the $and operator to search for the same field with multiple expression.

db.coll.find({
    '$and': [
        {'books.id': 'Sherlock Holmes'},
        {'books.id': '10 tips for cook'}
    ]
})

Result:

{
    "_id" : 1,
    "books" : [ 
        {
            "id" : "Sherlock Holmes",
            "category" : "Novel"
        }, 
        {
            "id" : "10 tips for cook",
            "category" : "Tips"
        }
    ]
}

answered May 15, 2015 at 8:53

thegreenogre

1,57911 silver badges22 bronze badges

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

Comments

Toan Nguyen · Accepted Answer · 2015-05-15 09:00:48Z

0

Because _id is unique in a MongoDB collection, so you can just query

db.myCollection.find({_id:1})

And if you don't want the whole document to be returned, you can use projection

db.myCollection.find({_id:1},{_id:0, books:1})

answered May 15, 2015 at 9:00

Toan Nguyen

11.6k5 gold badges46 silver badges61 bronze badges

1 Comment

Thánh Ma Over a year ago

I need it returns a list that match my criteria. The result should be a list. In this case, the list contains one element only :)

Collectives™ on Stack Overflow

How can I provide multiple criteria for an attribute within an element of array in mongo query?

2 Answers 2

Comments

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related