&where syntax question

- ☆ A M B ☆
- 3,141 Posts
Mark Hamstra Reply #21, 11 years, 10 months ago
It looks like the original question has been answered, but this should've been the correct syntax for the filtering:
```
[[!pdoUsers?
&tpl=`userListTpl`
&where=`{"modUserProfile.fax:=":"0000000000",
         "AND:modUserProfile.comment:=":"Member",
         "OR:modUserProfile.zip:IN":["83206", "83209", "83201"]}`
&limit=`0`
&useExtended=`1`]]
```
The reason the original didn't work is because you're setting array keys and values, and it had the same array key ("OR:modUserProfile.zip:IN") for three of the conditions.
Mark Hamstra • Developer spending his days working on Premium Extras and a MODX Site Dashboard with the ability to remotely upgrade MODX and extras to make the MODX world a little better.

Tweet me @mark_hamstra, check my infrequent blog at markhamstra.com, my slightly more frequent ramblings at MODX.today or see code at Github.