Internal Website Search

21-30 of 32 resultsRefresh

IN expression in a Criteria Query

expression 'a' for an aggregate query at com.objectdb.o.MSG.d(MSG.java:61) at com.objectdb.o.QNF.l ... group has unique value combination). Aggregate

How to query for list of lists ?

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

Queries are slow on a large database

;== (this.Id) javax.jdo.JDOUserException Invalid context for aggregate 'count' (error 743)

composite index not used in query

.classIdentifier='(TC)'). Step 4: Group results --------------------- Evaluate aggregate expressions

max(x)

an aggregate expression applying the numerical max operation.

greatest(x)

"> Create an aggregate expression for finding the greatest of the values (strings, dates, etc).

least(x)

"> Create an aggregate expression for finding the least of the values (strings, dates, etc).

avg(x)

"> Create an aggregate expression applying the avg operation.

Issue with UPPER ?

--------------------- Evaluate aggregate expressions:   count($1). Step 11: Apply selection ... !=null))). Step 10: Group results --------------------- Evaluate aggregate expressions:   ... !=null),($2!=null))). Step 10: Group results --------------------- Evaluate aggregate expressions

setGrouping(group)

, or an aggregate evaluated once per group.