Filter depending on association

BIZ TMS Aurelius
1
I have a master table along with a detail table and want to get all records of the matser, that have a record in the detail table, Meeting a condition.

In SQL this would be something like
select … from a where exists (select from b where .. )
or
select … from a where (select Count(*) from b where .. )>0

Using Aliases or subcriterias I run into this: Removing Duplicated Objects
As this is done at client side - any chance to get this done by the server?

Thank you!

2
If you mean using the XData query syntax through the query URL, then no, unfortunately that's not possible.
Aurelius also doesn't have such Exists syntax in Criteria object, you would have to use SQL condition and write the EXISTS clause directly as an SQL expression.
3
Yes, I am speaking about Aurelius.

I see - thank you.