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 Detail

      • 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.