filtering with a list of ids

stbill79 · **Joined:** Wed Dec 05, 2007 1:30 pm **Posts:** 5

Is something like the following possible with HQL:

String query = "from <somentity> a join... .... where a.id in :theList"

And then pass in a collection/array of ids as the 'theList' parameter

Though this seems like a common thing to want to do, the only work-around is some sort of ugly string hack, eg:

Code:

String s = "(";
for(Long id : theList){
  s += id + ", ";
}

//truncate the last comma, then add the closing parenthesis to the string...

Thanks
Bill

gonzao_diaz · **Joined:** Mon Nov 26, 2007 2:29 pm **Posts:** 443

Don't know about HQL, but one of the Restrictions that you can add to a Criteria query is "Restrictions.in( collection )"

stbill79 · **Joined:** Wed Dec 05, 2007 1:30 pm **Posts:** 5

thanks so much - that was exactly what I was looking for!