Fetched Matched Array data in MongoDB

Question

I have an MongoDB object like:

{
  "user" : ObjectId("60e5f88159292f575c0ca17f"),
  "questions" :[
     {
       question 'aaaaaaa',
       id :'1'
     },
     {  
       question 'bbbbbbb',
       id :'2'
     },
     {
       question 'ccccccc',
       id :'3'
     }
   ]
}

I want to pass an array of questions id ['1', '3'] and user object id. I want to fetch the question which matches the questions id and user.

My expected output should look like this:

{
  "user" : ObjectId("60e5f88159292f575c0ca17f"),
  "questions" :[
     {
       question 'aaaaaaa',
       id :'1'
     },
     {
       question 'ccccccc',
       id :'3'
     }
   ]
}

How can I do this?

Hussam · Accepted Answer · 2021-07-08 11:24:28Z

1

This is one way to achieve this using aggregate.

[
  {
    "$unwind": "$questions"
  },
  // filter out questions
  {
    $match: {
      "questions.id": {
        $in: [
          "1",
          "3"
        ]
      }
    }
  },
  // regroup to original structure
  {
    $group: {
      _id: "$_id",
      questions: {
        $push: "$questions"
      },
      user: {
        $first: "$user"
      }
    }
  }
]

https://mongoplayground.net/p/LQmC6VG4s_S

answered Jul 8, 2021 at 11:24

Hussam

1,72612 silver badges20 bronze badges

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

Collectives™ on Stack Overflow

Fetched Matched Array data in MongoDB

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