Answered Filtering with the where clause in MIGX not working

- 74 Posts
random_noob Reply #1, 10 years, 1 month ago
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
- 5,888 Posts
Bruno17 Reply #2, 10 years, 1 month ago
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!