We launched new forums in March 2019—join us there. In a hurry for help with your website? Get Help Now!
    • 45766
    • 78 Posts
    Hi,

    is it possible to use a TV inside the &where parameter?

    I tried it like this, but it doesn't work:

    [[!migxLoopCollection?
     	
     	&classname=`modResource`
     	&joins=`[
     		{"alias":"Slider","classname":"modTemplateVarResource","on":"Slider.contentid=modResource.id AND Slider.tmplvarid=24"}
     	]`
     	
     	&selectfields=`id,pagetitle`
     	
     	[[- <!-- search -->]]
    	&where=`[
    		{"published":"1"},
    		{"parent":"[[!+userPubId]]"},
                   {"Slider":"true"}
    	]`
    		
    	[[- <!-- sort -->]]
    	&sortConfig=`[{"sortby":"publishedon","sortdir":"DESC"}]`
    	
    	
    		
    ]]
    

    This question has been answered by stefan79w. See the first response.

    • discuss.answer
      • 45766
      • 78 Posts
      Ok. Find the Solution.

      This works
       {"Slider.value":"true"}
      


      In the chunk for the template this code is needed
      [[+Solution_value]]