We are using CAP Java and HANA Cloud. We can succesfully execute simple SQL statements by using the Query Builder API but we have some problems with more complex queries, for example:
Select.from(Apicalls_.class) .distinct() .columns(c -> func("TO_DATE", c.Date()).as("date"), c -> func("COUNT", c.UserId()).as("count")) .groupBy(g -> func("TO_DATE", g.Date())) .orderBy(o -> func("TO_DATE", o.Date()).asc())
I find many examples for Node.js but the examples for CAP Java are always very simple SQL statements....
Can anybody help with some examples?