ObjectDB Database Search

we are using this aggregate query to collect some data: select p3.doubleValue,c1.classIdentifier,c1.objectName,sum(p4.doubleValue),sum(p4.doubleValue*p5.doubleValue),0,p7.doubleValue,p3.name,count(o) from ObjectNode o INNER JOIN o.properties p1 INNER JOIN o.properties p2  INNER JOIN o

Problem of query With an aggregate function

Jakarta Persistence (JPA) Method in jakarta.persistence.criteria.CriteriaBuilder Expression avg (    Expression x ) Create an aggregate expression applying the avg operation. Parameters: x - expression representing input value to avg operation Returns: avg expression. Since: Jakarta Persistence (JPA) 1.0

Jakarta Persistence (JPA) Method in jakarta.persistence.criteria.CriteriaBuilder Expression sum (    Expression x ) Create an aggregate expression applying the sum operation. Parameters: x - expression representing input value to sum operation Returns: sum expression. Since: Jakarta Persistence (JPA) 1.0

Jakarta Persistence (JPA) Method in jakarta.persistence.criteria.CriteriaBuilder Expression sumAsLong (    Expression x ) Create an aggregate expression applying the sum operation to an Integer-valued expression, returning a Long result. Parameters: x - expression representing input

Jakarta Persistence (JPA) Method in jakarta.persistence.criteria.CriteriaBuilder Expression sumAsDouble (    Expression x ) Create an aggregate expression applying the sum operation to a Float-valued expression, returning a Double result. Parameters: x - expression representing input