Combining multiple &where in GetResources using AND OR

Support
#1

We have a couple of &where=`` json strings which work independently of each other in a getResources / getPage snippet call.

The first &where combines users who have published posts. It works:

&where=`[{"createdby:=":"1"},{"OR:createdby:=":"11"},{"OR:createdby:=":"86"}]`

The second searches between date ranges which are submitted using a date picker on a form. It also works:

&where=`{"publishedon:>":1639094400,"AND:publishedon:<":1639526400}`

I want to combine the two together, so returning all post/resources published by any of these users where the resources where published between these two dates. I’ve tried all kinds of combinations of [{,}] and reworkings to combine the above, but can’t come up with anything which seems to work. Would anyone be able to point me in the right direction? Thanks

Revo 2.8.1

#2

try

&where=`{"publishedon:>":1639094400,"publishedon:<":1639526400,"createdby:IN":[1,11,86]}`
#3

Thanks Bruno. It works!
I noticed it only seems to work with the CREATEDBY as the final thing in the array like you have it, not as the first. Thanks again

#4

that shouldn’t make a difference, where it is positioned in the array.