Hello,

imagine that I have the following object

public class Process {
...
Set ActivityList;
...
}

public class Activity {
...
Process process;
String name;
...
}

I want to use HQL to retrieve all Processes where activities with name equals "BLABLA"

with a WHERE clause expression like

... WHERE process.activityList.name="BLABLA"

Is the WHERE clause syntax correct ?? Meaning is it possible to use these syntax with a Set ?

Thx in advance.

no. please see the FAQ and the HQL documentation. You need to use a JOIN in the FROM clause.