API: Allow sort by nested property (M2O)

[JH1ller]

Hey everyone,

I'm trying to sort the items of a collection based on the numeric value of a nested property.

Example:

Apple collection with property:

• apple_category (M2O)

AppleCategory collection with property:

• price (int)

Now using the items/apples/ endpoint, I want the apples sorted by their category price.

What I tried:

{
    sort: 'apple_category.price'
}

Which returns a 500 Internal Server Error

side note: I also tried using deep as a user suggested, but it didn't work (and I want to sort the apples, not the apple_categories)

Don't know if I'm missing something but if that's already possible please tell me how :)

And if not, then take this as a feature suggestion, because this should be a rather common use-case.

---

Directus Version: 9.0.0-rc.49

[rijkvanzanten]

You're correct, this is not currently possible.

because this should be a rather common use-case.

I agree! It feels like a common use case, though funnily enough you're the first person to bring it up 🤔

[nodeworks]

@rijkvanzanten Is there anything I can do to help contribute to this functionality? Where to begin?

[gdpdils]

I keep on stumbling on this issue. Seems to be like a basic functionality, since you can already filter and search by related fields.

[dominicliu]

Hi Rijk, is there any update on this? Or is there any workarounds to make it work?

[rijkvanzanten]

Hi Rijk, is there any update on this? Or is there any workarounds to make it work?

Unfortunately, we can not provide estimates on features or fixes. As of now, the only way to get an accurate timeline or release date is to sponsor this task. We recognize that this may be an important feature/fix, but we are a small open-source organization with a lot to triage and complete. If you can't sponsor this ticket, then the next best thing is to increase its priority by giving it a 👍 . Or contribute a pull-request... after all, this is OSS!

---

This is an automated response.

[nodeworks]

This is my first attempt at it:

#12084

[rijkvanzanten]

This has since been implemented!