DCA foreignKey conditions

[tsarma]

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

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

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

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

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

[cliffen]

Hi,

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

Greetings, Cliff

[tsarma]

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?

[cliffen]

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

[tsarma]

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

...
		// 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;
			}
		}
...

[cliffen]

Thanks