Why doesn't work CriteriaBuilder like for camelcase

user_12069344 0
Viewed 141

"builder" is object which from CriteriaBuilder interface

   Join<SedIncomeLettersEntity, CrExternalCompanyEntity> join = root.join("crExternalCompanyEntity");

builder.like(join.get("title"), "%" + value + "%");

this is working but doesn't work camelcase.

spring-mvc specifications jpa spring java
1 Answers

IIRC like is not case insensitive and you need to manually do something like:

builder.like(builder.lower(join.get("title")), "%" + value.toLowerCase() + "%");

Hopefully that's what you need.

user_91185530
Related