PagingAndSortingRepository how to sort case insensitive?

Question

My Problem is that my code sorts the result case-sensitive.

Below you see my code:

    @GetMapping("/user/api_key_list")
    public ModelAndView apiKeyList(Model model,
                                   @RequestParam("pageSize") Optional<Integer> pageSize,
                                   @RequestParam("page") Optional<Integer> page,
                                   @RequestParam("sortBy") Optional<String> sortBy
    ) {
        ModelAndView modelAndView = new ModelAndView("user/apikeylist");
        int evalPageSize = pageSize.orElse(INITIAL_PAGE_SIZE);
        int evalPage = (page.orElse(0) < 1) ? INITIAL_PAGE : page.get() - 1;
        String sortOrder = sortBy.orElse(INITIAL_SORT);
        String[] sort = sortOrder.split(",");
        String evalSort = sort[0];
        String sortDirection = sort[1];
        Sort.Direction evalDirection = replaceOrderStringThroughDirection(sortDirection);
        Page<ApiKey> apiKeyList = apiKeyRepository.findAll(PageRequest.of(evalPage, evalPageSize, evalDirection, evalSort));
        PagerModel pager = new PagerModel(apiKeyList.getTotalPages(), apiKeyList.getNumber(), BUTTONS_TO_SHOW);
        modelAndView.addObject("apiKeyList", apiKeyList);
        modelAndView.addObject("selectedPageSize", evalPageSize);
        modelAndView.addObject("pageSizes", PAGE_SIZES);
        modelAndView.addObject("pager", pager);
        modelAndView.addObject("selectedSort", String.format("%s,%s", evalSort, sortDirection));
        modelAndView.addObject("sorts", SORTS);
        return modelAndView;
    }

My question is: How can I sort it case-insensitive?

MyTwoCents · Accepted Answer · 2018-06-12T12:21:03.200

3

Well if you are using spring-data-jpa you can do like this

Sort.Order order = new Sort.Order(Sort.Direction.ASC, "columnName").ignoreCase();

and pass this Order in query.

In your case

Page<ApiKey> apiKeyList = apiKeyRepository.findAll(PageRequest.of(evalPage, evalPageSize, new Sort(order)));

Edit 1:

For newer version of Spring above method is deprecated.

just adding code added by Dullimeister to complete answer

Sort sortOrderIgnoreCase = Sort.by(new Sort.Order(evalDirection,evalSort).ignoreCase());

edited Jun 12 '18 at 12:21

answered Jun 12 '18 at 11:39

MyTwoCents

7,284
3
24
52

The problem is, if I use `new Sort(order)` it is deprecated. – Dullimeister Jun 12 '18 at 11:41
you can look at https://docs.spring.io/spring-data/commons/docs/current/api/org/springframework/data/domain/Sort.html for other sort functions which are not deprecated. just pass parameter accordingly – MyTwoCents Jun 12 '18 at 11:46

Mạnh Quyết Nguyễn · Answer 2 · 2018-06-12T11:41:34.823

0

Use a Sort.Order:

Sort.Order order = new Sort.Order(evalDirection , evalSort).ignoreCase();

Page<ApiKey> apiKeyList = apiKeyRepository.findAll(PageRequest.of(evalPage, evalPageSize, new Sort(order)));

edited Jun 12 '18 at 11:41

answered Jun 12 '18 at 11:36

Mạnh Quyết Nguyễn

17,677
1
23
51

score 0 · Answer 3 · answered Jul 07 '20 at 07:11

This should fix it

    //    Query query = new Query();
        Sort.Order order = new Sort.Order(Direction.DESC, "columnName");
   //     query.with( Sort.by(order));

        Page<ApiKey> apiKeyList = apiKeyRepository.findAll(PageRequest.of(evalPage, evalPageSize, new Sort(order)));

Adding comments so it can help other people too.

PagingAndSortingRepository how to sort case insensitive?

3 Answers3

Linked