Typo3: get news titles (tt news)

tt_news, category, articles, typo3, typoscript

[hellboy]

HI!

I'm looking for typoscript which would load news titles from certain category ID into right navigation (or anywhere on the page) wrapped into links which points to the single article.
I was unable to find such a script on the internet. Does anyone have any idea on how to do this?

Appreciate your help!
Thank you!

[hellboy]

Finally I got it! Hope it helps someone

lib.rightnav = COA
 
lib.rightnav {
 wrap = <ul class="list">|</ul>
 10 = CONTENT
 10 { 
 table = tt_news
 select {
 pidInList = 293
 join = tt_news_cat_mm ON (tt_news.uid = tt_news_cat_mm.uid_local )
 #andWhere.data = GPvar:tx_ttnews|tt_news
 #andWhere.wrap = pid = 293
 where = tt_news_cat_mm.uid_foreign = 3
 
 }
 
 renderObj = TEXT
 renderObj {
 
 field = title
 wrap = <li>|</li>
 } 
 
 
 
 
 }
 
 
}

[ergophobe]

Congratulations and thanks for posting the solution!