[Typo3] Display tt_news_cat of related news in Single view

[Peter Klein]

"Rupert Germann" <rupi at gmx.li> skrev i en meddelelse 
news:mailman.1.1108065726.5693.typo3-english at lists.netfielders.de...

> it should be possible to get values from mm-related tables by TS but I
> haven't figured out how to do this yet.
>

Hi Rupert. maybe something like this:

-- cut --
temp.MMtest = COA
temp.MMtest {
  10 = CONTENT
  10.table = tt_news
  10.select {
    pidInList = 8  # Sysfolder where the news records are stored
    where = uid=3 # UID of a newsitem
    andWhere = deleted=0 AND hidden=0
    leftjoin = tt_news_cat_mm ON tt_news.uid = tt_news_cat_mm.uid_local
    groupBy = tt_news_cat_mm.uid_foreign
  }
  10.renderObj = COA
  10.renderObj {
    10 = TEXT
    10.field = title
    10.wrap = Title:&nbsp;|<br>

    20 = TEXT
    20.field = uid_local
    20.wrap = uid_local:&nbsp;|<br>
  }
}
page.123 < temp.MMtest
-- cut --


-- 
Peter Klein/Umloud Untd