0 Replies Latest reply on Apr 15, 2006 8:49 PM by Mirko Adari

    help with query

    Mirko Adari Novice

      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();