Project

General

Profile

Actions

Bug #32216

closed

OrderBy on translated records doesn't work properly

Added by Alessandro Bellafronte over 12 years ago. Updated over 5 years ago.

Status:
Closed
Priority:
Should have
Assignee:
-
Category:
-
Target version:
-
Start date:
2011-11-30
Due date:
% Done:

100%

Estimated time:
TYPO3 Version:
4.5
PHP Version:
Tags:
Complexity:
Is Regression:
No
Sprint Focus:

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.


Related issues 3 (1 open2 closed)

Related to TYPO3 Core - Bug #45873: querySettings setRespectSysLanguage or setSysLanguageUid does not workNeeds Feedback2013-02-27

Actions
Related to TYPO3 Core - Bug #77298: Wrong language overlay logic in extbaseClosed2016-07-29

Actions
Related to TYPO3 Core - Bug #84707: Extbase wrongly counting translated objectsClosed2018-04-12

Actions
Actions #1

Updated by Gerrit Code Review about 12 years ago

  • Status changed from New to Under Review

Patch set 1 for branch master has been pushed to the review server.
It is available at http://review.typo3.org/10188

Actions #2

Updated by Gerrit Code Review about 12 years ago

Patch set 2 for branch master has been pushed to the review server.
It is available at http://review.typo3.org/10188

Actions #3

Updated by Gerrit Code Review almost 12 years ago

Patch set 3 for branch master has been pushed to the review server.
It is available at http://review.typo3.org/10188

Actions #4

Updated by Gerrit Code Review almost 12 years ago

Patch set 4 for branch master has been pushed to the review server.
It is available at http://review.typo3.org/10188

Actions #5

Updated by Gerrit Code Review almost 12 years ago

Patch set 5 for branch master has been pushed to the review server.
It is available at http://review.typo3.org/10188

Actions #6

Updated by Gerrit Code Review over 11 years ago

Patch set 6 for branch master has been pushed to the review server.
It is available at http://review.typo3.org/10188

Actions #7

Updated by Markus Günther over 11 years ago

  • Category set to Extbase: Generic Persistence
Actions #8

Updated by Gerrit Code Review over 11 years ago

Patch set 7 for branch master has been pushed to the review server.
It is available at http://review.typo3.org/10188

Actions #9

Updated by Nicole Cordes over 11 years ago

  • Status changed from Under Review to Resolved
  • % Done changed from 0 to 100

Applied in changeset commit:fdeb26768835a36ae69a8cb6b801b37ea6671c83.

Actions #10

Updated by Michael Stucki over 8 years ago

  • Project changed from 534 to TYPO3 Core
  • Category deleted (Extbase: Generic Persistence)
  • TYPO3 Version set to 4.5
  • Is Regression set to No
Actions #11

Updated by Kevin Ditscheid about 6 years ago

  • Related to Bug #84707: Extbase wrongly counting translated objects added
Actions #12

Updated by Benni Mack over 5 years ago

  • Status changed from Resolved to Closed
Actions

Also available in: Atom PDF