Criteria question

andrepena · **Joined:** Thu Sep 13, 2007 4:00 pm **Posts:** 11

Hi all,
I'm just starting with Hibernate.
I have a Product class that has a collection of UserPermission type.
I want to get a list of all products that HAVE a UserPermission which UserCode equals 12345.

How do I do that?

Thanks in advance

sethrohit1977 · **Joined:** Mon Jan 22, 2007 10:32 am **Posts:** 101

select p from Product P where p.UserPermission.UserCode=12345

Hope that helps else you can go through this link in order to have more info on querying.

http://www.hibernate.org/hib_docs/v3/re ... /#queryhql

andrepena · **Joined:** Thu Sep 13, 2007 4:00 pm **Posts:** 11

thanks Seth. I forgot to say that I was expecting the result via Criteria. Can you help me?

sandipgaikwad3107 · **Joined:** Thu Oct 04, 2007 5:00 am **Posts:** 13

Criteria API lacks way of subselecting within a collection
please follow the link:-
http://opensource.atlassian.com/project ... e/HHH-1509

Sandip Gaikwad.

sethrohit1977 · **Joined:** Mon Jan 22, 2007 10:32 am **Posts:** 101

Try this for criteria api

List product = session.createCriteria(Product.class)
.createAlias("UserPermission", "up")
.add( Restrictions.eq("up.UserCode", 12345) )
.list();

Go through this link for more info on criteria queries

http://www.hibernate.org/hib_docs/v3/re ... rycriteria