How to query in multiple collections by a single query

Moyen_Islam · February 21, 2023, 1:15pm

I am working in an accounting related where project where I need query in five collection and get filtered data. Is this possible in MongoDB and I won’t use $lookup.

Benjamin_Flast · February 21, 2023, 1:39pm

Hey @Moyen_Islam ,

I think we’ve chatted about Data Federation before, is there a reason it would not work here?

You should be able to create a virtual collection in Atlas Data Federation and then set the 5 collections as “Data Sources” for that virtual collection.

Best,
Ben

Moyen_Islam · February 22, 2023, 5:08am

Thank you very much. I got what I actually wanted. Thank you for your help.

system · February 27, 2023, 5:09am

This topic was automatically closed 5 days after the last reply. New replies are no longer allowed.