15 | How to query for list of lists ?.util.List' for an aggregate query at com.objectdb.o.MSG.d(MSG.java:61) at com.objectdb.o.QRC.G(QRC ... Adding more details: I get the same error: "Invalid result expression 'java.util.List' for an aggregate |
15 | IN expression in a Criteria Query.objectdb.o.UserException: Invalid result expression 'a' for an aggregate query at com.objectdb.o.MSG ... value combination). Aggregate calculations (count, sum, avg, max, min) that are carried |
10 | Queries are slow on a large database.JDOUserException Invalid context for aggregate 'count' (error 743) (position 0) at com.objectdb.jdo.JdoQuery |
6 | sumAsDouble(x)Method javax.persistence.criteria.CriteriaBuilder Expression<Double> sumAsDouble( Expression<Float> x ) Create an aggregate expression applying the sum operation to a Float-valued expression, returning a Double result. Parameters: x - expression representing input value to sum operation Returns: sum expression Since: JPA 2.0 |
6 | sum(x)Method javax.persistence.criteria.CriteriaBuilder Expression<N> sum( Expression<N> x ) Create an aggregate expression applying the sum operation. Parameters: x - expression representing input value to sum operation Returns: sum expression Since: JPA 2.0 |
6 | countDistinct(x)Method javax.persistence.criteria.CriteriaBuilder Expression<Long> countDistinct( Expression<?> x ) Create an aggregate expression applying the count distinct operation. Parameters: x - expression representing input value to count distinct operation Returns: count distinct expression Since: JPA 2.0 |
6 | count(x)Method javax.persistence.criteria.CriteriaBuilder Expression<Long> count( Expression<?> x ) Create an aggregate expression applying the count operation. Parameters: x - expression representing input value to count operation Returns: count expression Since: JPA 2.0 |
6 | greatest(x)Method javax.persistence.criteria.CriteriaBuilder Expression<X> greatest( Expression<X> x ) Create an aggregate expression for finding the greatest of the values (strings, dates, etc). Parameters: x - expression representing input value to greatest operation Returns: greatest expression Since: JPA 2.0 |
3 | Issue with UPPER ? --------------------- Evaluate aggregate expressions: count($1). Step 11: Apply selection ... aggregate expressions: count($1). Step 11: Apply selection ----------------------- Apply selection ... results --------------------- Evaluate aggregate expressions: count($1). Step 11: Apply |
2 | Wrong type on SUM functionHello, 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.moneda"); List<Object[]> resultList = q.setParameter("cuenta |
