How to query data out of the box using Spring data JPA by both Sort and Pageable

Question

I am trying Spring data JPA in my project  I want to know if there is an out-of-the-box API to query data  by both Sort and Pageable  Of course  I know I can write that method myself  I just want to know if there is an out-of-the-box one  My DAO extends JpaRepository  and I found there are the following methods I can invoke   findAll    findAll Pageable pageable   findAll Sort sort     But there is no such method as findAll Sort sort  Pageable pageable   so I am curious

User · Answer

Spring Pageable has a Sort included  So if your request has the values it will return a sorted pageable   request   domain com endpoint sort  FIELDTOSORTBY  amp  FIELDTOSORTBY  dir  ASC DESC  amp page 0 amp size 20  That should return a sorted pageable by field provided in the provided order

User · Answer

public List lt Model gt  getAllData Pageable pageable          List lt Model gt  models  new ArrayList lt  gt            modelRepository findAllByOrderByIdDesc pageable  forEach models  add          return models

User · Answer

in 2020  the accepted answer is kinda out of date since the PageRequest is deprecated  so you should use code like this   Pageable page   PageRequest of pageable getPageNumber    pageable getPageSize    Sort by  quot id quot   descending     return repository findAll page

User · Answer

In my case  to use Pageable and Sorting at the same time I used like below  In this case I took all elements using pagination and sorting by id by descending order   modelRepository findAll PageRequest of page  10  Sort by  id   descending       Like above based on your requirements you can sort data with 2 columns as well

User · Answer

Pageable has an option to specify sort as well  From the java doc   PageRequest int page  int size  Sort Direction direction  String    properties     Creates a new PageRequest with sort parameters applied

User · Answer

There are two ways to achieve this   final PageRequest page1   new PageRequest    0  20  Direction ASC   lastName    salary      final PageRequest page2   new PageRequest    0  20  new Sort      new Order Direction ASC   lastName         new Order Direction DESC   salary           dao findAll page1     As you can see the second form is more flexible as it allows to define different direction for every property  lastName ASC  salary DESC

[java] How to query data out of the box using Spring data JPA by both Sort and Pageable?

Examples related to java

Examples related to spring

Examples related to jpa

Examples related to spring-data-jpa