Project

General

Profile

Actions

Bug #102613

open

Workspace record overlay fails if join with other table

Added by Thomas Löffler 6 months ago.

Status:
New
Priority:
Should have
Assignee:
-
Category:
Workspaces
Target version:
-
Start date:
2023-12-06
Due date:
% Done:

0%

Estimated time:
TYPO3 Version:
11
PHP Version:
8.1
Tags:
Complexity:
Is Regression:
Sprint Focus:

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
}

No data to display

Actions

Also available in: Atom PDF