[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