@vsr1
I need to pass dynamic values to OBJECT_PAIRS method.
If I am trying through couchbase with actual json object , I am able to get a response.
But from code it is returning empty response.
Query
@Query(“SELECT *, META().id AS _ID, META().cas AS _CAS FROM "
+ “#{#n1ql.bucket} WHERE ANY AND EVERY v IN OBJECT_PAIRS($filters) SATISFIES (ANY v1 IN OBJECT_PAIRS(a.b.c)”
+ " SATISFIES v1.name = v.name AND v.val = v1.val END) END”)
List getList(@Param(“filters”) String filters);
If i write this query as below
“SELECT *, META().id AS _ID, META().cas AS _CAS FROM "
+ “#{#n1ql.bucket} WHERE ANY AND EVERY v IN OBJECT_PAIRS({“key”:“value”}) SATISFIES (ANY v1 IN OBJECT_PAIRS(a.b.c)”
+ " SATISFIES v1.name = v.name AND v.val = v1.val END) END”
Then the response is there.
the filters variable is a map where it can contain muliple values ,so I want to set this up dynamically,