Add SQL data to default JPARepostiroty method

Question

I have a JpaRepository:

public interface PostRepository extends JpaRepository<Entity, Integer>

And I have a default method inside:

Page<Entity> findAllByBookIdAndStatus(Integer bookId, PostStatus postStatus, Pageable pageable);

And the method above doesn't sort my data, just return in no particular order.

So if I want to have my data sorted, can I add some SQL data to this method e.g. ORDER BY ENTITY_ID and to not write new SQL query?

Is it possible and if yes, how can I do it?

Can you add the code block where you call the `findAllByBookIdAndStatus` method? — İsmail Y., Aug 14 '21 at 12:36
You can update pageable object with sorting order with column. — Eklavya, Aug 14 '21 at 14:26

score 0 · Answer 1 · answered Aug 14 '21 at 13:58

0

Have you checked this post out?

Something like this should work.

Page<Entity> findAllByBookIdAndStatusOrderByIdAsc(
    Integer bookId,
    PostStatus postStatus,
    Pageable pageable);

answered Aug 14 '21 at 13:58

bonobo

score 0 · Answer 2 · answered Aug 14 '21 at 14:15

There are two ways of doing this :

writing a query with the @Query anotation and using the proper syntaxe to order the response (depends of the DBMS you're using)
or you can itterate the reponse in the service layer to order them

personnaly i would use the first method

score 0 · Answer 3 · answered Aug 14 '21 at 14:40

0

You can add sorting info into pageable object with page and size when create pageable object.

Pageable pageable = new PageRequest(1, 10, new Sort(Sort.Direction.ASC, "ENTITY_ID"))

answered Aug 14 '21 at 14:40

Eklavya

3 Answers3