using "in" in HQL over a Set

ogross · **Joined:** Thu Mar 25, 2004 9:13 am **Posts:** 20

I want to use HQL "in" option in the following way:

Code:

public void foo(Set s) {
    String q = "select request from request in class " + getTheClass()
                + " where request.networkId in elements(...)";

    ...
}

while the ... in the elements() should be replaced by the Set that the method gets as an argument. How is it done? I could find an example for it.

TIA Oren

gavin · **Posted:** Mon Jun 14, 2004 8:58 am

use a collection filter?

ogross · **Joined:** Thu Mar 25, 2004 9:13 am **Posts:** 20

Can you please elaborate on that? the only place I read about filter() is at http://www.hibernate.org/hib_docs/refer ... tions.html and I don't see how it help me.

TIA

ogross · **Joined:** Thu Mar 25, 2004 9:13 am **Posts:** 20

found it...

Code:

List names = new ArrayList();
names.add("Izi");
names.add("Fritz");
Query q = sess.createQuery("from DomesticCat cat where cat.name in (:namesList)");
q.setParameterList("namesList", names);
List cats = q.list();

from chapter 9.3.2. The Query interface