[TYPO3-english] how to use restult of USER function in where clause?
Erich Specht
erich at erichspecht.com
Wed Aug 21 17:15:53 CEST 2013
I have a USER function that returns a list of uids of tt_news items selected
via a flexible content element. The result of the function is a string
like: 3.4
I'm trying to use the result of the function in the where clause of a news
plugin. The following works, but when I try to insert the dynamic version
of the where clause it doesn't work.
#WORKING VERSION - WITH HARD-CODED UIDs
lib.field_footer < plugin.tt_news
lib.field_footer {
pid_list = 18
recursive = 200
categoryMode = 0
code=LIST
listOrderBy = datetime desc
limit = 10
noPageBrowser = 1
extensions.ttnews_selectconf {
where (
tt_news.uid IN (3, 4,5)
)
}
}
#NOT WORKING - WITH DYNAMIC UIDs
temp.related_news = COA
temp.related_news {
10 = TEXT
10.value = tt_news.uid IN (
20 = USER
20 {
userFunc = user_various->getRelatedNewsItems
reverseOrder = 1
debugOutput = 1
testconstant = {$testconstant}
}
30 = TEXT
30.value = )
}
Instead of the above where clause, I'm trying this:
extensions.ttnews_selectconf {
where < temp.related_news
}
Please let me know if you have any suggstions on how to dynamically insert
the where clause.
More information about the TYPO3-english
mailing list