I got the error from documentdb
Aggregation stage not supported: '$lookup on multiple join conditions and uncorrelated subquery
how to fix this do you have any solution for solving this problem?
i have 3 document to join this is lookup command
{
from: "subscribe",
let: {
program_id: "$program_id"
},
pipeline: [
{
$match: {
$expr: {
$and: [
{
$eq: [
"$program_id",
"$$program_id"
]
}
]
}
}
},
{ "$lookup": {
"from": "user_token",
"let": { "user_id": "$user_id" },
"pipeline": [
{
"$match": {
"$expr": {
"$eq": [ "$user_id", "$$user_id" ]
}
}
}
],
"as": "tokens"
}
}
// { "$wind": "$token" }
],
as: "subscribers"
}
Edited by: BECIDEV on Apr 17, 2020 1:02 AM
Edited by: BECIDEV on Apr 17, 2020 1:03 AM
Does it support it now?
Hi! any updates for uncorrelated subqueries?