Actions
Bug #91743
openUsing 'foreign_table_where' in selects in TCA TYPO3 v. 9 has changed...
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