[TYPO3-mvc] FED SQL Query with sys_language_uid

[Chivy Lim]

Hi Claus,

Your conditions is correct, but I don't know how to assign variable 
"theVariableWithLanguageUid" into template. Could you explain how to if 
I use FED "Fluid Template Display" plugin?

Thanks,
Chivy

On 02/02/2012 09:13 PM, Claus Due wrote:
> Hi Chivy,
>
> First of all you need the currently active language's UID assigned as a template variable somehow (approach depends on your implementation method).
>
> Then, in your query's condition add this:
>
> … " AND (sys_language_uid IN (-1,0) OR (sys_language_uid = '{theVariableWithLanguageUid}' AND l18n_parent = '0'))"
>
> The variable can be read from $GLOBALS['TSFE']->sys_language_uid but naturally must be assigned to the template renderer before you can use it :)
>
>
> ---
> Cheers,
> http://fedext.net
>
> On Feb 2, 2012, at 6:22 AM, Chivy Lim wrote:
>
>> Hi all,
>>
>> I use FED for selecting the record as below:
>>
>> <fed:data.sql as="categories" table="tx_news_domain_model_category" fields="uid,title" condition="deleted=0 AND hidden=0" orderBy="title" order="ASC" />
>>
>> The result of this statement is showing all records in other languages, but I would need only records in the current language. Could you help?
>>
>> Thanks,
>> Chivy
>> _______________________________________________
>> TYPO3-project-typo3v4mvc mailing list
>> TYPO3-project-typo3v4mvc at lists.typo3.org
>> http://lists.typo3.org/cgi-bin/mailman/listinfo/typo3-project-typo3v4mvc
>