0 Replies Latest reply on Apr 12, 2006 4:04 AM by Mirko Adari

    Advanced query (help needed)

    Mirko Adari Novice

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