nested query in mongodb

Question

How can I query for all tags in following document in mongoDB 2 or 3:

{
    "_id" : ObjectId("55dc45017137a4e70b8b4569"),
    "campainName" : "",
    "themeName" : "theme1",
    "emailListName" : "eiEmails",
    "emailSubject" : "",
    "emailFrom" : "",
    "allNews" : [ 
        {
            "type" : "1",
            "tag" : ['aa','bb','cc'],
            "link" : "",
            "image" : ""
        }
    ]
},
{
    "_id" : ObjectId("55dc45017137a4e70b8b4570"),
    "campainName" : "",
    "themeName" : "theme2",
    "emailListName" : "afaeiEmails",
    "emailSubject" : "",
    "emailFrom" : "",
    "allNews" : [ 
        {
            "type" : "1",
            "tag" : ['da','db','dc'],
            "link" : "",
            "image" : ""
        }
    ]
}

I need something like this in result:

{['aa','bb','cc'], ['da','db','dc']}

I need style of query in doctrine odm.

evanchooly · Accepted Answer · 2015-08-25 13:10:05Z

1

Try something like this:

db.collection.find({}, {"allNews.tag" : 1, _id : 0})

answered Aug 25, 2015 at 13:10

evanchooly

6,2761 gold badge18 silver badges24 bronze badges

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

2 Comments

evanchooly Over a year ago

it will get you this:

{   "allNews": [     {       "tag": [         "aa",         "bb",         "cc"       ]     }   ] } {   "allNews": [     {       "tag": [         "da",         "db",         "dc"       ]     }   ] }

Which is probably as close as you'll get without using an aggregation pipeline.

Majid safaei Over a year ago

the answer is correct for this document paste.ubuntu.com/12192513 not for question's document. allNews is a list.

Collectives™ on Stack Overflow

nested query in mongodb

1 Answer 1

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related