Description¶

If you create an Extbase query (\TYPO3\CMS\Extbase\Persistence\Generic\Query) and filter by a property which has "l10n_mode" => exclude it will still try to match the property to the translated records instead of the parents.

Extbase should filter out records with a language parent at this stage of the query, since it does the record overlay afterwards in any case.

Steps to reproduce¶

(I've attached an extension which demonstrates the issue)

• Have a TYPO3 installation with at least 2 languages
• Install the provided extension (attached to the ticket)
• Create a record with the value "test" in the field "Nontranslatedproperty"
• Translate that record
• Add the plugin on any page
• Run the plugin on any sys_language other than default

Expected result¶

Example 1:

        $query = $this->testMasterRepository->createQuery();
        $query->matching(
            $query->equals('nontranslatedproperty', 'test')
        );
        $test = $query->execute();

Should return the record with "nontranslatedproperty" => "test"

Actual result¶

Doesn't return the expected record in any sys_language other than 0/-1

Example which returns the expected result¶

        $query = $this->testMasterRepository->createQuery();
        $querySettings = $query->getQuerySettings();
        $querySettings->setRespectSysLanguage(false);
        $query->setQuerySettings($querySettings);

        $query->matching(
            $query->logicalAnd(
                $query->logicalOr(
                    $query->in('sys_language_uid', [0, -1]),
                    $query->logicalAnd(
                        $query->equals('sys_language_uid', $querySettings->getLanguageUid()),
                        $query->equals('l10n_parent', 0)
                    )
                ),
                $query->equals('nontranslatedproperty', 'test')
            )
        );

        $test = $query->execute();