[TYPO3] SQL in TCA

[Dmitry Dulepov [typo3]]

Jeppe Donslund wrote:
> 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

Have you read anout foreign_table_where in the documentation? It clearly 
answers your question.

-- 
Dmitry Dulepov
TYPO3 freelancer / TYPO3 core team member
Web: http://typo3bloke.net/
Skype: callto:liels_bugs