[TYPO3-english] Re: pt_extlist and m:n-relations

[Daniel Lienert]

Hey Michael,

I think everything you can express with a SQL query can be transformed into a pt_extlist config.

The easiest way would be to join the group table in the baseFromClause and set the baseGroupByClause to

baseGroupByClause (
     tt_address.uid
)

then you define a field to concatenate the groups:

fields {
    groups.special = GROUP_CONCAT(tt_address_group.title)
} 

thats it :)

Cheers,
Daniel
-- 
TYPO3 related: http://daniel.lienert.cc | http://yag-gallery.de