Hello,

We tried the following things:
- Dynamic filter (session.enableFilter(...))
- Filtering collection (session.createFilter(...))

The problem is that the filter condition is not on an attribute of the entity of the collection but on a related entity.
Here is what is meant
For instance, we have 3 entities Land, Address and BusinessCase.
They relate to each other in this way (cardinality in brackets)
Land(1) -> (*)Address(*) -> (1)BusinessCase

We want to filter the Addresses of Land based on a condition that requires an attribute of BusinessCase.

A solution with a subselect in the condition is not acceptable because the relation between Address and BusinessCase is defined with fetch mode 'join' in the hbm file and this will result in 2 accesses to the BusinessCase table.
The question therefore is how to write a filter condition involving a relation?

I don't have a solution to your problem. I posted the same issue yesterday https://forum.hibernate.org/viewtopic.php?f=1&t=1014388

The only thing I could find about it was this old JIRA issue https://hibernate.onjira.com/browse/HHH-298

Hopefully there is a better solution. I might create a new request in JIRA if nothing comes up.