Internal Website Search

Dear ObjectDB, Can someone give me a tip, to make the aggregated query work. I am filling 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

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

Problem of query With an aggregate function

> GROUP BY as DISTINCT (no Aggregates) Aggregate ... the group. The aggregate calculation gives the GROUP BY clause its power

, grouping queries and aggregate queries) which are usually missing from Object Oriented Databases ... /index#indexes_in_queries">fast ordering and aggregate calculations. HAVING and aggregate_functions">aggregates

that an essential feature is missing. For example, some competing products do not support aggregate queries (max, min, count, sum and avg). ObjectDB supports rich queries, including aggregate queries

a more convenient method when exactly one result object is expected. The following aggregate ... /java/jpa/Query/getSingleResult">getSingleResult(); An aggregate COUNT query

clause counts all these objects (this is an aggregates_no_group_by">aggregate query with no GROUP BY - all the objects are considered as one group

class="teaser"> Create an aggregate expression applying the avg operation. Create an aggregate expression ... ">Expression<?>  x) Create an aggregate