Issue Feature Closed

#103179DatabaseQueryProcessor: Resolve mm-relations without uidInList / pidInList

Christoph Lehmann 02/22/24, 14:57 updated 11/18/26, 22:04

Description

The DatabaseQueryProcessor should be able to resolve MM relations without uidInList/pidInList restrictions.

Currently this works to fetch MM relations.

        dataProcessing {
            10 = TYPO3\CMS\Frontend\DataProcessing\DatabaseQueryProcessor
            10 {
                pidInList = 1
                recursive = 99
                table = tt_address
                selectFields = tt_address.*
                join = tt_content_tt_address_mm ON tt_content_tt_address_mm.uid_foreign = tt_address.uid
                where.data = field:_LOCALIZED_UID // field:uid
                where.intval = 1
                where.wrap = tt_content_tt_address_mm.uid_local=|
                orderBy = tt_address.sorting ASC
                languageField = 0
                as = addresses
            }
        }

The big disadvantage with this is, that the pidInList or uidInList needs to be set. Because one doesn’t know the uidInList yet, the workaround is to this:

pidInList = 1
recursive = 99

This leads to a lot of SQL queries, which is really bad, but recommended in the docs, see

https://docs.typo3.org/m/typo3/reference-typoscript/main/en-us/ContentObjects/Records/Index.html#id4

I like to be able to set

uidInList = 0
pidInList = 0

in order to drop these restrictions.

Reviews 0

No change resolves or names this issue in its commit message, and no comment links one.

History 5

  1. Simon Schaufelberger commented <span data-processor="relativetime" data-value="2024-11-11T10:35:46+00:00" > 11/11/24, 10:35 </span>

    Yes, I would love to have this in core as well! So helpful!

  2. Benni Mack commented and changed status New Closed <span data-processor="relativetime" data-value="2026-11-18T22:04:20+00:00" > 11/18/26, 22:04 </span>

    closing as a duplicate of #93450