Package ch.ivyteam.ivy.workflow.query

Interface TaskQuery.ICustomFieldAggregationQuery

  • Enclosing class:
    TaskQuery
    public static interface TaskQuery.ICustomFieldAggregationQuery
    Provides aggregation functionality for custom fields of ITask.

    Example: 

    TaskQuery.create().aggregate().customField().sumNumberField("ValuePoints");

    API:
    This is a public API.

    • Method Detail

      • maxStringField

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

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

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

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

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

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

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

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