Bug #73007
closedEpic #86307: Extbase allows to fetch deleted/hidden records (respects ignoreEnableFields)
Insufficient sysLanguageStatement does not respect enableFields for translations
0%
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