Hello everyone,

I need some help with HQL. I have and object X and it has a list of Ys and the Y object as an attribute Id. I pass to the where clause a list of Ids and I need a list of all my X's where any of its Y's has either one or more Ids I passed.


Just to illustrate the objects relationships:

Iterator i = X.getYs().iterator();

while(i.hasNext())
{
Y y = i.next();
Integer id = y.getId();
}

from the docs (8.3.2. The Query interface):

Query q = session.createQuery("select x from X x join x.ys y where y.id in (:ids)");

q.setParameterList("ids", someCollection);

Ok, thanks for the help.

Just out of curiosity. Here is what I had done


from x as o , o.ys as list where list.id in (ids)


would it work?

ok. now I have


from x as o join o.ys as list where list.id in (:ids)

What if X has an attribute date and I only want ro return de min(date)?

What do you think of reading the reference guide.
The chapter 8.3 for example.