- TIBCO BusinessEvents®
- CEP Query
- Query
- Datagrid
- Aggregate

# Query.Datagrid.Aggregate

## Description

Query aggregate functions

## Functions

Name | Signature and Synopsis
--- | ---
`avg` | `void avg(String resultSetName, String entityUri, String fieldName)` Find the average of the entities from the field specified by field name, of the specified URI.
`avgList` | `Object avgList(String resultSetName, String entityUri, String fieldName)` Find the average of the entities from the field specified by field name, of the specified URI.
`count` | `void count(String resultSetName, String entityUri)` Count the number of entities of the URI specified.
`countList` | `Object countList(String resultSetName, String entityUri)` Count the number of entities of the URI specified.
`filterAvg` | `void filterAvg(String resultSetName, String entityUri, String fieldName, String filter)` Find the average of the entities from the field specified by field name, of the specified URI, which satisfies the condition in the filter.
`filterAvgList` | `Object filterAvgList(String resultSetName, String entityUri, String fieldName, String filter)` Find the average of the entities from the field specified by field name, of the specified URI, which satisfies the condition in the filter.
`filterCount` | `void filterCount(String resultSetName,String entityUri, String filter)` Count the number of entities of the specified URI, which satisfies the condition in the filter.
`filterCountList` | `Object filterCountList(String resultSetName,String entityUri, String filter)` Count the number of entities of the specified URI, which satisfies the condition in the filter.
`filterMax` | `void filterMax(String resultSetName, String entityUri, String fieldName, String filter)` Find the maximum of the entities from the field specified by field name, of the specified URI, which satisfies the condition in the filter.
`filterMaxList` | `Object filterMaxList(String resultSetName, String entityUri, String fieldName, String filter)` Find the maximum of the entities from the field specified by field name, of the specified URI, which satisfies the condition in the filter.
`filterMin` | `void filterMin(String resultSetName, String entityUri, String fieldName, String filter)` Find the minimum of the entities from the field specified by field name, of the specified URI, which satisfies the condition in the filter.
`filterMinList` | `Object filterMinList(String resultSetName, String entityUri, String fieldName, String filter)` Find the minimum of the entities from the field specified by field name, of the specified URI, which satisfies the condition in the filter.
`filterSum` | `void filterSum(String resultSetName, String entityUri, String fieldName, String filter)` Find the sum of the entities from the field specified by field name, of the specified URI, which satisfies the condition in the filter.
`filterSumList` | `Object filterSumList(String resultSetName, String entityUri, String fieldName, String filter)` Find the sum of the entities from the field specified by field name, of the specified URI, which satisfies the condition in the filter.
`groupAvg` | `void groupAvg(String resultSetName, String entityUri, String fieldName, String filter, String... groupByFieldNames)` Find the average of the entities from the field specified by field name, of the specified URI, which satisfies the condition in the filter for each group.
`groupAvgList` | `Object groupAvgList(String resultSetName, String entityUri, String fieldName, String filter, String... groupByFieldNames)` Find the average of the entities from the field specified by field name, of the specified URI, which satisfies the condition in the filter for each group.
`groupCount` | `void groupCount(String resultSetName, String entityUri, String filter, String... groupByFieldNames)` Count the number of entities of the specified URI, which satisfies the condition in the filter for each group.
`groupCountList` | `Object groupCountList(String resultSetName, String entityUri, String filter, String... groupByFieldNames)` Count the number of entities of the specified URI, which satisfies the condition in the filter for each group.
`groupMax` | `void groupMax(String resultSetName, String entityUri, String fieldName, String filter, String... groupByFieldNames)` Find the maximum of the entities from the field specified by field name, of the specified URI, which satisfies the condition in the filter for each group.
`groupMaxList` | `Object groupMaxList(String resultSetName, String entityUri, String fieldName, String filter, String... groupByFieldNames)` Find the maximum of the entities from the field specified by field name, of the specified URI, which satisfies the condition in the filter for each group.
`groupMin` | `void groupMin(String resultSetName, String entityUri, String fieldName, String filter, String... groupByFieldNames)` Find the minimum of the entities from the field specified by field name, of the specified URI, which satisfies the condition in the filter for each group.
`groupMinList` | `Object groupMinList(String resultSetName, String entityUri, String fieldName, String filter, String... groupByFieldNames)` Find the minimum of the entities from the field specified by field name, of the specified URI, which satisfies the condition in the filter for each group.
`groupSum` | `void groupSum(String resultSetName, String entityUri, String fieldName, String filter, String... groupByFieldNames)` Find the sum of the entities from the field specified by field name, of the specified URI, which satisfies the condition in the filter for each group.
`groupSumList` | `Object groupSumList(String resultSetName, String entityUri, String fieldName, String filter, String... groupByFieldNames)` Find the sum of the entities from the field specified by field name, of the specified URI, which satisfies the condition in the filter for each group.
`max` | `void max(String resultSetName, String entityUri, String fieldName)` Find the maximum of the entities from the field specified by field name, of the specified URI.
`maxList` | `Object maxList(String resultSetName, String entityUri, String fieldName)` Find the maximum of the entities from the field specified by field name, of the specified URI.
`min` | `void min(String resultSetName, String entityUri, String fieldName)` Find the minimum of the entities from the field specified by field name, of the specified URI.
`minList` | `Object minList(String resultSetName, String entityUri, String fieldName)` Find the minimum of the entities from the field specified by field name, of the specified URI.
`sum` | `void sum(String resultSetName, String entityUri, String fieldName)` Find the sum of the entities from the field specified by field name, of the specified URI.
`sumList` | `Object sumList(String resultSetName, String entityUri, String fieldName)` Find the sum of the entities from the field specified by field name, of the specified URI.