lookup between local (multiple)array of values and foreign (single) value

XMLWordPrintableJSON

    • Major Change
    • Query 11 (03/14/16), Query 12 (04/04/16)
    • None
    • None
    • None
    • None
    • None
    • None
    • None

      Example Order Document:

      {
    _id: ObjectId("..."),
    products: [ ObjectId("..<Car ObjectId>.."), ObjectId("..<Bike ObjectId>..") ]
}

      Not Working Query:

      db.orders.aggregate([ {
    $lookup: {
           from: "products",
           localField: "products",    <= array of IDs
           foreignField: "_id",
           as: "productObjects"
    }
} ])

      Desired Result

      {
  _id: ObjectId("..."),
  products: [
    ObjectId("..<Car ObjectId>.."),
    ObjectId("..<Bike ObjectId>..")
  ],
  productObjects: [
    {<Car Object>},
    {<Bike Object>}
  ],
}

      source: http://stackoverflow.com/questions/34967482/lookup-on-objectids-in-an-array

            Assignee:
            Charlie Swanson
            Reporter:
            Jose Antonio Illescas Olmo
            Votes:
            0 Vote for this issue
            Watchers:
            12 Start watching this issue

              Created:
              Updated:
              Resolved: