JPA findBy field ignore case

Question

How do I make findByIn search using IgnoreCase of <Field>? I tried to use findByNameIgnoreCaseIn and findByNameInIgnoreCase with no result. DB is Postgresql.

@Repository
public interface UserRepository {
    List<User> findByNameIgnoreCaseIn(List<String> userNames);
}

@v.ladynev it's a spring data repository where programmer don't have to provide the implementation. — Sangram Jadhav, May 30 '16 at 11:50
I suppose Spring data/jpa **IgnoreCase** keyword does not work with **In** Keyword. — Sangram Jadhav, May 30 '16 at 11:59
Possible duplicate of [Case insensitive Query with Spring CrudRepository](http://stackoverflow.com/questions/22573428/case-insensitive-query-with-spring-crudrepository) — Piotr Chowaniec, Sep 29 '16 at 10:03

score 21 · Answer 1 · edited May 31 '16 at 05:05

21

Try something like this:

List<User> findByNameInIgnoreCase(List<String> userNames);

edited May 31 '16 at 05:05

Laurel

5,965
14
31
57

answered May 31 '16 at 03:58

Sumeet Tiwari

343
2
11

this worked for me. put in the IN before the ignorecase – incognito nerd Nov 28 '22 at 19:57

score 14 · Accepted Answer · answered Apr 25 '19 at 09:19

As I understood IgnoreCase is not supported with In key, so I changed code this way:

@Repository
public interface UserRepository {
    @Query("select user from SysUser user where upper(name) in :userNames")
    List<SysUser> findByNameIgnoreCaseIn(@Param("userNames") List<String> userNames);
}

and previously upper case userNames values.

JPA findBy field ignore case

2 Answers2