[TYPO3] Joining tables with Typo-Script

[Frederic Gaus]

JoH schrieb:
>>>         select {
>>>             andWhere.dataWrap = sys_language_uid={GPvar:L}
>>>             andWhere.if.isTrue.data = GPvar:L
>>>             orderBy = sorting
>>>         }
>>>     }
>>>     20  = CONTENT
>>>     20 {
>>>         table = pages
>>>         select {
>>>             orderBy = sorting
>>>         }
>>>         renderObj = CONTENT
>>>         renderObj {
>>>             table = tt_content
>>>             select {
>>>                andWhere.dataWrap = sys_language_uid={GPvar:L}
>>>                andWhere.if.isTrue.data = GPvar:L
>>>                pidInList.field = uid
>>>                orderBy = sorting
>>>            }
>>>         }
>>>     }
>>> }
>> Try removing andWhere.if....
>> And check if you are setting the sys_language_uid for both cases:
>> 1. if the L parameter is zero
>> 2. if the L parameter is empty
> 
> Maybe this one can do a better job:
> 
> select {
>     languageField = sys_language_uid
>     orderBy = sorting
> }

Yeah, that's exactly what I needed! Thanks very much.

Greetings

Frederic

-- 
Frederic Gaus                                 pgp-key: 93E6903C
fingerprint: 0C55 4517 CC1E 5F7F 9059  3535 AB54 D8E8 93E6 903C