Interface StandardDataQueryBuilder.AggregationList
- All Known Implementing Classes:
StandardDataQueryBuilderImpl.AggregationListImpl
- Enclosing interface:
StandardDataQueryBuilder
public static interface StandardDataQueryBuilder.AggregationList
-
Method Summary
Modifier and TypeMethodDescriptionavgFieldValue(String aggregationName, String fieldName) Adds an aggregation that will calculate the average of a direct numeric field.avgNestedFieldFiltered(String aggregationName, String nestedPath, String filterField, String filterValue, String fieldName) Avg aggregation on a numeric field inside an ES nested object, with the document selection restricted by a filter on another field of the same nested object (e.g. only nested objects wheretype=tool).avgVariableValue(String aggregationName, String variableName) Adds an aggregation that will calculate the average value of a numeric variable with the given name.countActive(String aggregationName) Adds an aggregation that will count the active instances.countByIdField(String aggregationNane) Adds an aggregation that will do a cardinality aggregation on the id field, which gives back an approximation of the amount of documents.countCompleted(String aggregationName) Adds an aggregation that will count the completed instances.countDistinctFieldValue(String aggregationName, String fieldName) Cardinality (distinct count) aggregation on a keyword field.countStarted(String aggregationName) Adds an aggregation that will count the started instances.distributionBusinessStatus(String aggregationName, int size) Adds an aggregation that will create a distribution (i.e. buckets) of the possible values of the business status field.distributionParentScopeBusinessStatus(String aggregationName, int size) Adds an aggregation that will create a distribution (i.e. buckets) of the possible values of the parent scope business status field.distributionRootScopeBusinessStatus(String aggregationName, int size) Adds an aggregation that will create a distribution (i.e. buckets) of the possible values of the root scope business status field.distributionVariableValue(String aggregationName, String variableName, int size) Adds an aggregation that will create a distribution (i.e. buckets) of the possible text values of a variable.groupByDateCompleted(String aggregationName, String interval) Adds an aggregation that will group the results by date started The interval can be day, week, month, quarter or yeargroupByDateStarted(String aggregationName, String interval) Adds an aggregation that will group the results by end time The interval can be day, week, month, quarter or yeargroupByDateStartedAndField(String aggregationName, String interval, String fieldName, int size, String order) Date histogram on startTime with a terms sub-aggregation on the given keyword field.groupByDateStartedAndFieldWithSumField(String aggregationName, String interval, String fieldName, int size, String sumFieldName, String order) Date histogram on startTime with a terms sub-aggregation on a keyword field and a sum leaf-aggregation on a numeric field per term.groupByDateStartedWithAvgField(String aggregationName, String interval, String fieldName) Date histogram on startTime with an avg sub-aggregation on the given numeric field.groupByDateStartedWithAvgNestedFieldFiltered(String aggregationName, String nestedPath, String filterField, String filterValue, String fieldName, String interval) Date histogram on startTime with an avg sub-aggregation over a numeric field inside an ES nested object, with the document selection restricted by a filter on another field of the same nested object.groupByDateStartedWithPercentileField(String aggregationName, String interval, String fieldName, double percent) Date histogram on startTime with a single-percentile sub-aggregation on a numeric field.groupByDateStartedWithSumField(String aggregationName, String interval, String fieldName) Date histogram on startTime with a sum sub-aggregation on the given numeric field.groupByDefinitionKey(String aggregationName) Adds an aggregation that will group the results by definition key.groupByDefinitionKeyAndState(String aggregationName) Adds an aggregation that will group the results by definition key and its state (completed/active).groupByField(String aggregationName, String fieldName, int size) Adds a terms aggregation on a keyword field.groupByFieldWithAvgField(String aggregationName, String fieldName, int size, String avgFieldName) Terms aggregation on a keyword field with an avg sub-aggregation on the given numeric field.groupByFieldWithAvgField(String aggregationName, String fieldName, int size, String avgFieldName, String order) Same asgroupByFieldWithAvgField(String, String, int, String)but with explicit bucket ordering; seegroupByFieldWithSumField(String, String, int, String, String)for acceptedordervalues.groupByFieldWithSumField(String aggregationName, String fieldName, int size, String sumFieldName) Terms aggregation on a keyword field with a sum sub-aggregation on the given numeric field.groupByFieldWithSumField(String aggregationName, String fieldName, int size, String sumFieldName, String order) Same asgroupByFieldWithSumField(String, String, int, String)but with explicit bucket ordering.groupByNestedField(String aggregationName, String nestedPath, String fieldName, int size) Adds a terms aggregation on a keyword field inside an ES nested object.groupByNestedFieldFiltered(String aggregationName, String nestedPath, String filterField, String filterValue, String fieldName, int size) Terms aggregation on a keyword field inside an ES nested object, with the bucket selection restricted by a filter on another field of the same nested object (e.g. only nested objects wheretype=tool).groupByNestedFieldFiltered(String aggregationName, String nestedPath, String filterField, String filterValue, String fieldName, int size, String order) Same asgroupByNestedFieldFiltered(String, String, String, String, String, int)but with a configurable sort direction on the innertermsaggregation by_count.groupByNestedFieldFilteredWithAvgField(String aggregationName, String nestedPath, String filterField, String filterValue, String fieldName, int size, String avgFieldName) Mirror ofgroupByNestedFieldFilteredWithSumField(String, String, String, String, String, int, String)using avg instead of sum.groupByNestedFieldFilteredWithAvgField(String aggregationName, String nestedPath, String filterField, String filterValue, String fieldName, int size, String avgFieldName, String order) Same asgroupByNestedFieldFilteredWithAvgField(String, String, String, String, String, int, String)but with explicit bucket ordering.groupByNestedFieldFilteredWithPercentileField(String aggregationName, String nestedPath, String filterField, String filterValue, String fieldName, int size, String percentileFieldName, double percent) Mirror ofgroupByNestedFieldFilteredWithSumField(String, String, String, String, String, int, String)using a single-percentile sub-aggregation.groupByNestedFieldFilteredWithPercentileField(String aggregationName, String nestedPath, String filterField, String filterValue, String fieldName, int size, String percentileFieldName, double percent, String order) Same asgroupByNestedFieldFilteredWithPercentileField(String, String, String, String, String, int, String, double)but with explicit bucket ordering.groupByNestedFieldFilteredWithSumField(String aggregationName, String nestedPath, String filterField, String filterValue, String fieldName, int size, String sumFieldName) Terms aggregation on a keyword field inside an ES nested object, restricted by a filter on a sibling field of that nested object, with a sum sub-aggregation on a numeric field within the same nested context.groupByNestedFieldFilteredWithSumField(String aggregationName, String nestedPath, String filterField, String filterValue, String fieldName, int size, String sumFieldName, String order) Same asgroupByNestedFieldFilteredWithSumField(String, String, String, String, String, int, String)but with explicit bucket ordering; seegroupByFieldWithSumField(String, String, int, String, String)for acceptedordervalues.maxFieldValue(String aggregationName, String fieldName) Adds an aggregation that will calculate the max of a direct numeric field.maxVariableValue(String aggregationName, String variableName) Adds an aggregation that will calculate the maximum value of a numeric variable with the given name.minFieldValue(String aggregationName, String fieldName) Adds an aggregation that will calculate the min of a direct numeric field.minVariableValue(String aggregationName, String variableName) Adds an aggregation that will calculate the minimum value of a numeric variable with the given name.percentileFieldValue(String aggregationName, String fieldName, double percent) Single-percentile aggregation on a numeric field.stddevVariableValue(String aggregationName, String variableName) Adds an aggregation that will calculate the standard deviation of a numeric variable with the given name.sumFieldValue(String aggregationName, String fieldName) Adds an aggregation that will calculate the sum of a direct numeric field.sumVariableValue(String aggregationName, String variableName) Adds an aggregation that will calculate the sum of a numeric variable with the given name.
-
Method Details
-
countByIdField
Adds an aggregation that will do a cardinality aggregation on the id field, which gives back an approximation of the amount of documents. -
countCompleted
Adds an aggregation that will count the completed instances. -
countActive
Adds an aggregation that will count the active instances. -
countStarted
Adds an aggregation that will count the started instances. -
groupByDefinitionKey
Adds an aggregation that will group the results by definition key. -
groupByDefinitionKeyAndState
Adds an aggregation that will group the results by definition key and its state (completed/active). -
groupByDateCompleted
StandardDataQueryBuilder.AggregationList groupByDateCompleted(String aggregationName, String interval) Adds an aggregation that will group the results by date started The interval can be day, week, month, quarter or year -
groupByDateStarted
StandardDataQueryBuilder.AggregationList groupByDateStarted(String aggregationName, String interval) Adds an aggregation that will group the results by end time The interval can be day, week, month, quarter or year -
maxVariableValue
StandardDataQueryBuilder.AggregationList maxVariableValue(String aggregationName, String variableName) Adds an aggregation that will calculate the maximum value of a numeric variable with the given name. -
minVariableValue
StandardDataQueryBuilder.AggregationList minVariableValue(String aggregationName, String variableName) Adds an aggregation that will calculate the minimum value of a numeric variable with the given name. -
avgVariableValue
StandardDataQueryBuilder.AggregationList avgVariableValue(String aggregationName, String variableName) Adds an aggregation that will calculate the average value of a numeric variable with the given name. -
stddevVariableValue
StandardDataQueryBuilder.AggregationList stddevVariableValue(String aggregationName, String variableName) Adds an aggregation that will calculate the standard deviation of a numeric variable with the given name. -
sumVariableValue
StandardDataQueryBuilder.AggregationList sumVariableValue(String aggregationName, String variableName) Adds an aggregation that will calculate the sum of a numeric variable with the given name. -
distributionVariableValue
StandardDataQueryBuilder.AggregationList distributionVariableValue(String aggregationName, String variableName, int size) Adds an aggregation that will create a distribution (i.e. buckets) of the possible text values of a variable. E.g. { 'a': 23, 'b': 12, 'c': 3} The results are ordered by value (most occurrences first) -
sumFieldValue
Adds an aggregation that will calculate the sum of a direct numeric field. -
avgFieldValue
Adds an aggregation that will calculate the average of a direct numeric field. -
maxFieldValue
Adds an aggregation that will calculate the max of a direct numeric field. -
minFieldValue
Adds an aggregation that will calculate the min of a direct numeric field. -
groupByField
StandardDataQueryBuilder.AggregationList groupByField(String aggregationName, String fieldName, int size) Adds a terms aggregation on a keyword field. -
groupByNestedField
StandardDataQueryBuilder.AggregationList groupByNestedField(String aggregationName, String nestedPath, String fieldName, int size) Adds a terms aggregation on a keyword field inside an ES nested object. Generates anestedwrapper around thetermsaggregation. -
countDistinctFieldValue
StandardDataQueryBuilder.AggregationList countDistinctFieldValue(String aggregationName, String fieldName) Cardinality (distinct count) aggregation on a keyword field. -
groupByDateStartedWithSumField
StandardDataQueryBuilder.AggregationList groupByDateStartedWithSumField(String aggregationName, String interval, String fieldName) Date histogram on startTime with a sum sub-aggregation on the given numeric field. -
groupByDateStartedWithAvgField
StandardDataQueryBuilder.AggregationList groupByDateStartedWithAvgField(String aggregationName, String interval, String fieldName) Date histogram on startTime with an avg sub-aggregation on the given numeric field. -
groupByDateStartedAndField
StandardDataQueryBuilder.AggregationList groupByDateStartedAndField(String aggregationName, String interval, String fieldName, int size, String order) Date histogram on startTime with a terms sub-aggregation on the given keyword field. -
groupByDateStartedAndFieldWithSumField
StandardDataQueryBuilder.AggregationList groupByDateStartedAndFieldWithSumField(String aggregationName, String interval, String fieldName, int size, String sumFieldName, String order) Date histogram on startTime with a terms sub-aggregation on a keyword field and a sum leaf-aggregation on a numeric field per term. -
groupByFieldWithSumField
StandardDataQueryBuilder.AggregationList groupByFieldWithSumField(String aggregationName, String fieldName, int size, String sumFieldName) Terms aggregation on a keyword field with a sum sub-aggregation on the given numeric field. -
groupByFieldWithSumField
StandardDataQueryBuilder.AggregationList groupByFieldWithSumField(String aggregationName, String fieldName, int size, String sumFieldName, String order) Same asgroupByFieldWithSumField(String, String, int, String)but with explicit bucket ordering. Acceptedordervalues:countDesc(default),countAsc,valueDesc(top-N by sub-agg sum) andvalueAsc. Selecting value-based ordering also bumpsshard_sizeto compensate for the terms-aggregation accuracy loss documented by Elasticsearch. -
groupByNestedFieldFiltered
StandardDataQueryBuilder.AggregationList groupByNestedFieldFiltered(String aggregationName, String nestedPath, String filterField, String filterValue, String fieldName, int size) Terms aggregation on a keyword field inside an ES nested object, with the bucket selection restricted by a filter on another field of the same nested object (e.g. only nested objects wheretype=tool). Generatesnested > filter > termsaggregation. -
groupByNestedFieldFiltered
StandardDataQueryBuilder.AggregationList groupByNestedFieldFiltered(String aggregationName, String nestedPath, String filterField, String filterValue, String fieldName, int size, String order) Same asgroupByNestedFieldFiltered(String, String, String, String, String, int)but with a configurable sort direction on the innertermsaggregation by_count. Use"asc"to surface least-used buckets, or"desc"for the default most-used behaviour. -
avgNestedFieldFiltered
StandardDataQueryBuilder.AggregationList avgNestedFieldFiltered(String aggregationName, String nestedPath, String filterField, String filterValue, String fieldName) Avg aggregation on a numeric field inside an ES nested object, with the document selection restricted by a filter on another field of the same nested object (e.g. only nested objects wheretype=tool). Generatesnested > filter > avgaggregation. -
groupByDateStartedWithAvgNestedFieldFiltered
StandardDataQueryBuilder.AggregationList groupByDateStartedWithAvgNestedFieldFiltered(String aggregationName, String nestedPath, String filterField, String filterValue, String fieldName, String interval) Date histogram on startTime with an avg sub-aggregation over a numeric field inside an ES nested object, with the document selection restricted by a filter on another field of the same nested object. Generatesdate_histogram > nested > filter > avgaggregation. -
groupByFieldWithAvgField
StandardDataQueryBuilder.AggregationList groupByFieldWithAvgField(String aggregationName, String fieldName, int size, String avgFieldName) Terms aggregation on a keyword field with an avg sub-aggregation on the given numeric field. Mirror ofgroupByFieldWithSumField(String, String, int, String). -
groupByFieldWithAvgField
StandardDataQueryBuilder.AggregationList groupByFieldWithAvgField(String aggregationName, String fieldName, int size, String avgFieldName, String order) Same asgroupByFieldWithAvgField(String, String, int, String)but with explicit bucket ordering; seegroupByFieldWithSumField(String, String, int, String, String)for acceptedordervalues. -
percentileFieldValue
StandardDataQueryBuilder.AggregationList percentileFieldValue(String aggregationName, String fieldName, double percent) Single-percentile aggregation on a numeric field. Returns one value viavalues.<percent>in the result. -
groupByDateStartedWithPercentileField
StandardDataQueryBuilder.AggregationList groupByDateStartedWithPercentileField(String aggregationName, String interval, String fieldName, double percent) Date histogram on startTime with a single-percentile sub-aggregation on a numeric field. Generatesdate_histogram > percentilesaggregation. -
groupByNestedFieldFilteredWithSumField
StandardDataQueryBuilder.AggregationList groupByNestedFieldFilteredWithSumField(String aggregationName, String nestedPath, String filterField, String filterValue, String fieldName, int size, String sumFieldName) Terms aggregation on a keyword field inside an ES nested object, restricted by a filter on a sibling field of that nested object, with a sum sub-aggregation on a numeric field within the same nested context. Generatesnested > filter > terms > sumaggregation. -
groupByNestedFieldFilteredWithSumField
StandardDataQueryBuilder.AggregationList groupByNestedFieldFilteredWithSumField(String aggregationName, String nestedPath, String filterField, String filterValue, String fieldName, int size, String sumFieldName, String order) Same asgroupByNestedFieldFilteredWithSumField(String, String, String, String, String, int, String)but with explicit bucket ordering; seegroupByFieldWithSumField(String, String, int, String, String)for acceptedordervalues. -
groupByNestedFieldFilteredWithAvgField
StandardDataQueryBuilder.AggregationList groupByNestedFieldFilteredWithAvgField(String aggregationName, String nestedPath, String filterField, String filterValue, String fieldName, int size, String avgFieldName) Mirror ofgroupByNestedFieldFilteredWithSumField(String, String, String, String, String, int, String)using avg instead of sum. -
groupByNestedFieldFilteredWithAvgField
StandardDataQueryBuilder.AggregationList groupByNestedFieldFilteredWithAvgField(String aggregationName, String nestedPath, String filterField, String filterValue, String fieldName, int size, String avgFieldName, String order) Same asgroupByNestedFieldFilteredWithAvgField(String, String, String, String, String, int, String)but with explicit bucket ordering. -
groupByNestedFieldFilteredWithPercentileField
StandardDataQueryBuilder.AggregationList groupByNestedFieldFilteredWithPercentileField(String aggregationName, String nestedPath, String filterField, String filterValue, String fieldName, int size, String percentileFieldName, double percent) Mirror ofgroupByNestedFieldFilteredWithSumField(String, String, String, String, String, int, String)using a single-percentile sub-aggregation. -
groupByNestedFieldFilteredWithPercentileField
StandardDataQueryBuilder.AggregationList groupByNestedFieldFilteredWithPercentileField(String aggregationName, String nestedPath, String filterField, String filterValue, String fieldName, int size, String percentileFieldName, double percent, String order) Same asgroupByNestedFieldFilteredWithPercentileField(String, String, String, String, String, int, String, double)but with explicit bucket ordering. ForvalueAsc/valueDesc, ordering is on the requested percentile value. -
distributionBusinessStatus
StandardDataQueryBuilder.AggregationList distributionBusinessStatus(String aggregationName, int size) Adds an aggregation that will create a distribution (i.e. buckets) of the possible values of the business status field. E.g. { 'OPEN': 23, 'CLOSED': 12, 'IN_PROGRESS': 3} The results are ordered by value (most occurrences first) -
distributionParentScopeBusinessStatus
StandardDataQueryBuilder.AggregationList distributionParentScopeBusinessStatus(String aggregationName, int size) Adds an aggregation that will create a distribution (i.e. buckets) of the possible values of the parent scope business status field. This is the business status of the directly owning case/process and is available on scopes that are nested under a parent (including tasks, which inherit it from their owning case/process). E.g. { 'OPEN': 23, 'CLOSED': 12, 'IN_PROGRESS': 3} The results are ordered by value (most occurrences first) -
distributionRootScopeBusinessStatus
StandardDataQueryBuilder.AggregationList distributionRootScopeBusinessStatus(String aggregationName, int size) Adds an aggregation that will create a distribution (i.e. buckets) of the possible values of the root scope business status field. This is the business status of the top-level case/process and is available on scopes that are nested under a root (including tasks, which inherit it from their root case/process). E.g. { 'OPEN': 23, 'CLOSED': 12, 'IN_PROGRESS': 3} The results are ordered by value (most occurrences first)
-