BE flexform search-field "singleRecords" within a plugin does not find language records #590
Description
Bug Report
Current Behavior
Cannot find tt_address records in the language you are currently in.
Expected behavior/output
tt_address records should be found depending on the current language.
Environment
- TYPO3 version(s): 13.4.8
- tt_address version: 9.0.1
- Is your TYPO3 installation set up with Composer (Composer Mode): no
- OS: Ubuntu
Possible Solution
I think the part in the flexform line 25, “suggestOptions” <addWhere>AND tt_address.sys_language_uid IN (-1,0)</addWhere> is obsolete and could probably be deleted.
(https://github.com/FriendsOfTYPO3/tt_address/blob/master/Configuration/FlexForms/List.xml#L25)
Additional context
The error was noticed in a multi-domain installation in which not all pages have the language ID 0 as default or where the language ID 0 has not yet been translated.
For example, there are pages where a language SprachID 3 has already been translated and is online, but there are no “translations” for SprachID 0. As a result, tt_address records with language ID 3 have been created and no tt_address records with language ID 0 exist yet.
As a result, these tt_address records cannot be selected in the selection in the “singleRecords” plugin field.