Hi all,

I have a one-to-many association so that a parent holds a collection of child objects and i want only to return these parents who have a child in the collection according to a specific name. But not only "Test" should return the parent but also "es".

class Parent{ public Set getChildren() }
class Child{ String name; }

<set name="children" inverse="true">
<one-to-many class="Child"/>
<filter name="childNameFilter" condition=":childNameFilterParam like name"/>
</set>

<filter-def name="childNameFilter">
<filter-param name="childNameFilterParam" type="string"/>
</filter-def>

public List getHistory() {
String hql = "from parent as p where size(p.children) >= 1";
HibernateUtil.currentSession().enableFilter("childNameFilter").setParameter("childNameFilterParam", "%es%");
Query query = HibernateUtil.currentSession().createQuery(hql);
}

Unfortunately I don't get any results for '%es%' search patterns. Any help appreciated! Thx!

The filter condition is incorrect. You should swap the arguments: