Hi,

Can I retrieve a subset of an entitys child collection with HQL? Or using Criteria?



I want the Query to return the Person together with a subset of the children collection.
For example, where children.id = 1;

Oh man! haha, that is similar to a question I've been asking around for a while now. But I will answer your question with a question and try to answer your particular situation, hopefully others will join in and have some better answers.

I am assuming that the children.id is the primary key of children. So why are you trying to retrieve a Person whose child is a unique child. In that case shouldn't you try to retrieve a child? and that child's parent will just be present within the Child bean?

Are you look more for getting a Person whose children have blue eyes or something like that? If that is the case I have used some things called filters. Filters have seem to have some restrictions when it comes to ordering and really puts a huge limitation, never really found a good way. I think hql would be ideal for you in this case. Maybe you can try something like this...



I am assuming something like that, I can test it out and let you know of you can test it out. I currently do not have access to the environment needed to test this. I am not too sure about the join syntax though. Check here for many types of joins... There is this with clause that you can use...
http://docs.jboss.org/hibernate/core/3. ... ryhql.html

Try this too...


Hope this is somewhat relevant to what you needed.

SB

Yes. I want only children having blue eyes. Or children meeting some other condition.
And my where clause doesnt 'take'.

Anyone? Can I use the WHERE keyword to as in:



to retrieve the Item and a subset of its products?

Or should I use the WITH keyword? Or special filtering methods in the Session?

Why don't you just try before asking?