MongoDB: How to find specific value in nested array, if found then show only that array not all?

Question

[![enter image description here][1]][1]

I am trying to find id "D0182" in client_id array if found then only it will show the client_id document, but it is showing me the whole document.

Here is my query -

db.getCollection('news').find({"newsSources.client_id":"343a","date": "2021-01-22"}, {"_id":0,"newsSources.title" :1, "newsSources.client_id":1})

Can you post the document as a code snippet instead of image! — varman
– varman, Commented Jan 22, 2021 at 13:20
And Id know that the client_id is inside the newsSources. Do you need to filter only the object inside the array or you need to get all documents which has the client_id in your collection? — varman
– varman, Commented Jan 22, 2021 at 13:23
as you can see in the image above client_id: ["W0086"] is also displayed, I am trying to show only that [client_id] array which has the value ["D0182"] , if not then it should hide not displayed — Utsav Upadhyay
– Utsav Upadhyay, Commented Jan 22, 2021 at 13:30

varman · Accepted Answer · 2021-01-22 13:47:34Z

2

You can use aggregation to filter out objects from array.

db.collection.aggregate([
  {
    "$addFields": {
      "newsSources": {
        $filter: {
          input: "$newsSources",
          cond: {
            $in: [
              "D0108",
              "$$this.clientId"
            ]
          }
        }
      }
    }
  }
])

Working Mongo playground

answered Jan 22, 2021 at 13:47

varman

8,9326 gold badges25 silver badges56 bronze badges

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

Collectives™ on Stack Overflow

MongoDB: How to find specific value in nested array, if found then show only that array not all?

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