#102613Workspace record overlay fails if join with other table
Description
Problem
When using a DatabaseQueryProcessor to get data with a join, the preview link leads to an exception.
I could point the issue to this class and line: typo3/cms-core/Classes/Domain/Repository/PageRepository.php:1701.
There all fields of the row (previously populated with data from the joined table) set as parameter.
Reproduce
1. Create a page with a category and a workspace
2. Add data by a DatabaseQueryProcessor including a join (see example)
3. Switch to workspace
4. Show page as preview
Example for category DataProcessor
Change pidInList in example.
10 = TYPO3\CMS\Frontend\DataProcessing\DatabaseQueryProcessor
10 {
if.isTrue.field = categories
table = sys_category
join = sys_category_record_mm ON sys_category_record_mm.uid_local = sys_category.uid
pidInList = xx
where {
data = field:uid
intval = 1
wrap = sys_category_record_mm.tablenames = "pages" AND sys_category_record_mm.uid_foreign=|
}
orderBy = sys_category_record_mm.sorting_foreign
languageField = 0
as = categories
}Reviews 2
Related issues 1
History 37
-
Benni Mack changed Related to #104548 11/22/24, 15:06
-
Gerrit Code Review pushed patch set 2 for main to change 89886 status
NewUnder Review 06/25/25, 17:32 -
Gerrit Code Review pushed patch set 3 for main to change 89886 06/25/25, 17:40
-
Gerrit Code Review pushed patch set 4 for main to change 89886 06/25/25, 17:53
-
Gerrit Code Review pushed patch set 1 for 13.4 to change 89905 06/25/25, 21:13
-
Christian Kuhn commented and changed status
Under ReviewResolved done0 %100 % 06/25/25, 21:55 -
Benni Mack changed status
ResolvedClosed 12/02/25, 14:37
Applied in changeset commit:74934abfa0077e9b3a243079e606123ff4146a23.