[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