I have to migrate an SQL query to QueryDSL with hsearch. But this time, SQL query is a bit more complex than simply predicates ; it contains a subquery with exists clause.
Here the link to the SQL query with annotations :
SQL query with subqueries
My problem is how to code the joins operations between query and subqueries with hSearch ? (in green)
EDIT : on the picture “…” means ommitted (unecessary) SQL code.
thank for your help.