How to query JsonStringArray

SQL++
4

Hi,

I am trying the same with my java code, but IN statement seems to fail to take in my parameter in List, array, or plan string with [ ] . My failing code is below

sample jsons in mybucket:

{
“date”: “2015-02-15”,
“someField”: “ABC”,

}

{
“date”: “2015-02-15”,
“someField”: “BBC”,

}

Code I am using:

ParameterizedN1qlQuery query1 = N1qlQuery.parameterized("select * from `mybucket` WHERE date = $1 and someField IN $2", placeholderValues);```

If i remove the "someField IN $2" part it works fine. Is there a specific way to handle IN statement in N1QL?