Strapi `sort` does not work on `id` on REST endpoint

[louisunlimited]

Bug report

Required System information

• Node.js version: 18.11.10
• NPM version: 8.19.2
• Strapi version: 4.8.2
• Database: Postgres
• Operating system: Linux
• Is your project Javascript or Typescript: Typescript

Describe the bug

After I upgrade my Strapi to 4.8.2, the sort=id:desc does not seem to work anymore, I was able to sort based on keys with in the attributes tag but not on id.

For example I was able to sort by createdAt but not id using this 🤔

/api/<list-type-name>?sort=createdAt%3Adesc

but not this

/api/<list-type-name>?sort=id%3Adesc

Steps to reproduce the behavior

1. Go to any Strapi list type
2. Try to request REST endpoint : /api/<list-type-name>?sort=id%3Adesc

Expected behavior

The output should be sorted by id, decreasing

[strapi-bot]

This issue has been mentioned on Strapi Community Forum. There might be relevant details there:

https://forum.strapi.io/t/broken-sort-id-desc/26699/6

[Convly]

Hey, thanks for opening the issue and confirming this bug. I've been able to reproduce it and will provide a fix as soon as possible.

[aserhii87]

Sort option doesn't work on Graphql plugin too

[Anton-Klochkov]

how to sort by ascending?
my bad, /api/?sort=id