How to query an array in an array of objects in mongodb?

Question

I am pretty new to mongodb, and I am not able to query in my mongo collection.

Structure :

"chapterId":1,
"videos" : [ 
        {
            "videoId" : "1",
            "videoName" : "about",
            "duration" : "12:36",
            "tags":["business", "design"]
        }, 
        {
            "videoId" : "2",
            "videoName" : "course",
            "duration" : "04:00",
            "tags":["technology", "design"]
        }
]

I need to select all videos with the tag "business" in chapterId 1.

Can this be done without changing the structure of my collection ?

Neo-coder · Accepted Answer · 2014-12-23 14:38:49Z

3

You should use aggregation so below query will help you

db.collectionName.aggregate(
          {"$unwind":"$videos"},
          {"$match":{"chapterId":1,"videos.tags":"business"}}
          )

answered Dec 23, 2014 at 14:38

Neo-coder

7,8585 gold badges36 silver badges54 bronze badges

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

Collectives™ on Stack Overflow

How to query an array in an array of objects in mongodb?

1 Answer 1

Comments

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Related