[TYPO3] SQL in TCA

Jeppe Donslund jd at webmasters.dk
Thu Aug 23 13:49:55 CEST 2007


Hi

I have an extension with tables that are connected.
In TCA it shows like this:

"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",	
				"foreign_table_where" => " ORDER BY tx_wmpfvideos_videos.uid",	
				"size" => 10,	
				"minitems" => 0,
				"maxitems" => 10,
			)
		)

Can I use Where in the foreign_table_where and how do I get the UID for 
the post I am editing in BACKEND?

Is it something like this:

HERE CONCAT(',', crossreference, ',') LIKE %CONCAT(',', 
###CURRENT_UID###, ',')% ORDER BY tx_wmpfvideos_videos.uid



Regards,
Jeppe D


More information about the TYPO3-english mailing list