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

    I'm trying to filter my migx tv to grab specific items using the where clause. For whatever reason, I'm not get the where call to work.

    [[getImageList?
        &tvname=`team_members`
        &tpl=`team_memberTpl`
        &limit=`0`
        &where=`{"published:=":"1","position:!=":"Ambassador","position:!=":"Attendant","year:=":"[[time:date=`%Y`]]"}`
    ]]
    


    Any ideas where I'm going wrong?

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

    • discuss.answer
      • 4172
      • 5,888 Posts
      try to begin with only one condition

      {"published:=":"1"}


      and add one by one. At which condition does it stop working?
      also try every condition alone.

      Then, you can't have the same key more than once.
      For the position try:

      {"position:in_array":"Ambassador,Attendant"}


      If you have much items to search and you do much filtering, it might be better to have a custom-table for them and use a MIGXdb-TV instaed.


        -------------------------------

        you can buy me a beer, if you like MIGX

        http://webcmsolutions.de/migx.html

        Thanks!