Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

Why doesn't work CriteriaBuilder like for camelcase

"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.

like image 456
jurabek rashidov Avatar asked Mar 27 '26 07:03

jurabek rashidov


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.

like image 107
leo277 Avatar answered Mar 29 '26 19:03

leo277