Sorting repeatable components isn't working through GraphQL

[jbcrestot]

Bug report

Required System information

• Node.js version: 14.19.3
• NPM version: 8.13.0
• Strapi version: 14.19.3
• Database: postgresql
• Operating system: mac 13.2.1
• Is your project Javascript or Typescript: javascript

Describe the bug

I have a ContentType Dish with an attribute imageList :

this imageList attribute is a Component (repeatable) which have a number attribute (named upVote)

When I use GraphQL to request a Dish with its imageList, sorting this list by upVote isn't working.

Important :
sorting imageList by id is working :

Steps to reproduce the behavior

1. Create a new contentType TestSort
2. Add a repeatable component SortItem, with a number field "testNumber" inside .
3. Save the contentType
4. Create 1 entry for testSort , add 2-3 SortItem with different testNumber,
5. try to fetch through graphQL

query {
  testSort(id: "1") {
    data {
      id
      attributes {
        SortItem(sort: "testNumber:desc") {
          id
          testNumber
          
        }
      }
    }
  }
}

Expected behavior

testSort should be returned with sortItem list sorted by testNumber

[srtonz]

We are encountering the same issue since our upgrade from Strapi from 4.6.2 to 4.10.5. The following query used to return a list sorted by name, but is now sorted by internal id.

staff(sort: "name", pagination: { limit: -1 }) {
    name
    jobTitle
    portrait: image {
        data {
            attributes {
                hash
                ext
            }
        }
    }
}

[github-actions]

👋 Hello there!

We noticed this issue was created before 2024. As part of our efforts to keep our issue tracker current and actionable, we are closing older issues that have been inactive.

This issue has been automatically closed due to inactivity. If this issue is still relevant:

• Please add a comment to let us know and we will reopen it.
• Share any updates or additional context.

Thank you for your contribution to making Strapi better! 🙏