Mongodb: Get Documents where ALL embedded Documents satisfy query

Question

I have the following query:

db.MyData.find( { "SubItems.EndDate" : { $lte : new Date() } })

Which returns me any document in my data where one of its embedded SubItems EndDate is in the past, but how do I alter this to return me the document only if all of its SubItems satisfy the query

In the below example my original query would return both documents but I only want it to return the second one.

{
    "_id" : 1,
    "name" : "item1"
    "SubItems" : [
        {
            "EndDate": ISODate("2016-10-01T00:00:00.000Z"),
        },
        {
            "EndDate": ISODate("2016-04-01T00:00:00.000Z"),
        },
    ]
}
{
    "_id" : 2,
    "name" : "item2"
    "SubItems" : [
        {
            "EndDate": ISODate("2016-02-01T00:00:00.000Z"),
        },
        {
            "EndDate": ISODate("2016-03-01T00:00:00.000Z"),
        },
    ]
}

Can you show us some sample documents and your expected output? — chridam, May 17 '16 at 07:33
refer http://stackoverflow.com/questions/10885044/mongodb-how-to-query-for-a-nested-item-inside-a-collection it might help to you — Hardipsinh Jadeja, May 17 '16 at 07:48

score 1 · Answer 1 · edited May 23 '17 at 12:08

1

After seeing this question

I managed to achieve what i needed with the following query:

edb.Bookings.find( { "ItineraryItems.EndDate" : { $not : {  $gt : new Date() } } })

edited May 23 '17 at 12:08

Community

1
1

answered May 17 '16 at 08:20

CeejeeB

3,034
4
25
32

Mongodb: Get Documents where ALL embedded Documents satisfy query

1 Answers1