Actions
Bug #69210
closed
Translated records are ordered like default language
Status:
Rejected
Priority:
Must have
Assignee:
-
Category:
Extbase
Target version:
-
Start date:
2015-08-20
Due date:
% Done:
0%
Estimated time:
TYPO3 Version:
6.2
PHP Version:
5.5
Tags:
Complexity:
Is Regression:
No
Sprint Focus:
Description
Queries for other languages return the default language sorting.
In this example, when we are not on default language (config.sys_language_uid > 1), foo's objects are sorted by title of the default language. They should be sorted by the current language title.
$query = $fooRepository->createQuery();
$query->setOrderings(array('title' => \TYPO3\CMS\Extbase\Persistence\QueryInterface::ORDER_ASCENDING));
$foo = $query->execute();
Typoscript config:
config.sys_language_overlay = 1 config.sys_language_mode = content_fallback config.language = fr config.locale_all = fr_FR.UTF-8 config.sys_language_uid = 1
Updated by Markus Klein over 7 years ago
- Status changed from New to Rejected
The problem is that this sorting has to happen AFTER the language overlay. This means that all rows have to be loaded into memory to apply the overlay and then do the sorting. This is unacceptable for larger tables though, since you usually don't want 500k rows in memory, just because you selected the top three and you want them sorted.
Please sort your desired result manually in that case.
Actions