Issue Bug Closed

#32216OrderBy on translated records doesn't work properly

Alessandro Bellafronte 11/30/11, 16:54 updated 10/02/18, 12:19

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.