Hi,

I would like to do something like this, written in the FAQ :



It's ok, if a parent has 3 childs and one's name is :name, i'll get the parents but when I do



I have the 3 childs in listChilds, altough I expecteed to have only the Child named :name.

Somebody knows if there's a way in the mapping or in the hql query to write something to have where condition upon child and having the parent with only the childs that match the where condition.

Thanks in advance

This is correct behaviour. When you do a parent.getChildren it returns the children of the parent. There are 3 and thus you will get 3. Just because you used a restriction to find the parent, doesn't mean that it doesn't have 3 children any more. Thus your logic is to find the parent that has a child in with that name - and then ask the parent for all it's children.

What you could do is to add a method in your childDAO (or whatever) that is something like getChildByParentAndName(Parent parent, String name) which has the hql "from child c where c.parent=? and c.name=?" etc etc

Alternatively just get the child with the name and then ask it for it's parent...

Thank you for the answer.

Sure, your answer is what I finally did, and I agree with the fact that the parent has still 3 childrens...

But in the first verison of my application I had to display all parents with all the childrens so I had a simple query :



and the lazy loading gets me all the children...


Now, in the second version, I need to display the children only if there name is :name, I though HBN had a solution to change my query without having to change my code...

Maybe with the "where" or "subselect" attribute in the parent's mapping ?



But I can't figure out to set a parameter...