Select specifics items from array objects in mongoose

Question

I have an mongoDB objetc like :

[
  {
    "items": [
      {
        "title": "hello",
        "options": [
          {
            "value": "A",
            "image": "img1",
            "des": "des1"
          },
          {
            "value": "B",
            "image": "img2",
            "des": "des2"
          },
          
        ]
      }
    ]
  }
]

When I retrieve data from the collection, I want to retrieve only value key from the options of the items array.

Output should look like :

{
 "items":[
  {
     "options" :[
       {  "value" :"A" },
       {  "value" :"B" },
   ]
  }
 ]
}

How can i do this?

use projection { "items.options.value": 1 } see more about projection. — turivishal
– turivishal, Commented Jun 5, 2021 at 7:40
turivishal If you specify the query it would be helpful for me. Thanks — Mijanur Rahman
– Mijanur Rahman, Commented Jun 5, 2021 at 7:48
it is same you can use projection as per my comment, if you want to use aggregation then see $project — turivishal
– turivishal, Commented Jun 5, 2021 at 7:48
if you see the attached links in comment, its easy to use, just follow the instructions as per documentation. it is not hard to understand I think you just have to use { "items.options.value": 1 } projection simple. — turivishal
– turivishal, Commented Jun 5, 2021 at 7:50

NeNaD · Accepted Answer · 2021-06-05 07:59:33Z

1

You can do it like this:

db.collection.find({}, { "items.options.value": 1})

Here is the working example: https://mongoplayground.net/p/FqDaQ7Q-y-Y

Or you can do it like this:

db.collection.aggregate([
  {
    "$project": {
      "items.options.value": 1
    }
  }
])

Here is the working example: https://mongoplayground.net/p/jPFYtXYBvpI

edited Jun 5, 2021 at 7:59

answered Jun 5, 2021 at 7:54

NeNaD

20.8k11 gold badges64 silver badges118 bronze badges

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

Collectives™ on Stack Overflow

Select specifics items from array objects in mongoose

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related