Right way of querying a collection

[thierry.rietsch]

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