HQL query.

arun.sharma · **Posted:** Fri May 15, 2009 3:32 am

Hi Friends,

I am not getting how to write a query in hql for following scenario:

I have object person and this object has reference to collection of addresses. Both are stored in different tables.
Now I need to fetch person objects with addresses only of type "addressType='ShippingAddress'". This addressType field is defined in Addresses class.

mmerder · **Posted:** Fri May 15, 2009 3:42 am

Try something like:

Code:

from Person p join p.adresses a where a.adressType = 'ShippingAdress'

arun.sharma · **Posted:** Sat May 16, 2009 4:18 am

I tried this one but its not providing the required results.
Actuly the condition "where a.adressType = 'ShippingAdress'" is not working.

mmerder · **Posted:** Mon May 18, 2009 5:40 am

What do you mean with not working? What is the result? Any exception?
Do you mean, that the person's collection still contains all addresses, but you want it to have only the filtered ones?