If you use some CODING, this should be possible.
This here could be very similar to your needs…
https://www.wix.com/velo/forum/community-discussion/simplify-same-query-on-multiple-database-collections
If you use some CODING, this should be possible.
This here could be very similar to your needs…
https://www.wix.com/velo/forum/community-discussion/simplify-same-query-on-multiple-database-collections