MongoDB - How to find all objects within an array?

Question

I'm trying to find all elements within an array called programme. The result of running db.base.find({"programme.title":"News"},{"programme.$.title":"News"}).pretty() is:

{
"_id" : ObjectId("55a48dd3e72db9d63e53478b"),
"programme" : [
    {
        "attributes" : {
            "start" : "20150713010000 -0400",
            "stop" : "20150713013000 -0400",
            "channel" : "I47176.labs.zap2it.com"
        },
        "title" : "News",
        "category" : "News",
        "episode-num" : "SH01831861.0000",
        "new" : true
    }
]
}

But there are many more entries called "News", not just one, as shown above.

I've also tried db.base.find({"programme.title":"News"}).pretty() but that just results in listing a bunch of random entries, whether or not they have the title of "News".

Thanks a lot for the help, and obligatory "apologies for noob question".

Yathish Manjunath · Accepted Answer · 2015-07-14 05:40:56Z

1

You can achieve with the help of Aggregation as below :

 db.base.aggregate([
    {$unwind : "$programme"},
    {$match : { "programme.title" : "News" } },
   {$group : { "_id" : "$_id" , "programme" : { $push: "$programme" } } }
]);

answered Jul 14, 2015 at 5:40

Yathish Manjunath

2,0371 gold badge17 silver badges24 bronze badges

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

Comments

Blakes Seven · Accepted Answer · 2015-07-14 06:13:44Z

0

Projection to a match in MongoDB .find() queries can only return the "first" element matching your conditions.

So to get "multiple" matches your best approach is using .aggregate() and $redact, with first filtering the documents with $match:

db.base.aggregate([
    { "$match": { "programme.title":"News" } },
    { "$redact": {
        "$cond": {
            "if": { "$eq": [ { "$ifNull": [ "$title", "News" ] }, "News" } ],
            "then": "$$DESCEND",
            "else": "$$PRUNE"
        }}
    }}
])

This "removes" ("redacts") any entries from the array that do not match the "title" you are giving.

This is a good approach since you are not creating more documents in the pipeline using $unwind, which is another way to work with arrays.

The catch is that you cannot have another element in your document with the same property name "title", as the $$DECEND walks into the structure and compares the field names at each level.

edited Jul 14, 2015 at 6:13

answered Jul 14, 2015 at 4:54

Blakes Seven

50.5k14 gold badges132 silver badges136 bronze badges

2 Comments

Neo-coder Over a year ago

Some typo mistake IfNull should be ifNull

Neo-coder Over a year ago

another fingers raise here "else": "$$KEEP" should be "else": "$$PRUNE"

Collectives™ on Stack Overflow

MongoDB - How to find all objects within an array?

2 Answers 2

Comments

2 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

2 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related