multiple requestparam in springboot pageable

Question

i know that this question may be duplicated but i tried a lot with no success

I need to make multiple RequestParam in spring boot rest controller as following :

@GetMapping("/prd-products/test")
@Timed
public ResponseEntity<List<Test>> getAllTests(@RequestParam (required = false) String search, @RequestParam (required = false) Pageable pageable) {
    Page<Test> page = prdProductsService.findAllTest(search, pageable);
    HttpHeaders headers = PaginationUtil.generatePaginationHttpHeaders(page, "/api/prd-products");
    return new ResponseEntity<>(page.getContent(), headers, HttpStatus.OK);
}

when i try to call this service by url like :

http://localhost:9116/api/prd-products/test?search=id==1,id==2&pageable=0&size=2

it give me following error

"title": "Bad Request",
"status": 400,
"detail": "Failed to convert value of type 'java.lang.String' to required type 'org.springframework.data.domain.Pageable'; nested exception is java.lang.IllegalStateException: Cannot convert value of type 'java.lang.String' to required type 'org.springframework.data.domain.Pageable': no matching editors or conversion strategy found",

when i try to send one request param it successfully work .

Note : id==1,id==2 is the way that fields is parsed in search

Are you using Spring Data Rest? Your url doesn't seems like the pattern which Spring Data Rest works by default.. — Matheus, Aug 21 '19 at 11:37
yes i work with spring rest , can you provide me with the default pattern you mean ? — Yousef Al Kahky, Aug 21 '19 at 11:41

score 10 · Accepted Answer · answered Aug 22 '19 at 06:58

With Spring Boot you can just register PageableHandlerMethodArgumentResolver bean

@Bean
public PageableHandlerMethodArgumentResolver pageableResolver() {
    return new PageableHandlerMethodArgumentResolver();
}

In controller

public ResponseEntity<List<Test>> getAllTests(
    @RequestParam (required = false) String search,
    @PageableDefault(page = 0, size = 100) Pageable pageable
) {
    ...
}

And then adjust your query parameters to ...&page=0&size=2

Gustavo Passini · Answer 2 · 2019-08-21T11:50:58.433

1

Spring cannot convert a String to a Pageable. You should create a Pageable object from the request parameters, for example, with PageRequest.of.

Example:

@GetMapping("/prd-products/test")
@Timed
public ResponseEntity<List<Test>> getAllTests(
        @RequestParam (required = false) String search,
        @RequestParam (required = false) Integer pageIndex,
        @RequestParam (required = false) Integer pageSize) {
    Pageable pageable = PageRequest.of(pageIndex, pageSize);
    Page<Test> page = prdProductsService.findAllTest(search, pageable);
    HttpHeaders headers = PaginationUtil.generatePaginationHttpHeaders(page, "/api/prd-products");
    return new ResponseEntity<>(page.getContent(), headers, HttpStatus.OK);
}

edited Aug 21 '19 at 11:50

answered Aug 21 '19 at 11:43

Gustavo Passini

2,348
19
25

it works correctly , but in my way i sent before why it accepts pageable when i sent it alone with no other request param ? – Yousef Al Kahky Aug 21 '19 at 12:05
The only parameter you were sending to make it work was the `pageable`, or the `search` ? – Gustavo Passini Aug 21 '19 at 12:29
1

I'm sorry, I don't know how it is capable of creating a `Pageable` object from a single request parameter named `pageable`. – Gustavo Passini Aug 21 '19 at 12:41

Matheus · Answer 3 · 2019-08-21T12:00:51.563

0

Your QueryString seems strange.

In order to use Spring Data REST to create and inject a Pageable, you need to do something like this:

?page=0&size=2&ids=1,2

Your REST Controller:

public ResponseEntity <List<Test>> getAllTests(@RequestParam(required = false) String search, @RequestParam(required = false) Pageable pageable) {
    Page<Test> page = prdProductsService.findAllTest(search, pageable);
    return new ResponseEntity<>(page.getContent(), headers, HttpStatus.OK);
}

This way, Spring Data REST will create a Pageable object.

See reference documentation.

edited Aug 21 '19 at 12:00

answered Aug 21 '19 at 11:53

Matheus

3,058
7
16
37

i cannot make list of ids because search String is a dynamic way to search , it accepts any property of the entity and any operation not only == , it must be in a dynamic way – Yousef Al Kahky Aug 21 '19 at 11:59
no it give me the same error , this what i did before – Yousef Al Kahky Aug 21 '19 at 12:09
You sure you're using Sprint DATA REST? org.springframework.bootspring-boot-starter-data-rest – Matheus Aug 21 '19 at 12:11

multiple requestparam in springboot pageable

3 Answers3