Answered &where property: json syntax question

- 793 Posts
ottogal Reply #1, 11 years, 9 months ago
Hi all,
I've got an array ["111","112","113"] and want to do this (symbolic code):
```
&where=` [[+foo]] IN ["111","112","113"] ? `
```
What is the correct sytax for this condition?
This question has been answered by multiple community members. See the first response.
discuss.next
discuss.answer
- 5,888 Posts
Bruno17 Reply #2, 11 years, 9 months ago
try:
```
&where=`{"yourfield:IN":["111","112","113"]}`
```
-------------------------------

you can buy me a beer, if you like MIGX

http://webcmsolutions.de/migx.html

Thanks!
- 793 Posts
ottogal Reply #3, 11 years, 8 months ago

Danke!
Is there any documentation of that syntax?
discuss.prev
discuss.answer
- ☆ A M B ☆
- 1,031 Posts
Jako Reply #4, 11 years, 8 months ago

Look here: http://rtfm.modx.com/xpdo/2.x/class-reference/xpdoquery/xpdoquery.where

The array has to be json encoded to use it as parameter for getResources/pdoResources and other snippets.

Tests/Edits for that could be done here: https://www.jsoneditoronline.org/
- 793 Posts
ottogal Reply #5, 11 years, 8 months ago

Danke as well! Very helpful links.