Equivalent of Restrictions.in for HQL

Paul Newport · **Posted:** Tue Apr 12, 2005 7:33 am

In Hibernate 3, you can use Restrictions.in to filter a criteria based on the values of a collection.

Is there an equvialent in HQL so rather than hard coding the values as below

Code:

from DomesticCat cat where cat.name not in ( 'Foo', 'Bar', 'Baz'

I can do something like this instead ?

Code:

from DomesticCat cat where cat.name not in ( :catNameList )

max · **Posted:** Tue Apr 12, 2005 8:02 am

paul, did you ever consider trying to look in the docs for this ?

Its right in there with the exact same syntax.

searching for " in (" on http://www.hibernate.org/hib_docs/v3/re ... ml_single/ will reveal it for you.

:)

/max

Paul Newport · **Posted:** Tue Apr 12, 2005 8:30 am

max wrote:

paul, did you ever consider trying to look in the docs for this ?

Yes, I looked through the entire section on the where clause (14.7) and expressions(14.8) and the examples there where similar but referencing collections on mapped objects rather than collections passed in as parameters in the hql

I also did an entire search on the single html documention for in(, but not in ( as you suggested.

Thanks for pointing out the documentation location (its actually in the section on bind parameters for those who need to find it 10.4.1.4 as of the time of writing).

A slight amendment to the doucmentation might be useful, as I did look fairly hard for it.

Thanks though !

max · **Posted:** Tue Apr 12, 2005 8:36 am

how would an ammendment to the docs help here ? Its right there with how to bind parameters ?

/max

Paul Newport · **Posted:** Tue Apr 12, 2005 10:25 am

max wrote:

how would an amendment to the docs help here ? Its right there with how to bind parameters ?

/max

because its just mentioned in passing as an example of a named parameter in the bind parameters section as opposed to being explicitly mentioned in the section on the where clause.

If it had been here

Code:

in and between may be used as follows:

from DomesticCat cat where cat.name between 'A' and 'B'

from DomesticCat cat where cat.name in ( 'Foo', 'Bar', 'Baz' )

from DomesticCat cat where cat.name in ( :catNameCollection )

I would have found it straight away.

Don't worry about it.

max · **Posted:** Tue Apr 12, 2005 10:38 am

so for every time we show a query with a constant we should show how you do it with bind parameters - that gets very redundant ,)

but we could probably improve it with a link to the bind parameter section. A contribution for this is welcome - but no promises ,)

/max