[Typo3] distinct in typoscript select function

Steffen Müller steffen at mail.kommwiss.fu-berlin.de
Sat Sep 24 00:34:39 CEST 2005


Hi.

I try to get the IDs of five different pages, which contain the latest
created contentelements.

20 = CONTENT
20 {
  table = tt_content
  select {
    pidInList.data = register:alluids
    orderBy = tstamp
    max = 5
  }
  renderObj = COA
  renderObj {
    10 = TEXT
    10.field = {page:title}
    10.typolink.parameter.field=pid
    10.wrap = <li>|
    20 = TEXT
    20.field = tstamp
    20.strftime = %d.%m.%Y, %H:%M
    20.wrap =  &nbsp;(|&nbsp;Uhr)</li>
  }
}

But that one doesn't work, if the two or more contentelements are within
the same page.
I need to have some output like
SELECT DISTINCT pid from tt_content ORDER BY tstamp LIMIT 5;

Is there a way to add DISTINCT to the select function in typoscript?

Thanks.

-- 
cheers,
Steffen



More information about the TYPO3-english mailing list