Hello,
I’m trying to use join to include product documents into an aggregate document
Given the following documents, is there a way to use join to include product documents into Document 1?
Document 1 (aggregate.1)
{
"id": "an id",
"items": [
{
"product_id": "3"
},
{
"product_id": "4"
}
]
}
Product Document (product.3)
{
"key1": "value1"
}
Product Document (product.4)
{
"key1": "value1"
}
Desired output
{
"id": "an id",
"items": [
{
"product_id": "3"
},
{
"product_id": "4"
}
],
"proudcts": [
{
"key1": "value1"
},
{
"key1": "value1"
}
]
}