#103179DatabaseQueryProcessor: Resolve mm-relations without uidInList / pidInList
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.
Related issues 1
History 5
-
Christoph Lehmann commented <span data-processor="relativetime" data-value="2024-02-22T20:01:58+00:00" > 02/22/24, 20:01 </span>
-
Garvin Hicking changed category <span data-processor="relativetime" data-value="2024-07-31T09:40:37+00:00" > 07/31/24, 09:40 </span>
-
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!
-
Benni Mack changed Related to #93450 <span data-processor="relativetime" data-value="2026-11-18T22:03:54+00:00" > 11/18/26, 22:03 </span>
-
Benni Mack commented and changed status
NewClosed <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
https://github.com/andersundsehr/relation-processor does exactly what i need. Would be nice to see it in core.