[TYPO3-english] TCA foreign table join
Rayuth You
rayuth at web-essentials.asia
Tue Nov 1 10:52:26 CET 2011
Hi list
In TCA I want to get value from table tx_ext_domain_model_type which the
field status of table tx_ext_domain_model_place is 1.
Now what I have done:
'config' => array(
'type' => 'select',
'foreign_table' => 'tx_ext_domain_model_type',
'foreign_table_where' => 'AND tx_ext_domain_model_type.hidden=0 AND
tx_ext_domain_model_type.deleted=0',
But I want more like SQL:
'SELECT tx_ext_domain_model_type.name
FROM tx_ext_domain_model_type
JOIN tx_ext_domain_model_place
ON tx_ext_domain_model_place.uid = tx_ext_domain_model_type.place
WHERE tx_ext_domain_model_place.status = 1
AND tx_ext_domain_model_type.hidden=0 AND
tx_ext_domain_model_type.deleted=0'
Is this possible to join table in TCA?
Thanks,
Yuth
More information about the TYPO3-english
mailing list