TCA foreign_table with pid 0
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!