Database query to filter data inside an object array

Question

I have bunch of documents in the following format in my mongodb, I am using moongoose as ORM.

Can some one help me make a query to get all the contents having the name=abc inside data-items.content

Document 1:

{
 "title": "Some title",
 "addresse": "data",
 "data-items": { 
 "content": [
   {
   "name": "abc",
   "age": "poster5.jpg"
   },
   {
    "name": "def",
    "age": "poster5.jpg"
   },
   {
    "name": "hij",
    "age": "poster5.jpg"
   }]
 }
}

Document 2:

{
"title": "another title",
"addresse": "data",
"data-items": {
  "content": [
    {
      "name": "abc",
      "age": "poster7.jpg"
    },
    {
      "name": "def",
      "age": "poster5.jpg"
    },
    {
      "name": "hij",
      "age": "poster5.jpg"
    }]
  }
 }

Any help is appreciated

mickl · Accepted Answer · 2019-03-21 23:00:36Z

1

You can simply use the dot notation to query an array of nested documents:

Model.find({"data-items.content.name": "abc"})

EDIT: to get only subdocuments matching your condition you can use below aggregation:

Model.aggregate([
    {
        $match: {
            "data-items.content.name": "abc"
        }
    },
    {
        $unwind: "$data-items.content"
    },
    {
        $match: {
            "data-items.content.name": "abc"
        }
    },
    {
        $replaceRoot: {
            newRoot: "$data-items.content"
        }
    }
])

$unwind will give you single document per content and $replaceRoot will promote it to the root level.

edited Mar 21, 2019 at 23:00

answered Mar 21, 2019 at 16:03

mickl

50.1k9 gold badges71 silver badges99 bronze badges

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

2 Comments

ArunBabuVijayanath Over a year ago

Yes, It works. Is there any way to just return matching objects rather than entire document?

mickl Over a year ago

@ArunBabuVijayanath modified my answer

Collectives™ on Stack Overflow

Database query to filter data inside an object array

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