I'm trying to figure out the best way to provide a filtering to a collection-retrieval process. Imho, the filter/filter-dev combination is quite nice and basically what I need.

The only problem is, that one of the filters needs a variable list/set/array of inputs which I want to do via the SQL IN-operator.

I'd like to achieve something like this:


But I can't figure out how to get that to work, the reference documentation and hibernate in action don't seem to mention this either. Nor was I able to find it using the forum's searchengine.

I've also tried specifying type="long" and simply supplying an array of Long's.

Actually, what I really'd like to achieve is a filter like this (using a Map orso), but that seems to be even more out of reach:

I'm trying to figure out how to do this too, so if anyone knows please post it!

Most of the things I have tried ended with hibernate blowing up saying "Undefined filter parameter" but if I pack up an ArrayList an pass it into .setParameter() and define the type as "java.util.ArrayList" in the filter-def it doesn't blow up but it doesn't return any records either.

I'm playing with this case as well, if anyone has some updates how to get this up and running I would be very thankful.

I have just heard that this feature is not supported yet and i have raised a jira request for it.

Steve Ebersole fixed this issue in Beta 2, maybe you want to read the comments in JIRA Post HHH-77

What is the filter-param type for collections? does anyone know? set doesn't appear to work.

You can do like following. (Don't forget to rate answer)

session.enableFilter("secure")
.setParameterList("networkPlanIds", applicationUser.getNetworkPlanIds())

You give the type to be type of individuals in list. i.e:

<filter-param name="networkPlanIds" type="long"/>

Right, you need to set the filter type first, then set the parameter. For example, set this in the class for filtering a client table based on client ID:

<filter name="keyListFilter" condition="CLIENT_ID IN (:keyListParam)"/>

Then set this filter param, pass in a list identified by the name keyListParam and specify the type of values in the list:

<filter-def name="keyListFilter">
<filter-param name="keyListParam" type="long"/>
</filter-def>

Watch out for the type! You may think you are passing a list of "Long" objects, but in my experience somehow the array got converted to a list of primitive type "long" values.