[TYPO3-UG Denmark] Brug af WHERE i TCA

[Dycon - Lars Dyhr]

Hej

Jeppe Donslund wrote:
> Her er koden fra min TCA, hvis det hjælper ;-)
> 
> 
> 		"crossreferences" => Array (		
> 			"exclude" => 1,		
> 			"label" => "LLL:EXT:wm_pf_videos/locallang_db.xml:tx_wmpfvideos_videos.crossreferences",		
> 			"config" => Array (
> 				"type" => "select",	
> 				'foreign_table' => 'tx_wmpfvideos_videos v1 INNER JOIN tx_wmpfvideos_persons p1 ON v1.person = p1.uid INNER JOIN tx_wmpfvideos_persons p2 ON p1.uid LIKE p2.related_to INNER JOIN tx_wmpfvideos_videos v2 ON p2.uid = v2.person',
> 				'foreign_table_where' => 'v1.uid = ###THIS_UID###',
> 				"size" => 10,	
> 				"minitems" => 0,
> 				"maxitems" => 100,
> 			)
> 		),
> 	),
> 

Du er nok nødt til at bruge:
'itemsProcFunc' til at processere dine data yderligere med (du skulle 
kunne finde eksempler på dette i en del extensions.

Mvh
Lars Dyhr