Issue #2124 (BelongsTo sortable() should sort by label) labeled as implemented but not working

[davide-lucchelli]

• Laravel Version: 9.41.0
• Nova Version: 4.19.3
• PHP Version: 8.2.5
• Database Driver & Version: MySql 8.0.33
• Operating System and Version: MacOS 13.2.1
• Browser type and version: Chrome 113.0.5672.126

Description:

Trying to sort table by a belongsto column, data is sorted using the related resource id, not the displayed label (behavior normally expected by user).
This behavior was already reported in an issue (#2124) and labeled as "implemented" but in this version is still sorting by id.

[crynobone]

https://nova.laravel.com/docs/4.0/resources/relationships.html#disable-ordering-by-title

[davide-lucchelli]

This link concerns "select dropdown", I was talking about resource index view sorting functionality

[crynobone]

okay, such feature isn't available without introducing performance impact on most app. I removed the implemented tag.

[davide-lucchelli]

Ok, I understand that feature could introduce performance impact, but, from the user's point of view, it is a malfunction. It's not the first time I've received complaints from customers for this reason and the only way to solve the situation is to develop a custom sorting using subqueries. I understand the "technological" problem but in fact it is something that does not work as it should.