TYPO3 Core

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.