ObjectDB Database Search

(no Aggregates ) The following query groups all the countries by their first letter: SELECT SUBSTRING(c ... : The properties that are used for grouping (each group has a unique value combination). Aggregate calculations ... the group. The aggregate calculation gives the GROUP BY clause its power. Actually, without aggregate

, derived attributes, grouping queries and aggregate queries) which are usually missing from Object Oriented ... are also used for fast ordering and aggregate calculations . Lazy/Eager Loading Automatic pre-loading ... and aggregates ). ORDER BY (including ASC, DESC). Aggregates (COUNT, SUM, AVG, MAX, MIN). Query

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

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.

object is expected. The following aggregate query always returns a single result object ... = (Long)query. getSingleResult (); An aggregate COUNT query always returns one result, by definition

Problem of query With an aggregate function

Group by: list if no aggregate function is specified

Numeric values may appear in JPQL queries in many forms: as  numeric literals - e.g. 123 , -12.5 . as parameters - when numeric values are assigned as arguments. as  path expressions - in navigation to persistent numeric fields. as aggregate expressions - e.g. COUNT. as collection

. The SELECT clause counts all these objects (this is an aggregate query with no GROUP BY - all the objects

. 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

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

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

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

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

Jakarta Persistence (JPA) Method in jakarta.persistence.criteria.CriteriaBuilder Expression greatest (    Expression x ) Create an aggregate expression for finding the greatest of the values (strings, dates, etc). Parameters: x - expression representing input value to greatest operation

Jakarta Persistence (JPA) Method in jakarta.persistence.criteria.CriteriaBuilder Expression least (    Expression x ) Create an aggregate expression for finding the least of the values (strings, dates, etc). Parameters: x - expression representing input value to least operation Returns: least expression. Since: Jakarta Persistence (JPA) 1.0

: com.objectdb.o.UserException: Invalid result expression 'java.util.List' for an aggregate query ... : "Invalid result expression 'java.util.List' for an aggregate query" Class: @Entity @Table(name

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

Hello, I have a problem when I run this aggregation query: Query q = em.createQuery(         "SELECT cc.totalCC.moneda, SUM(cc.totalCC.importe) FROM ComprobanteContable cc " +         "WHERE cc.cuenta=:cuenta GROUP BY cc.totalCC