Sort findByStatus

[Monra]

The resource findByStatus sorts only inside the page and not over complete collection.

Actual:
http://host/encoreJobs/search/findByStatus?status=SUCCESSFUL&sort=createdDate,desc&page=0&size=2
Response: {... [{... "createdDate": "2022-01-04" ...},{... "createdDate": "2022-01-02" ...}] ...}
http://host/encoreJobs/search/findByStatus?status=SUCCESSFUL&sort=createdDate,desc&page=1&size=2
Response: {... [{... "createdDate": "2022-01-03" ...},{... "createdDate": "2022-01-01" ...}] ...}

Expected:
http://host/encoreJobs/search/findByStatus?status=SUCCESSFUL&sort=createdDate,desc&page=0&size=2
Response: {... [{... "createdDate": "2022-01-04" ...},{... "createdDate": "2022-01-03" ...}] ...}
http://host/encoreJobs/search/findByStatus?status=SUCCESSFUL&sort=createdDate,desc&page=1&size=2
Response: {... [{... "createdDate": "2022-01-02" ...},{... "createdDate": "2022-01-01" ...}] ...}

[grusell]

Many thanks for reporting, we will look into this.

[deedos]

The exactly same thing happens when listing the /encoreJobs . The sorting criteria works within the page but not over the complete collection.

/encoreJobs?sort=createdDate&page=0&size=15

returns me jobs with createdDate ordered but at page 1:

/encoreJobs?sort=createdDate&page=1&size=15

I have more recent jobs.

With this bug it's impossible to order all jobs chronologically.

thanks a lot

[grusell]

The problem with sorting is due to a limitation in spring-data-redis. Should be possible to implement a workaround, we are looking at this but it is unclear when we might have time to implement it.