M2A sorting fails with image field

[fabianbeiermeire]

Preflight Checklist

• I have completed all Troubleshooting Steps.
• I'm on the latest version of Directus.
• There's no other issue that already describes my problem.

Describe the Bug

M2A sorting fails if an image is use in the related collection.

To Reproduce

Create M2A-Field with a related Collection that uses an image.

Errors Shown

[
{
"message": ""storage" is required",
"extensions": {
"code": "FAILED_VALIDATION",
"field": "storage",
"type": "required"
}
},
{
"message": ""filename_download" is required",
"extensions": {
"code": "FAILED_VALIDATION",
"field": "filename_download",
"type": "required"
}
}
]

What version of Directus are you using?

9.0.1

What version of Node.js are you using?

v14.18.1

What database are you using?

SQLite 3.36.0

What browser are you using?

Brave (Chrome), Safari

What operating system are you using?

macOS

How are you deploying Directus?

running locally

[Oreilles]

Thank you for reporting this issue, could you provide the API query that caused it ?

[joselcvarela]

Hey @Oreilles, I am currently working on sorting and relationships #9832
I can take from here, if you don't mind 👍

[joselcvarela]

Hello @fabianbeiermeire
This seems to be fixed now. Tried with both Postgres and SQLite.

m2a_sorting.mov

---

If you think this is not solved yet, feel free to reach us in order to reopen.