Issue Bug Closed

#64163BackendUtility::getProcessedValue does not evaluate foreign_table_where

M. Ecker 01/07/15, 13:53 updated 03/23/25, 22:41

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.