CODEWITHSUNDEEP
hibernatehibernate-criteria
wilu
wilu

Reputation: 559

Case insensitive Restriction.IN

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?

Upvotes: 6

Views: 3985

Answers (1)

Cengiz
Cengiz

Reputation: 4867

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

Upvotes: 2

Related Questions