HQL Wizard
The HQL wizard should be shown from code completion of facade class.
Sreenshot:
It generates this code:
public java.util.List getFiatForTown(java.lang.String addressTown) {
Session session = store.HibernateUtil.currentSession();
org.hibernate.Query query = session.createQuery(
" select user " +
" from " +
" User as user " +
" join user.address as address " +
" join user.car as car " +
" where " +
" address.town = ? " +
" and (car.type = \"fiat\" " +
" OR (user.age < 50 " +
" AND user.age > 20) " +
" ) ");
query.setParameter(0,addressTown);
return query.list();
}