[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 = (| 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