How to query in multiple collections by a single query

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.

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.


1 Like

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

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