Issue Bug Closed

#102613Workspace record overlay fails if join with other table

Thomas Löffler 12/06/23, 12:23 updated 12/02/25, 14:37

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

History 37

  1. Benni Mack changed Related to #104548 11/22/24, 15:06

  2. Gerrit Code Review pushed patch set 2 for main to change 89886 status New Under Review 06/25/25, 17:32

  3. Gerrit Code Review pushed patch set 3 for main to change 89886 06/25/25, 17:40

  4. Gerrit Code Review pushed patch set 4 for main to change 89886 06/25/25, 17:53

  5. Gerrit Code Review pushed patch set 1 for 13.4 to change 89905 06/25/25, 21:13

  6. Christian Kuhn commented and changed status Under Review Resolved done 0 % 100 % 06/25/25, 21:55

    Applied in changeset commit:74934abfa0077e9b3a243079e606123ff4146a23.

  7. Benni Mack changed status Resolved Closed 12/02/25, 14:37