1

Hi, I want to query data from different collections at the same time.
The collections maybe in same mongodb, maybe not.

I see the Querying Existing Query Results document but it seems only work for Mysql or other relational database but not work for mongodb.

Thanks

2

Anyone have the same problem?

3

You can query multiple collections using the $lookup aggregation. I wrote an example here on the forum.

Also, the Query Results Data Source can absolutely join results from several MongoDB queries. It doesn’t matter which source database you used. You can even join data from Mongo and MySQL together.