ObjectDB Database Search

do not support aggregate queries (max, min, count, sum and avg). ObjectDB supports rich queries, including aggregate queries, as part of its support of JPQL (JPA Query Language) and JDOQL (JDO Query Language). ObjectDB is faster than other products.

Dear ObjectDB, Can someone give me a tip, to make the aggregated query work. I am filling a tableview with a normal query "SELECT p From Recept p, with no problem. But when I trying to fill a tableview with an aggregated query : "SELECT SUM(getValue()) AS value ,getUnit() AS unit,getName() AS name

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

Does aggregate function "greatest" work on entity objects? do not come to the function "compareTo" @Entity public class ChatHistoryItem extends AbstractObject implements Comparable { private static final long serialVersionUID = 1L; @Override public int compareTo(Object t) { //Logger.getLogger

Problem of query With an aggregate function

Group by: list if no aggregate function is specified

Numeric values can appear in JPQL queries in several forms: As numeric literals , such as 123 and -12.5 . As parameters that are bound to numeric arguments. As path expressions that navigate to persistent numeric fields. As aggregate expressions , such as COUNT . As collection functions

. Since: Jakarta Persistence (JPA) 3.2 Expression avg ( Expression x ) Create an aggregate expression applying ... ) Create an aggregate expression applying the count operation. Parameters: x - expression representing ... Expression countDistinct ( Expression x ) Create an aggregate expression applying the count distinct

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

results --------------------- Evaluate aggregate expressions: count(a). Step 5: Apply selection