How to define direction in request with pageable parameter?

Question

I have a query that takes pageable as a parameter. I define the direction as DESC but this takes no effect. This is my request. Could you please help me formulate the requests in a way that the results come back sorted in descending order? I have posted my request in the picture below. It works but it does not sort the results

Thank you

This is the controller code:

@GetMapping
fun listMessages(@RequestParam conversationRef: String,
                 @RequestParam fromDate: Instant, @RequestParam toDate: Instant, 
                 pageable: Pageable): PaginatedCollection<MessageVO> {
                     return messageService.listAll(fromDate, toDate, pageable, 
                              conversationRef).data ?: PaginatedCollection(listOf(), 
                              PaginationVO.build(), SortVO.build())
}

the sort field in the Pageable is a class that contains at least two values. The direction of the sort and the field on which to sort. Read https://docs.spring.io/spring-data/rest/docs/current/reference/html/#paging-and-sorting.sorting — Gerben Jongerius, Aug 20 '20 at 12:41
Yes. I know. The format of the request is what I havent figured out — C96, Aug 20 '20 at 12:43
Like how do I add the field to sort, in the context of a postman request? — C96, Aug 20 '20 at 13:17

score 4 · Accepted Answer · answered Aug 20 '20 at 13:56

4

You need to send sort field for which you want to sort by descending.(Ref) Ex:

http://localhost:8080/people?sort=id,desc

Here id is sort field and desc is sort direction separated by a comma.

So, you need to send id,desc on sort param in PostMan for sort by id in desecending order.

answered Aug 20 '20 at 13:56

Eklavya

17,618
4
28
57

if you want multiple soring then you can add like: http://localhost:8080/people?sort=id,desc&sort=name,desc&time,asc NOTE that default is asc – destan Aug 09 '23 at 05:59

How to define direction in request with pageable parameter?

1 Answers1