Hello,

I need your help for a query in HQL involving 3 classes.

class Configuration {
Long id;
Set<Item> items;
}

class Item {
Long id;
Configuration configuration;
Set<Translation> translations;
}

class Translation {
Long id;
Item item;
Locale locale;
...
}

I'm looking for Item, for a given Configuration, that don't have any Translation for a given locale.
Thanks in advance.
Francois

Look for examples in HQL/SQL that use "EXISTS" with a sub-query.