#64163BackendUtility::getProcessedValue does not evaluate foreign_table_where
Description
If you defined in TCA a column as ‘select’ with a ‘foreign_table_where’ condition you’ll see in the Edit Record view only the options meeting the condition – correct.
But if you choose the column to be shown in the single table view of Web/List the condition will not be evaluated and a csv list of all records of the foreign_table will be shown (but only the first 100 chars of this csv list).
TYPO3\CMS\Recordlist\RecordList\DatabaseRecordList uses BackendUtility::getProcessedValueExtra to render the column fields in the record list, which is a wrapper for BackendUtility::getProcessedValue.
Line 2129 of TYPO3\CMS\Backend\Utility\BackendUtility reads currently (TYPO3 V6.2.9) as
$records = self::getRecordsByField($theColConf['foreign_table'], $theColConf['foreign_field'], $uid);
If changed to
$records = self::getRecordsByField($theColConf['foreign_table'], $theColConf['foreign_field'], $uid, $theColConf['foreign_table_where']);
all is fine and the ‘foreign_table_where’ is evaluated in Record List view also.
Would be nice, if this would be changed in 6.2.10 – need this for a running project.
Reviews 0
No change resolves or names this issue in its commit message, and no comment links one.