queries - srujanabala/springboot-couchbase GitHub Wiki

I tested this query sample, it is working.

@Query(value = "SELECT META(Test).id as _ID, META(Test).cas as _CAS, Test.* FROM Test") List getAllByQuery();

//sub query example
@Query(value = "SELECT MAX(t1.age) FROM Test as t1 where t1.age < (SELECT MAX(t2.age) FROM Test as t2)")
Integer getSecondHighestAgeStudent();

Kindly add corresponding method handlers in Controller class.