I’m trying to execute a JPQL query like in your example:
ValueLoadContext context = ValueLoadContext.create()
"select o.customer, sum(o.amount) from demo$Order o " +
“where o.date >= :date group by o.customer”)
List list = dataManager.loadValues(context);
Only problem is that in my case that table “order” is in an external SQL Server DB and I get “The abstract schema type ‘…’ is unknown” as an error. Is this a limitation?
Strange because I can use LoadContext( that is read entities) but no ValueLoadContext seems to work on that table.