foreign_table_where

foreign_table_where (type => category)

Path

$GLOBALS['TCA'][$table]['columns'][$field]['config']

Type

string (SQL WHERE)

Scope

Proc. / Display

Default

AND {#sys_category}.{#sys_language_uid} IN (-1, 0)

The items from foreign_table are selected with this WHERE clause. If set make sure to append the default value to your query. See also property foreign_table_where of select field.