Project

General

Profile

Actions

Bug #91743

open

Using 'foreign_table_where' in selects in TCA TYPO3 v. 9 has changed...

Added by Claus Harup over 3 years ago.

Status:
New
Priority:
Should have
Assignee:
-
Category:
-
Start date:
2020-07-05
Due date:
% Done:

0%

Estimated time:
TYPO3 Version:
9
PHP Version:
7.4
Tags:
TCA
Complexity:
Is Regression:
Sprint Focus:

Description

Having this (normal) TCA:

...
'region' => [
        'label' => $labelPrefix . '.region',
        'config' => [
            'type' => 'select',
            'renderType' => 'selectSingle',
            'items' => [
                ['LLL:EXT:tc_sys/Resources/Private/Language/locallang_db.xlf:choose', 0]
            ],
            'default' => 0,
            'foreign_table' => 'tx_tcsys_domain_model_category',
            'foreign_table_where' => 'AND tx_tcsys_domain_model_category.pid = ###PAGE_TSCONFIG_ID### ORDER BY tx_tcsys_domain_model_category.title'
        ]
]
...

....leaves my editors with NO items in region selctorbox IF they can not see the folder (uid = ###PAGE_TSCONFIG_ID###) holding the regions in the pagetree....

This has not been the case in previous version of TYPO3

The issue can be addressed here:

sysext/backend/Classes/Form/FormDataProvider/AbstractItemProvider.php

line 1028

$queryBuilder->andWhere($backendUser->getPagePermsClause(Permission::PAGE_SHOW));

makes sure that no references to any tableNames is possible if the editor does NOT have permission to see the folder holding these objets....

That leaves developers no possibility to reference to objects that the editor should ONLY choose and NOT see in the pagetree :-(

No data to display

Actions

Also available in: Atom PDF