How to fetch data from multiple tables using lookup in same request.?

Ali_Haider1 · 2022-05-28T04:49:27.849Z

here is data model, i have nested array(orderList) where I have objects related to different collections e.g [companies, featuredProductsList, FeaturedBannner etc]. i have to send complete object to fe. how i can lookup from diffrent tables at the same request.

here is data model

[{
“_id”: “62541d653d00378feb2fc117”,
“orderList”: [
{
“type”: “featured-companies”,
“id”: [
“624c0a89b9298a2a0fa21941”
]
},
{
“type”: “banner”,
“id”: [
“624c0d25b9298a2a0fa21988”
],
“size”: 5
},
{
“type”: “featured-products-list”,
“id”: [
“624c0b1ab9298a2a0fa21964”
]
}
]
}]

steevej · 2022-05-30T12:52:21.395Z

Please read Formatting code and log snippets in posts and publish sample documents from all input collections and sample of documents of the expected result. Make sure it is JSON text that we can easily cut-n-paste into our server instance.

Also publish what you have tried and indicate how it fails to provide the desired results. This will save us time by not pursuing a solution you already rejected.