#32216OrderBy on translated records doesn't work properly
Description
Hello all
I looked for a similar issue in the bugtracker and I wondered that I couldn’t find any report for this problem. Im my opinion it shouldn’t be an unusual case, so if I’m just reporting a known issue please feel free to delete this report.
*Usecase:*
I’m trying to get all localized records from the repository ordered by their “title”-attribute.
*Problem:*
The records are ordered by their title in default language, instead by their translated title.
*Possible Cause:*
The ordering takes place when the records with sys_language_uid = 0 are requested from db (“ORDER BY”-clause). The language overlay for the current language is done later, without any ordering-reimplementation.
*Suggestions:*
I’m not sure what’s the best way to fix the problem. Sorting the translated record after doing the language-overlay is more an hack than a practicable way to fix this issue, and not performant at all. I hope that anybody has a better idea, how to handle this.
Reviews 0
No change resolves or names this issue in its commit message, and no comment links one.