0 Replies Latest reply on May 28, 2007 12:39 PM by thierry rietsch

    Right way of querying a collection

    thierry rietsch Newbie

      Hi all

      I try to get part of a collection over eql (or whatever the ejb query language is called). In the Hibernate tutorial it is suggested to use the criterias to get the data from a collection. As we are using JBoss Seam framework we would like to solve this problem directly over eql.

      @Entity
      // ...
      class SoftwareInventoryObject {
       // other code
       String name;
      
       @OneToMany
       List<SoftwareInventoryObjectPart> parts;
      
       // Getter & Setter
      }
      
      @Entity
      class SoftwareInventoryObjectPart {
       // other code
       String name;
       // other code
      }
      

      My first try was to get the SoftwareInventoryObject over this query:
      "from SoftwareInventoryObject sio where sio.name = 'foo' and sio.parts.name = 'bar'". Unfortunately this returned always a SoftwareInventoryObject with all related SoftwareInventoryObjectParts. How do I get only a part of this collection?

      Thank you very much for your help,

      Thierry