Sort data ignoring case

[SShahmuradli]

I am faced with the task of making data sorting case insensitive. Solving a problem using blazebit does not seem like a primitive task. How can I sort by sortBy ignoring the case? Thanks in advance!

public getResultForQuery(
CriteriaBuilder criteriaBuilder,
String sortBy,
boolean asc
) {
...
List resultList = criteriaBuilder.orderBy(sortBy, asc).getResultList();
...
}

[jwgmeligmeyling]

Case insensitive ordering can be achieved by simply ordering by the lower or uppercase of the string. You'd do this the same in plain JPQL. So criteriaBuilder.orderBy("UPPER(sortBy)", asc).