Case insensitive Restriction.IN

Question

I've googled a bit but found no decent solutions...

What i would like to achieve, source comes firts :)

 List<MyStuff> result =
 session.createCriteria(MyStuff.class)
 .add(Restrictions.in("name", templates)).list();

templates is a Collection, thing is, I would like to get all myStuffs, that have name column matching-CASE-INSENSITIVELY to any of templates.

Possible without looping and iliking for every element of templates?

score 2 · Answer 1 · edited May 23 '17 at 12:08

2

Unfortunately this feature is not implemented in the Criteria API. You must implement your own InExpression. See the answer in Ignorecase for In-Criterion

edited May 23 '17 at 12:08

Community

1
1

answered Jul 18 '12 at 20:55

Cengiz

5,375
6
52
77

Case insensitive Restriction.IN

1 Answers1