Query on an array of documents with MongoDB

Question

I have a collection with two documents:

{
    "type":"s",
    "disp":[
        {
            "quantity":1,
            "date":20141109
        },
        {
            "quantity":1,
            "date":20141110
        }
    ]
},
{
    "type":"d",
    "disp":[
        {
            "quantity":1,
            "date":20141109
        },
        {
            "quantity":0,
            "date":20141110
        }
    ]
}

I have to make a query (with one or more dates) to retrieve a document where all the given dates have a quantity greater than 0.

So if I search for a date 20141109 then I have to retrieve both but searching for 20141110 or both dates 20141109 and 20141110 should return only type "s" as it's the only with a quantity bigger than 0 for every dates used as parameters

P.S. sorry for my English, it's not my first language

wdberkeley · Accepted Answer · 2014-11-10 18:13:12Z

2

To do such a match for one date, use $elemMatch:

db.test.find({ "disp" : { "$elemMatch" : { "quantity" : { "$gt" : 0 }, "date" : 20141109} } })

For multiple dates you will need to combine queries like the above using $and:

db.test.find({ "$and" : [
    { "disp" : { "$elemMatch" : { "quantity" : { "$gt" : 0 }, "date" : 20141109 } } },
    { "disp" : { "$elemMatch" : { "quantity" : { "$gt" : 0 }, "date" : 20141110 } } }
] })

answered Nov 10, 2014 at 18:13

wdberkeley

11.7k1 gold badge30 silver badges24 bronze badges

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

1 Comment

Edo Over a year ago

I just wonder if there's a way to get only the "disp" elements matched

Collectives™ on Stack Overflow

Query on an array of documents with MongoDB

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related