There surely is a repository query. It's just a fact that I haven't found it yet.
You might want to try Metaquery; with the help of your DBAs you should be able to identify the SQL query needed to perform what you need, meaning you would use Metaquery just to get the SQL query. ;-)
I think we got hold of a repository query. tx
Here are 2 examples from the KB:
These are just to get you started and will definitely need to be tweaked to meet your requirement.
I think these are for Relational Connections only.
I am not sure if it is possible to get Relational and FF BOTH in the same query as they are possible in separate tables.