Package ch.ivyteam.ivy.workflow.query

Interface CaseQuery.ICustomFieldAggregationQuery

Enclosing class:

CaseQuery

public static interface CaseQuery.ICustomFieldAggregationQuery

Provides aggregation functionality for custom fields of ICase.

Example:

CaseQuery.businessCases().aggregate().customField().sumNumberField("ValuePoints");

API:

This is a public API.

Method Summary

Modifier and Type	Method	Description
CaseQuery.AggregationQuery	avgNumberField(String fieldName)	Adds a result custom Number field column Avg[fieldName] to the query that contains the average of the custom Number field with name fieldName of all (grouped) rows.
CaseQuery.AggregationQuery	avgTimestampField(String fieldName)	Adds a result custom Timestamp field column Avg[fieldName] to the query that contains the average of the custom Timestamp field with name fieldName of all (grouped) rows.
CaseQuery.AggregationQuery	maxNumberField(String fieldName)	Adds a result custom Number field column Max[fieldName] to the query that contains the maximum value of the custom Number field with name fieldName of all (grouped) rows.
CaseQuery.AggregationQuery	maxStringField(String fieldName)	Adds a result custom String field column Max[fieldName] to the query that contains the maximum value of the custom String field with name fieldName of all (grouped) rows.
CaseQuery.AggregationQuery	maxTimestampField(String fieldName)	Adds a result custom Timestamp field column Max[fieldName] to the query that contains the maximum value of the custom Timestamp field with name fieldName of all (grouped) rows.
CaseQuery.AggregationQuery	minNumberField(String fieldName)	Adds a result custom Number field column Min[fieldName] to the query that contains the minimum value of the custom Number field with name fieldName of all (grouped) rows.
CaseQuery.AggregationQuery	sumNumberField(String fieldName)	Adds a result custom Number field column Sum[fieldName] to the query that contains the sum of the custom Number field with name fieldName of all (grouped) rows.
CaseQuery.AggregationQuery	sumTimestampField(String fieldName)	Adds a result custom Timestamp field column Sum[fieldName] to the query that contains the sum of the custom Timestamp field with name fieldName of all (grouped) rows.

Method Details

maxStringField

CaseQuery.AggregationQuery maxStringField(String fieldName)

Adds a result custom String field column Max[fieldName] to the query that contains the maximum value of the custom String field with name fieldName of all (grouped) rows.

Parameters:

fieldName - Name of the custom String field.

Returns:

Query for further composition.

API:

This public API is available in IvyScript and Java. It has the visibility EXPERT.

minNumberField

CaseQuery.AggregationQuery minNumberField(String fieldName)

Adds a result custom Number field column Min[fieldName] to the query that contains the minimum value of the custom Number field with name fieldName of all (grouped) rows.

Parameters:

fieldName - Name of the custom Number field.

Returns:

Query for further composition.

API:

This public API is available in IvyScript and Java. It has the visibility EXPERT.

maxNumberField

CaseQuery.AggregationQuery maxNumberField(String fieldName)

Adds a result custom Number field column Max[fieldName] to the query that contains the maximum value of the custom Number field with name fieldName of all (grouped) rows.

Parameters:

fieldName - Name of the custom Number field.

Returns:

Query for further composition.

API:

This public API is available in IvyScript and Java. It has the visibility EXPERT.

avgNumberField

CaseQuery.AggregationQuery avgNumberField(String fieldName)

Adds a result custom Number field column Avg[fieldName] to the query that contains the average of the custom Number field with name fieldName of all (grouped) rows.

Parameters:

fieldName - Name of the custom Number field.

Returns:

Query for further composition.

API:

This public API is available in IvyScript and Java. It has the visibility EXPERT.

sumNumberField

CaseQuery.AggregationQuery sumNumberField(String fieldName)

Adds a result custom Number field column Sum[fieldName] to the query that contains the sum of the custom Number field with name fieldName of all (grouped) rows.

Parameters:

fieldName - Name of the custom Number field.

Returns:

Query for further composition.

API:

This public API is available in IvyScript and Java. It has the visibility EXPERT.

maxTimestampField

CaseQuery.AggregationQuery maxTimestampField(String fieldName)

Adds a result custom Timestamp field column Max[fieldName] to the query that contains the maximum value of the custom Timestamp field with name fieldName of all (grouped) rows.

Parameters:

fieldName - Name of the custom Timestamp field.

Returns:

Query for further composition.

API:

This public API is available in IvyScript and Java. It has the visibility EXPERT.

avgTimestampField

CaseQuery.AggregationQuery avgTimestampField(String fieldName)

Adds a result custom Timestamp field column Avg[fieldName] to the query that contains the average of the custom Timestamp field with name fieldName of all (grouped) rows.

Parameters:

fieldName - Name of the custom Timestamp field.

Returns:

Query for further composition.

API:

This public API is available in IvyScript and Java. It has the visibility EXPERT.

sumTimestampField

CaseQuery.AggregationQuery sumTimestampField(String fieldName)

Adds a result custom Timestamp field column Sum[fieldName] to the query that contains the sum of the custom Timestamp field with name fieldName of all (grouped) rows.

Parameters:

fieldName - Name of the custom Timestamp field.

Returns:

Query for further composition.

API:

This public API is available in IvyScript and Java. It has the visibility EXPERT.