|
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
|