Aggregation stage not supported:lookup on multiple join conditions

1

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

BECIDEV
asked 4 years ago1800 views
2 Answers
0

There's no workaround for now, the $let and $expr operators are not supported and are needed in order to achieve this extension to $lookup. As we are working backwards from customer needs, these operators may be supported in the future versions of the service.

AWS
Mihai A
answered 2 years ago
  • Does it support it now?

  • Hi! any updates for uncorrelated subqueries?

0

Same case here, any one know how to workaround?

answered 3 years ago

You are not logged in. Log in to post an answer.

A good answer clearly answers the question and provides constructive feedback and encourages professional growth in the question asker.

Guidelines for Answering Questions