That totally worked !! with below syntax (for future forum browsers)
Edit: That did not work actually, may be my syntax is not right. But it
is not doing what IN statement would do. It is actually working only
with the first where clause i.e date = $1 . Its getting me all docs
which satisfies the date criteria with out heed to IN statement in my
syntax.
ParameterizedN1qlQuery
query1 = N1qlQuery.parameterized("select * from `mybucket` WHERE date =
$1 and $2", placeholderValues);```
**Note that the query structure has slightly changed**