hql question

anarkhos · **Posted:** Fri Jan 23, 2004 8:36 am

Hi,
I have a class named "Configuration" which has "nodes" collection, which is a component collection.The component (SdhNode) that comprises the elements of nodes collection has many to one association to class "Salon".
I would like to run a query that returns the Configuration instances that has both salon1 and salon2 (which are instances of Salon class) in their nodes.
How can this query be represented with HQL?
Thanks in advance.

michael · **Posted:** Fri Jan 23, 2004 1:10 pm

I suppos salon1 and salon2 are both objects you allready have? Try something like this:

select c from Configuration c join c.nodes as node where :salon1 in elements(node.salons) and :salon2 in elements(node.salons)

Let me know if this works, it is just off my head.

anarkhos · **Posted:** Sun Jan 25, 2004 11:30 am

thanks but i think there is a misunderstanding. a node doesn't have many salons. a node has only one salon as many to one association. actually i am searching for the Configuration instance, which satisfies both queries below;

from SdhKonfigurasyon as konf join konf.nodes as node where node.salon=:salon1
from SdhKonfigurasyon as konf join konf.nodes as node where node.salon=:salon2

cheers,
Ahmet

emmanuel · **Posted:** Mon Jan 26, 2004 1:52 am

Does this work ?

Code:

from SdhKonfigurasyon as konf join konf.nodes as node where node.salon in(:salon1, :salon2)

anarkhos · **Posted:** Mon Jan 26, 2004 4:00 am

nope. that query finds SdhKonfigurasyon instances that either satisfies query 1 or query 2 I have mentioned in previous post. the instance i am seeking is SdhKonfigurasyon which has both salon1 and salon2 as salon property in its nodes

michael · **Posted:** Mon Jan 26, 2004 5:33 am

How about this one:

Code:

from SdhKonfigurasyon as konf join konf.nodes as node join konf.nodes as node2 where node.salon = :salon1 and node2.salon = :salon2

anarkhos · **Posted:** Mon Jan 26, 2004 7:36 am

thanks a lot! this one works.