Sort by value inside Relationship

[silent mural]

I'm curious that is it possible to sort the query by the value in the relationship level (not the top-level).

[tacit mist]

Check this thread 🧵 https://discord.com/channels/967097582721572934/1050045542664773653

[silent mural]

I understand that the thread is about filter query, but in this situation I want to sort instead. I've tried the dot notation and it doesn't work.

[tacit mist]

Oh sorry I see, sort. I do not believe that is possible atm

[silent mural]

😢

Thank you

[cosmic sleet]

Very interesting, @silent mural you could also just have a field directly within your doc that copies over the data you want to sort. (Copy the data to the top-level)

[cosmic sleet]

@tacit mist do you think that would do the job?

[silent mural]

I think, it would work by applying the beforeChange hook to copy the data from the relationship to the top-level field, but it will lose dynamic of the content in the relationship.

[tacit mist]

You could make the server sort with an after read hook, if you set and check for a query param, then sort with js. But obviously that is a workaround