I currently am trying to move my n1ql into just a jpa query method, because I feel like it’s simple enough to do so.
What’s wrong with this?
N1qlPrimaryIndexed
ViewIndexed(designDoc = "myobject")
public interface MyObjectRepository extends CouchbasePagingAndSortingRepository<MyObject,
String> {
//this works
@Query("SELECT meta().id as _ID, meta().cas as _CAS, * FROM `my-bucket` mb " +
"WHERE mb.name like $1 OR ANY Parent " +
"IN mb.Parents SATISFIES Parent.name like $1 END")
List<MyObject> searchObjectByName(String name);
// this doesn't
List<MyObject> findByNameContains(String name);
}