# Internal Website Search

**1-28 of 28 results**

## GROUP BY and HAVING clauses (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 | |

## ObjectDB Object Database Features, 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 | |

## Java FX tableview fill with an aggregated 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 | |

## Running JPA Queries. The following aggregate query always returns a single result object, which is a Long object ... . getSingleResult (); An aggregate COUNT query always returns one result, by definition. In other cases | |

## Is ObjectDB better than competing object databases? 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. | |

## Does aggregate function "greatest" work on entity objects? 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 | |

## Performance issues on aggregate query 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 functionProblem of query With an aggregate function | |

## Group by: list if no aggregate function is specifiedGroup by: list if no aggregate function is specified | |

## Numbers in JPQL and Criteria Queries 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 | |

## Paths and Types in JPQL and Criteria API. The SELECT clause counts all these objects (this is an aggregate query with no GROUP BY - all the objects | |

## javax.persistence.criteria.CriteriaBuilder Expression avg ( Expression x) Create an aggregate expression applying the avg operation. Parameters ... x) Create an aggregate expression applying the count operation. Parameters: x - expression ... countDistinct ( Expression x) Create an aggregate expression applying the count distinct operation | |

## How to query for list of lists ?: 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 | |

## CriteriaBuilder.avg(x) - JPA Method JPA Method in javax.persistence.criteria.CriteriaBuilder Expression avg ( Expression x ) Create an aggregate expression applying the avg operation. Parameters: x - expression representing input value to avg operation Return: avg expression Since: JPA 2.0 | |

## CriteriaBuilder.sum(x) - JPA Method JPA Method in javax.persistence.criteria.CriteriaBuilder Expression sum ( Expression x ) Create an aggregate expression applying the sum operation. Parameters: x - expression representing input value to sum operation Return: sum expression Since: JPA 2.0 | |

## CriteriaBuilder.sumAsLong(x) - JPA Method JPA Method in javax.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 value to sum operation Return: sum expression Since: JPA 2.0 | |

## CriteriaBuilder.sumAsDouble(x) - JPA Method JPA Method in javax.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 value to sum operation Return: sum expression Since: JPA 2.0 | |

## CriteriaBuilder.max(x) - JPA Method JPA Method in javax.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 Return: max expression Since: JPA 2.0 | |

## CriteriaBuilder.min(x) - JPA Method JPA Method in javax.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 Return: min expression Since: JPA 2.0 | |

## CriteriaBuilder.greatest(x) - JPA Method JPA Method in javax.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 Return: greatest expression Since: JPA 2.0 | |

## CriteriaBuilder.least(x) - JPA Method JPA Method in javax.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 Return: least expression Since: JPA 2.0 | |

## CriteriaBuilder.count(x) - JPA Method JPA Method in javax.persistence.criteria.CriteriaBuilder Expression count ( Expression x ) Create an aggregate expression applying the count operation. Parameters: x - expression representing input value to count operation Return: count expression Since: JPA 2.0 | |

## CriteriaBuilder.countDistinct(x) - JPA Method JPA Method in javax.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 Return: count distinct expression Since: JPA 2.0 | |

## composite index not used in query results --------------------- Evaluate aggregate expressions: count(a). Step 5: Apply selection | |

## javax.jdo.Query to obtain persistent instances, values, and aggregate data from the data store. The PersistenceManager ... contained in the grouping, or an aggregate evaluated once per group. Parameters: group a - comma ... expressions, including field values (projections) and aggregate function results. Parameters: data | |

## Wrong type on SUM function 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 | |

## Query.setResult(data) - JDO Method (projections) and aggregate function results. Parameters: data - a comma-delimited list of expressions (fields, functions on fields, or aggregate functions) to return from this query Since: JDO 2.0 | |

## Query.setGrouping(group) - JDO Method JDO Method in javax.jdo.Query void setGrouping ( String group ) Set the grouping expressions, optionally including a "having" clause. When grouping is specified, each result expression must either be an expression contained in the grouping, or an aggregate evaluated once per group |