jpql; SUM; GROUP BY; BDM

JPQL custom query in Manage BDM with SUM doesn't work

Hello everyone
in Bonita 7.5 I'm triyng to run this custom query

SELECT SUM(s.quantity), s.clientName
FROM ServiceRequest s
GROUP BY s.clientName

but without any answer from the engine. I tried to print also tha json variables but with no answer. Every default query works good.
In H2 work great this one

SELECT SUM(quantity), clientName
FROM ServiceRequest
GROUP BY clientName

I was wrong, I know, but where?

Notifications