I recently started using hibernate to manage the queries in my webapplication, and encountered a problem for that I've found some forum posts but no satisfying answer.

I often have to fetch joined information from various tables, wherefore I'd like to use a Query element:



Now I want to filter the set fipo.gvfis as I only want to fetch certain entries.
A native SQL Query would look like this:



But as I searched for information on the issues it seems to be impossible to specify this kind of query in HQL.
The suggested workaround is to use filters, but I have no clue how this can be implemented?

Thanks for any hints,
Daniel

So far I think I can do what I described using the "with"-Keyword, see above.
But now that I applied the filter, how can I read the filtered associations?
When I use the getter() method of the main entity - Fipo.getGvfis() - in the query I will always generate a new query without the filter.



Or is it a better idea to use Criteria or native queries?
Thanks, Daniel