How do I get the value of a returned $filter match?
for example using this code ...
db.col.aggregate([
{$project : {
"Place" : {$filter: {input: "$fields",as: "field",cond: { $eq: [ "$$field.name", "ABC" ]}}},
}}
]);
I would get
[{"name":"ABC" ,"value":"DEF"}]
as the value of Place. I am wondering how to get just the value (DEF)
Thanks to the comment from Yogesh, figured it out
..wondering if there is a way to single-project it.