#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 <span data-processor="relativetime" data-value="2024-11-22T15:06:42+00:00" > 11/22/24, 15:06 </span>
-
Gerrit Code Review pushed patch set 2 for main to change 89886 status
NewUnder Review <span data-processor="relativetime" data-value="2025-06-25T17:32:18+00:00" > 06/25/25, 17:32 </span> -
Gerrit Code Review pushed patch set 3 for main to change 89886 <span data-processor="relativetime" data-value="2025-06-25T17:40:54+00:00" > 06/25/25, 17:40 </span>
-
Gerrit Code Review pushed patch set 4 for main to change 89886 <span data-processor="relativetime" data-value="2025-06-25T17:53:29+00:00" > 06/25/25, 17:53 </span>
-
Gerrit Code Review pushed patch set 1 for 13.4 to change 89905 <span data-processor="relativetime" data-value="2025-06-25T21:13:24+00:00" > 06/25/25, 21:13 </span>
-
Christian Kuhn commented and changed status
Under ReviewResolved done0 %100 % <span data-processor="relativetime" data-value="2025-06-25T21:55:07+00:00" > 06/25/25, 21:55 </span> -
Benni Mack changed status
ResolvedClosed <span data-processor="relativetime" data-value="2025-12-02T14:37:05+00:00" > 12/02/25, 14:37 </span>
Applied in changeset commit:74934abfa0077e9b3a243079e606123ff4146a23.