Hi Couchbase team.
I am trying to use execute N1QL query using spring-data and couchbase does not return any results for this:
@Query("#{#n1ql electEntity} use KEYS [ $myKeys ]")
List findAllByKeys(@Param(“myKey”) String myKeys), i also tried to use JsonArray instead of string but it generates single key “[‘key1’ ‘key2’]” and throws an error invalid key, so i am passing the string:
String myKeys= “‘key1’, ‘key2’” and i get 0 results even the request is correct and goes through.
String myKeys= “key1, key2” also does not return any results:
Executing N1QL query: {“scan_consistency”:“statement_plus”,“statement”:“SELECT META(my_bucket).id AS _ID, META(my_bucket).cas AS _CAS, my_bucket.* FROM my_bucket use KEYS [ $myKey ]”,"$myKey":“key1, key2”}
When i try from command line it finds results.
curl -u user:user -v http://localhost:8093/query/service -d ‘statement=SELECT META(my_bucket).id AS _ID, META(my_bucket).cas AS _CAS, my_bucket.* FROM my_bucket use KEYS $myKey&$myKey=[“key1”,“key2”]’
Please suggest how can i get list of documents using documents key using spring-data and N1QL.
Thanks!