In database forum noone did help me, but since `m writing an example for Seam
then maybe you can help me out.
My mappings:
Category has products and parameters.
Every Product has parameter entries(entry) and entry has parameter.
Basically I need to query out those parameters in the group that products has no entry for yet. Tried different versions but none got me further.
My current version:
List listItems = em.createQuery(
"from Parameter p join p.category c join c.products k join k.entries e where k.name = :product" +
" and e.parameter != p order by p.priority").setParameter("product",product).getResultList();