It was a typo in my original question. Below is what i have observed.
My query looks like this -
String query = select * from table1 where guid is not missing and doc_type=‘xyz’ and (guid in $guid_list);
I have my guid_list as below -
List listOfGuid = new ArrayList<>();
listOfGuid.add(“a1b3594f-0b76-4c54-8206-db2c16286320”);
com.couchbase.client.java.document.json.JsonObject placeHolders = com.couchbase.client.java.document.json.JsonObject.create()
.put(“guid_list”, JsonArray.from(listOfGuid));
N1qlQuery statement = N1qlQuery.parameterized(query,placeHolders);
This doesnt work. But if i try to pass the guid_list with single quote and hardcode the list in my query it works fine. Not sure why it doesnt work when i pass it as list. Is it because when i pass as list it goes in as double quotes [“a1b3594f-0b76-4c54-8206-db2c16286320”] instead of [‘a1b3594f-0b76-4c54-8206-db2c16286320’].
I saw same issue was reported by someone on different thread.