I need to find a list of users who have a collection with an object with a property that has a value. Wow, that's a mouthful. Here's a simplification of my domain model:

User -> interests (List) -> interests -> relationId

I need to find a User who has an interest that has a relationId matching a value I'm inputting. Does anyone know how to do this?

get all users objects by HQL

from Users;

then iterate each users object and get interest list, after that get each interest and check out with ur realtionid , if it is map copy that object to new users object.

Iterator rs=session.createQuery("from Users");
while(rs.hasNext())
{
Users u =(Users) rs.next();
List<Interest> inter=u.getInterest();
for(int i=0;i<inter.size();i++)
{
Interest it=inter.get(i);
if(it.getRelationId()==myRelationId) //ur Id comparision
sys.out.print(u.getName());
}
}


like that u will get all users with ur relationId...

You can try the following HQL:

Thanks for your replies. Nikolai, is there a way to reproduce the equivalent of your HQL in the Criteria API?

I want to do most of the work in my select statements rather than handfilter the results on the Java side. I got it working by iterating through the result lists as Madan suggested, but I'd like to not have to iterate over lists and let Hibernate just filter the results from the database.

List Users= sess.createCriteria(Users.class)
.createAlias("interests", "inter")
.add( Restrictions.eqProperty("inter.relationId ",relationid) )
.list();