#73007Insufficient sysLanguageStatement does not respect enableFields for translations
Description
The statement added to sql queries to load translated entities only respects the deleted falg.
If you define the starttime, endtime, hidden and feaccess features for translations no filters are applied on queries.
This results in a QueryResult containing a number of X Rows.
After mapping those elements will be hidden because in languageOverlay the fields ARE respected.
In my case i display the number of results found by the orm, followed by a paginated widget showing those results.
So it says “11 Results found”
But only 6 Results are rendered.
The Problem can be found in:
https://github.com/TYPO3/TYPO3.CMS/blob/master/typo3/sysext/extbase/Classes/Persistence/Generic/Storage/Typo3DbQueryParser.php#L733
If additional enablefields are configured and not set as l10n_mode=exclude they must be appended as well.
This can be solved without touching anything else in the translation setup, a patch would only affect the subquery statement
The bug exists in 6.2 and 7 LTS
Reviews 5
- 14.3 95535[BUGFIX] Ignore enable fields in Extbase overlays
- main 95442[BUGFIX] Ignore enable fields in Extbase overlays
- main 52097[BUGFIX] Respect enablefields for translated records
- TYPO3_7-6 52072[BUGFIX] Respect enablefields for translated records
- TYPO3_6-2 46348[BUGFIX] add extbase enablecolumns support for translations