I am using the DatabaseClient to perform my sql queries and I don't see how I can do a group by:
databaseClient.select()
.from( myClass.class )
.matching( where( "row_1" ).is( "value_1" ) )
//group by row_2 ...
.orderBy( Sort.Order.desc( "row_3" ) )
.page( pageable )
.fetch()
.all();
A workaround solution using sql directly.
Check the complete codes.