DCA foreignKey conditions

Hi there,
for DCA you can have a key 'foreignKey' => TableName.FieldName
e.g.

Code:

---

'author' => array
(
    [...]
    'foreignKey'              => 'tl_user.name',
),

---

How can I achieve this with some conditions. like say to select all user with german langauge

Code:

---

    'foreignKey'              => 'tl_user.name;language=de',

---

which file in core does this foreignKey is return into array();
Thanks

Hi,

i think that's not possible. Use the 'options_callback', to define a custom DB statement with filters and ordering.

Greetings, Cliff

OK. thats what everyone is saying, but there ought to be a way. Do you know by the way where is this array with value (from tableName.fieldName) is read from DB?

Have a look at DC_Table ... there yout can find some places where "foreignKey" is read from DCA.

Just for reference:
Its rendered inside core/library/Contao/Widget.php

Code:

---

...
                // Foreign key
                elseif (isset($arrData['foreignKey']))
                {       

                        $arrKey = explode('.', $arrData['foreignKey'], 2);       
               
                        $objOptions = \Database::getInstance()->query("SELECT id, " . $arrKey[1] . " AS value FROM " . $arrKey[0] . " WHERE tstamp>0 ORDER BY value");
                        $arrData['options'] = array();

                        while($objOptions->next())
                        {
                                $arrData['options'][$objOptions->id] = $objOptions->value;
                        }
                }
...

---

Thanks