TCA foreign_table with pid 0
15:02 20 Jan 2026

in TCA with selectMultipleSideBySide need access to data from a foreign table with pid = 0. The following tca does not work:

'config' => [
    'type' => 'select',
    'renderType' => 'selectMultipleSideBySide',
    'foreign_table' => 'tx_foreign_table',
    'foreign_table_where' => ' AND tx_foreign_table.pid = 0'
    'size' => 6,
    'autoSizeMax' => 30,
    'maxitems' => 9999,
    'multiple' => 0,
],

When i convert the pid values in the foreign table to the actual pid and delete foreign_table_where then it works - so the general syntax is correct. But it seems impossbile to get data from the pageroot.

Is there a possibility?

Thanks!

typo3