0
668
ViewsMongoDB: How to find specific value in nested array, if found then show only that array not all?
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":"A0003","date": "2021-01-22"}, {"_id":0,"newsSources.title" :1, "newsSources.client_id":1})
·
Santiago Trujillo
1 answers
Answer question0
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
·
Santiago Trujillo
Report
Answer question