[TYPO3-english] TCA foreign table join
Michal Lulco
lulco at monogram.sk
Wed Nov 30 00:34:40 CET 2011
Hi,
did you try this?
'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 AND tx_ext_domain_model_type.place IN
(SELECT tx_ext_domain_model_place.uid FROM tx_ext_domain_model_place WHERE
tx_ext_domain_model_place.status=1)',
),
Michal
Dňa Tue, 01 Nov 2011 10:52:26 +0100 Rayuth You
<rayuth at web-essentials.asia> napísal:
> 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
--
Táto správa bola vytvorená poštovým klientom v prehliadači Opera:
http://www.opera.com/mail/
More information about the TYPO3-english
mailing list