Can I give result of some mongo join in one array rather than multiple arrays.
Lets say i join
db.A.aggregate([
{$lookup:
{from: "B",
let: { q: "$q", r: "$r" },
pipeline: [
{ $match:
{ $expr:
{$or:[
{ $and:
[
{ $eq: [ "$Type","Abc" ] },
{ $eq: [ "$Number", "$$Number" ] }
]
},
{$and:
[ { $eq: [ "$Type","Email" ] },
{ $eq: [ "$Numbers", "$$Numbers" ] }
]
}]
}
}
}], "as": "Result"
}}
]).pretty()
Now it results multiple joined objects like
{
"_id" : {
"a" : "2",
},
abc:1,
"qwe" : [
"ert"
],
"Result" : [
{
"_id" : {
"a" : "2",
},
"emailAddresses" : [
"ert"
],
"dfg" : "dsf234"
}
]
},
{
"_id" : {
"a" : "3",
},
abc:1,
"qwe" : [
"ert"
],
"Result" : [
{
"_id" : {
"a" : 2",
},
"emailAddresses" : [
"ert"
],
"dfg" : "dsf234"
}
]
}
What I want is all result in single array and no result array like
[{
"_id" : {
"a" : "2",
},
abc:1,
"qwe" : [ "ert"],
[
{
"_id" : {
"a" : "2",
},
"emailAddresses" : [ "ert" ],
"dfg" : "dsf234"
}
]
},
{
"_id" : {
"a" : "3",
},
abc:1,
"qwe" : [ "ert"],
[
{
"_id" : {
"a" : 2",
},
"emailAddresses" : [
"ert"
],
"dfg" : "dsf234"
}
]
}
]
How can I achieve this!