Hello,
This is probably a general JPA questions rather than OpenJPA, perhaps you'll
permit:
I can do this in SQL:
select * from users where lower(userCode) in ('ab', 'cd');
to do a case indifferent (insensitive) match, assuming 'ab' and 'cd' already
lowercase. The following fails in JPQL:
select o from User as o where lower(o.userCode) in ('ab', 'cd')
(Encountered "lower ( o . userCode ) in" at character ...)
Can I reform this somehow to do a case insensitive "IN" expression. (I have
literal values here in the list, but I'm using a Set<String> in the real
query).
Thanks.
--
Daryl Stultz
_____________________________________
6 Degrees Software and Consulting, Inc.
http://www.6degrees.com
http://www.opentempo.com
mailto:[email protected]
