Package ch.ivyteam.ivy.workflow.query

Interface TaskQuery.IAggregationQuery

  • All Known Implementing Classes:
    TaskQuery.AggregationQuery
    Enclosing class:
    TaskQuery
    public static interface TaskQuery.IAggregationQuery
    Provides methods to perform aggregations on the query. For each aggregation a column is added to the result set.

    Example: 

    TaskQuery.create().aggregate().sumWorkingTime().avgWorkingTime();
    Corresponds to SQL: 
    SELECT SUM(WorkingTime) AS SumWorkingTime, AVG(WorkingTime) AS AvgWorkingTime FROM IWA_Task

    API:
    This is a public API.

    • Method Detail

      • countRows

        TaskQuery.AggregationQuery countRows()

        Adds a result column Count to the query, that contains the number of (grouped) rows.

        SQL part: COUNT(*) AS Count

        Returns:
        query for further composition
        API:
        This public API is available in IvyScript and Java. It has the visibility EXPERT.

      • minTaskId

        TaskQuery.AggregationQuery minTaskId()

        Adds a result column MinTaskId to the query, that contains the minimum value of the field TaskId of all (grouped) rows.

        SQL part: MIN(TaskId) AS MinTaskId

        Returns:
        query for further composition
        API:
        This public API is available in IvyScript and Java. It has the visibility EXPERT.

      • maxTaskId

        TaskQuery.AggregationQuery maxTaskId()

        Adds a result column MaxTaskId to the query, that contains the maximum value of the field TaskId of all (grouped) rows.

        SQL part: MAX(TaskId) AS MaxTaskId

        Returns:
        query for further composition
        API:
        This public API is available in IvyScript and Java. It has the visibility EXPERT.

      • minWorkerUserName

        TaskQuery.AggregationQuery minWorkerUserName()

        Adds a result column MinWorkerUserName to the query, that contains the minimum value of the field WorkerUserName of all (grouped) rows.

        SQL part: MIN(WorkerUserName) AS MinWorkerUserName

        This is a virtual column. It contains the same value as the column Name of the referenced Worker.


        Returns:
        query for further composition
        API:
        This public API is available in IvyScript and Java. It has the visibility EXPERT.

      • maxWorkerUserName

        TaskQuery.AggregationQuery maxWorkerUserName()

        Adds a result column MaxWorkerUserName to the query, that contains the maximum value of the field WorkerUserName of all (grouped) rows.

        SQL part: MAX(WorkerUserName) AS MaxWorkerUserName

        This is a virtual column. It contains the same value as the column Name of the referenced Worker.


        Returns:
        query for further composition
        API:
        This public API is available in IvyScript and Java. It has the visibility EXPERT.

      • minWorkerUserDisplayName

        TaskQuery.AggregationQuery minWorkerUserDisplayName()

        Adds a result column MinWorkerUserDisplayName to the query, that contains the minimum value of the field WorkerUserDisplayName of all (grouped) rows.

        SQL part: MIN(WorkerUserDisplayName) AS MinWorkerUserDisplayName

        This is a virtual column. It contains the same value as the column DisplayName of the referenced Worker.


        Returns:
        query for further composition
        API:
        This public API is available in IvyScript and Java. It has the visibility EXPERT.

      • maxWorkerUserDisplayName

        TaskQuery.AggregationQuery maxWorkerUserDisplayName()

        Adds a result column MaxWorkerUserDisplayName to the query, that contains the maximum value of the field WorkerUserDisplayName of all (grouped) rows.

        SQL part: MAX(WorkerUserDisplayName) AS MaxWorkerUserDisplayName

        This is a virtual column. It contains the same value as the column DisplayName of the referenced Worker.


        Returns:
        query for further composition
        API:
        This public API is available in IvyScript and Java. It has the visibility EXPERT.

      • sumWorkerSessionId

        TaskQuery.AggregationQuery sumWorkerSessionId()

        Adds a result column SumWorkerSessionId to the query, that contains the sum of the field WorkerSessionId of all (grouped) rows.

        SQL part: SUM(WorkerSessionId) AS SumWorkerSessionId

        Returns:
        query for further composition
        API:
        This public API is available in IvyScript and Java. It has the visibility EXPERT.

      • avgWorkerSessionId

        TaskQuery.AggregationQuery avgWorkerSessionId()

        Adds a result column AvgWorkerSessionId to the query, that contains the average of the field WorkerSessionId of all (grouped) rows.

        SQL part: AVG(WorkerSessionId) AS AvgWorkerSessionId

        Returns:
        query for further composition
        API:
        This public API is available in IvyScript and Java. It has the visibility EXPERT.

      • minWorkerSessionId

        TaskQuery.AggregationQuery minWorkerSessionId()

        Adds a result column MinWorkerSessionId to the query, that contains the minimum value of the field WorkerSessionId of all (grouped) rows.

        SQL part: MIN(WorkerSessionId) AS MinWorkerSessionId

        Returns:
        query for further composition
        API:
        This public API is available in IvyScript and Java. It has the visibility EXPERT.

      • maxWorkerSessionId

        TaskQuery.AggregationQuery maxWorkerSessionId()

        Adds a result column MaxWorkerSessionId to the query, that contains the maximum value of the field WorkerSessionId of all (grouped) rows.

        SQL part: MAX(WorkerSessionId) AS MaxWorkerSessionId

        Returns:
        query for further composition
        API:
        This public API is available in IvyScript and Java. It has the visibility EXPERT.

      • minOriginalActivatorName

        TaskQuery.AggregationQuery minOriginalActivatorName()

        Adds a result column MinOriginalActivatorName to the query, that contains the minimum value of the field OriginalActivatorName of all (grouped) rows.

        SQL part: MIN(OriginalActivatorName) AS MinOriginalActivatorName

        This is a virtual column. It contains the same value as the column MemberName of the referenced OriginalActivator.


        Returns:
        query for further composition
        API:
        This public API is available in IvyScript and Java. It has the visibility EXPERT.

      • maxOriginalActivatorName

        TaskQuery.AggregationQuery maxOriginalActivatorName()

        Adds a result column MaxOriginalActivatorName to the query, that contains the maximum value of the field OriginalActivatorName of all (grouped) rows.

        SQL part: MAX(OriginalActivatorName) AS MaxOriginalActivatorName

        This is a virtual column. It contains the same value as the column MemberName of the referenced OriginalActivator.


        Returns:
        query for further composition
        API:
        This public API is available in IvyScript and Java. It has the visibility EXPERT.

      • minOriginalActivatorDisplayName

        TaskQuery.AggregationQuery minOriginalActivatorDisplayName()

        Adds a result column MinOriginalActivatorDisplayName to the query, that contains the minimum value of the field OriginalActivatorDisplayName of all (grouped) rows.

        SQL part: MIN(OriginalActivatorDisplayName) AS MinOriginalActivatorDisplayName

        This is a virtual column. It contains the same value as the column DisplayName of the referenced OriginalActivator.


        Returns:
        query for further composition
        API:
        This public API is available in IvyScript and Java. It has the visibility EXPERT.

      • maxOriginalActivatorDisplayName

        TaskQuery.AggregationQuery maxOriginalActivatorDisplayName()

        Adds a result column MaxOriginalActivatorDisplayName to the query, that contains the maximum value of the field OriginalActivatorDisplayName of all (grouped) rows.

        SQL part: MAX(OriginalActivatorDisplayName) AS MaxOriginalActivatorDisplayName

        This is a virtual column. It contains the same value as the column DisplayName of the referenced OriginalActivator.


        Returns:
        query for further composition
        API:
        This public API is available in IvyScript and Java. It has the visibility EXPERT.

      • minExpiryActivatorName

        TaskQuery.AggregationQuery minExpiryActivatorName()

        Adds a result column MinExpiryActivatorName to the query, that contains the minimum value of the field ExpiryActivatorName of all (grouped) rows.

        SQL part: MIN(ExpiryActivatorName) AS MinExpiryActivatorName

        This is a virtual column. It contains the same value as the column MemberName of the referenced ExpiryActivator.


        Returns:
        query for further composition
        API:
        This public API is available in IvyScript and Java. It has the visibility EXPERT.

      • maxExpiryActivatorName

        TaskQuery.AggregationQuery maxExpiryActivatorName()

        Adds a result column MaxExpiryActivatorName to the query, that contains the maximum value of the field ExpiryActivatorName of all (grouped) rows.

        SQL part: MAX(ExpiryActivatorName) AS MaxExpiryActivatorName

        This is a virtual column. It contains the same value as the column MemberName of the referenced ExpiryActivator.


        Returns:
        query for further composition
        API:
        This public API is available in IvyScript and Java. It has the visibility EXPERT.

      • minExpiryActivatorDisplayName

        TaskQuery.AggregationQuery minExpiryActivatorDisplayName()

        Adds a result column MinExpiryActivatorDisplayName to the query, that contains the minimum value of the field ExpiryActivatorDisplayName of all (grouped) rows.

        SQL part: MIN(ExpiryActivatorDisplayName) AS MinExpiryActivatorDisplayName

        This is a virtual column. It contains the same value as the column DisplayName of the referenced ExpiryActivator.


        Returns:
        query for further composition
        API:
        This public API is available in IvyScript and Java. It has the visibility EXPERT.

      • maxExpiryActivatorDisplayName

        TaskQuery.AggregationQuery maxExpiryActivatorDisplayName()

        Adds a result column MaxExpiryActivatorDisplayName to the query, that contains the maximum value of the field ExpiryActivatorDisplayName of all (grouped) rows.

        SQL part: MAX(ExpiryActivatorDisplayName) AS MaxExpiryActivatorDisplayName

        This is a virtual column. It contains the same value as the column DisplayName of the referenced ExpiryActivator.


        Returns:
        query for further composition
        API:
        This public API is available in IvyScript and Java. It has the visibility EXPERT.

      • avgExpiryTimestamp

        TaskQuery.AggregationQuery avgExpiryTimestamp()

        Adds a result column AvgExpiryTimestamp to the query, that contains the average of the field ExpiryTimestamp of all (grouped) rows.

        SQL part: AVG(ExpiryTimestamp) AS AvgExpiryTimestamp

        Returns:
        query for further composition
        API:
        This public API is available in IvyScript and Java. It has the visibility EXPERT.

      • minExpiryTimestamp

        TaskQuery.AggregationQuery minExpiryTimestamp()

        Adds a result column MinExpiryTimestamp to the query, that contains the minimum value of the field ExpiryTimestamp of all (grouped) rows.

        SQL part: MIN(ExpiryTimestamp) AS MinExpiryTimestamp

        Returns:
        query for further composition
        API:
        This public API is available in IvyScript and Java. It has the visibility EXPERT.

      • maxExpiryTimestamp

        TaskQuery.AggregationQuery maxExpiryTimestamp()

        Adds a result column MaxExpiryTimestamp to the query, that contains the maximum value of the field ExpiryTimestamp of all (grouped) rows.

        SQL part: MAX(ExpiryTimestamp) AS MaxExpiryTimestamp

        Returns:
        query for further composition
        API:
        This public API is available in IvyScript and Java. It has the visibility EXPERT.

      • minExpiryTaskStartElementPid

        TaskQuery.AggregationQuery minExpiryTaskStartElementPid()

        Adds a result column MinExpiryTaskStartElementPid to the query, that contains the minimum value of the field ExpiryTaskStartElementPid of all (grouped) rows.

        SQL part: MIN(ExpiryTaskStartElementPid) AS MinExpiryTaskStartElementPid

        Returns:
        query for further composition
        API:
        This public API is available in IvyScript and Java. It has the visibility EXPERT.

      • maxExpiryTaskStartElementPid

        TaskQuery.AggregationQuery maxExpiryTaskStartElementPid()

        Adds a result column MaxExpiryTaskStartElementPid to the query, that contains the maximum value of the field ExpiryTaskStartElementPid of all (grouped) rows.

        SQL part: MAX(ExpiryTaskStartElementPid) AS MaxExpiryTaskStartElementPid

        Returns:
        query for further composition
        API:
        This public API is available in IvyScript and Java. It has the visibility EXPERT.

      • avgDelayTimestamp

        TaskQuery.AggregationQuery avgDelayTimestamp()

        Adds a result column AvgDelayTimestamp to the query, that contains the average of the field DelayTimestamp of all (grouped) rows.

        SQL part: AVG(DelayTimestamp) AS AvgDelayTimestamp

        Returns:
        query for further composition
        API:
        This public API is available in IvyScript and Java. It has the visibility EXPERT.

      • minDelayTimestamp

        TaskQuery.AggregationQuery minDelayTimestamp()

        Adds a result column MinDelayTimestamp to the query, that contains the minimum value of the field DelayTimestamp of all (grouped) rows.

        SQL part: MIN(DelayTimestamp) AS MinDelayTimestamp

        Returns:
        query for further composition
        API:
        This public API is available in IvyScript and Java. It has the visibility EXPERT.

      • maxDelayTimestamp

        TaskQuery.AggregationQuery maxDelayTimestamp()

        Adds a result column MaxDelayTimestamp to the query, that contains the maximum value of the field DelayTimestamp of all (grouped) rows.

        SQL part: MAX(DelayTimestamp) AS MaxDelayTimestamp

        Returns:
        query for further composition
        API:
        This public API is available in IvyScript and Java. It has the visibility EXPERT.

      • minRequestPath

        TaskQuery.AggregationQuery minRequestPath()

        Adds a result column MinRequestPath to the query, that contains the minimum value of the field RequestPath of all (grouped) rows.

        SQL part: MIN(RequestPath) AS MinRequestPath

        Returns:
        query for further composition
        API:
        This public API is available in IvyScript and Java. It has the visibility EXPERT.

      • maxRequestPath

        TaskQuery.AggregationQuery maxRequestPath()

        Adds a result column MaxRequestPath to the query, that contains the maximum value of the field RequestPath of all (grouped) rows.

        SQL part: MAX(RequestPath) AS MaxRequestPath

        Returns:
        query for further composition
        API:
        This public API is available in IvyScript and Java. It has the visibility EXPERT.

      • minDisplayNameTemplate

        TaskQuery.AggregationQuery minDisplayNameTemplate()

        Adds a result column MinDisplayNameTemplate to the query, that contains the minimum value of the field DisplayNameTemplate of all (grouped) rows.

        SQL part: MIN(DisplayNameTemplate) AS MinDisplayNameTemplate

        Returns:
        query for further composition
        API:
        This public API is available in IvyScript and Java. It has the visibility EXPERT.

      • maxDisplayNameTemplate

        TaskQuery.AggregationQuery maxDisplayNameTemplate()

        Adds a result column MaxDisplayNameTemplate to the query, that contains the maximum value of the field DisplayNameTemplate of all (grouped) rows.

        SQL part: MAX(DisplayNameTemplate) AS MaxDisplayNameTemplate

        Returns:
        query for further composition
        API:
        This public API is available in IvyScript and Java. It has the visibility EXPERT.

      • minName

        TaskQuery.AggregationQuery minName()

        Adds a result column MinName to the query, that contains the minimum value of the field Name of all (grouped) rows.

        SQL part: MIN(Name) AS MinName

        Returns:
        query for further composition
        API:
        This public API is available in IvyScript and Java. It has the visibility EXPERT.

      • maxName

        TaskQuery.AggregationQuery maxName()

        Adds a result column MaxName to the query, that contains the maximum value of the field Name of all (grouped) rows.

        SQL part: MAX(Name) AS MaxName

        Returns:
        query for further composition
        API:
        This public API is available in IvyScript and Java. It has the visibility EXPERT.

      • avgStartTimestamp

        TaskQuery.AggregationQuery avgStartTimestamp()

        Adds a result column AvgStartTimestamp to the query, that contains the average of the field StartTimestamp of all (grouped) rows.

        SQL part: AVG(StartTimestamp) AS AvgStartTimestamp

        Returns:
        query for further composition
        API:
        This public API is available in IvyScript and Java. It has the visibility EXPERT.

      • minStartTimestamp

        TaskQuery.AggregationQuery minStartTimestamp()

        Adds a result column MinStartTimestamp to the query, that contains the minimum value of the field StartTimestamp of all (grouped) rows.

        SQL part: MIN(StartTimestamp) AS MinStartTimestamp

        Returns:
        query for further composition
        API:
        This public API is available in IvyScript and Java. It has the visibility EXPERT.

      • maxStartTimestamp

        TaskQuery.AggregationQuery maxStartTimestamp()

        Adds a result column MaxStartTimestamp to the query, that contains the maximum value of the field StartTimestamp of all (grouped) rows.

        SQL part: MAX(StartTimestamp) AS MaxStartTimestamp

        Returns:
        query for further composition
        API:
        This public API is available in IvyScript and Java. It has the visibility EXPERT.

      • avgEndTimestamp

        TaskQuery.AggregationQuery avgEndTimestamp()

        Adds a result column AvgEndTimestamp to the query, that contains the average of the field EndTimestamp of all (grouped) rows.

        SQL part: AVG(EndTimestamp) AS AvgEndTimestamp

        Returns:
        query for further composition
        API:
        This public API is available in IvyScript and Java. It has the visibility EXPERT.

      • minEndTimestamp

        TaskQuery.AggregationQuery minEndTimestamp()

        Adds a result column MinEndTimestamp to the query, that contains the minimum value of the field EndTimestamp of all (grouped) rows.

        SQL part: MIN(EndTimestamp) AS MinEndTimestamp

        Returns:
        query for further composition
        API:
        This public API is available in IvyScript and Java. It has the visibility EXPERT.

      • maxEndTimestamp

        TaskQuery.AggregationQuery maxEndTimestamp()

        Adds a result column MaxEndTimestamp to the query, that contains the maximum value of the field EndTimestamp of all (grouped) rows.

        SQL part: MAX(EndTimestamp) AS MaxEndTimestamp

        Returns:
        query for further composition
        API:
        This public API is available in IvyScript and Java. It has the visibility EXPERT.

      • minBusinessCalendar

        TaskQuery.AggregationQuery minBusinessCalendar()

        Adds a result column MinBusinessCalendar to the query, that contains the minimum value of the field BusinessCalendar of all (grouped) rows.

        SQL part: MIN(BusinessCalendar) AS MinBusinessCalendar

        Returns:
        query for further composition
        API:
        This public API is available in IvyScript and Java. It has the visibility EXPERT.

      • maxBusinessCalendar

        TaskQuery.AggregationQuery maxBusinessCalendar()

        Adds a result column MaxBusinessCalendar to the query, that contains the maximum value of the field BusinessCalendar of all (grouped) rows.

        SQL part: MAX(BusinessCalendar) AS MaxBusinessCalendar

        Returns:
        query for further composition
        API:
        This public API is available in IvyScript and Java. It has the visibility EXPERT.

      • sumWorkingTime

        TaskQuery.AggregationQuery sumWorkingTime()

        Adds a result column SumWorkingTime to the query, that contains the sum of the field WorkingTime of all (grouped) rows.

        SQL part: SUM(WorkingTime) AS SumWorkingTime

        Returns:
        query for further composition
        API:
        This public API is available in IvyScript and Java. It has the visibility EXPERT.

      • avgWorkingTime

        TaskQuery.AggregationQuery avgWorkingTime()

        Adds a result column AvgWorkingTime to the query, that contains the average of the field WorkingTime of all (grouped) rows.

        SQL part: AVG(WorkingTime) AS AvgWorkingTime

        Returns:
        query for further composition
        API:
        This public API is available in IvyScript and Java. It has the visibility EXPERT.

      • minWorkingTime

        TaskQuery.AggregationQuery minWorkingTime()

        Adds a result column MinWorkingTime to the query, that contains the minimum value of the field WorkingTime of all (grouped) rows.

        SQL part: MIN(WorkingTime) AS MinWorkingTime

        Returns:
        query for further composition
        API:
        This public API is available in IvyScript and Java. It has the visibility EXPERT.

      • maxWorkingTime

        TaskQuery.AggregationQuery maxWorkingTime()

        Adds a result column MaxWorkingTime to the query, that contains the maximum value of the field WorkingTime of all (grouped) rows.

        SQL part: MAX(WorkingTime) AS MaxWorkingTime

        Returns:
        query for further composition
        API:
        This public API is available in IvyScript and Java. It has the visibility EXPERT.

      • sumBusinessRuntime

        TaskQuery.AggregationQuery sumBusinessRuntime()

        Adds a result column SumBusinessRuntime to the query, that contains the sum of the field BusinessRuntime of all (grouped) rows.

        SQL part: SUM(BusinessRuntime) AS SumBusinessRuntime

        Returns:
        query for further composition
        API:
        This public API is available in IvyScript and Java. It has the visibility EXPERT.

      • avgBusinessRuntime

        TaskQuery.AggregationQuery avgBusinessRuntime()

        Adds a result column AvgBusinessRuntime to the query, that contains the average of the field BusinessRuntime of all (grouped) rows.

        SQL part: AVG(BusinessRuntime) AS AvgBusinessRuntime

        Returns:
        query for further composition
        API:
        This public API is available in IvyScript and Java. It has the visibility EXPERT.

      • minBusinessRuntime

        TaskQuery.AggregationQuery minBusinessRuntime()

        Adds a result column MinBusinessRuntime to the query, that contains the minimum value of the field BusinessRuntime of all (grouped) rows.

        SQL part: MIN(BusinessRuntime) AS MinBusinessRuntime

        Returns:
        query for further composition
        API:
        This public API is available in IvyScript and Java. It has the visibility EXPERT.

      • maxBusinessRuntime

        TaskQuery.AggregationQuery maxBusinessRuntime()

        Adds a result column MaxBusinessRuntime to the query, that contains the maximum value of the field BusinessRuntime of all (grouped) rows.

        SQL part: MAX(BusinessRuntime) AS MaxBusinessRuntime

        Returns:
        query for further composition
        API:
        This public API is available in IvyScript and Java. It has the visibility EXPERT.

      • avgFailedTimeoutTimestamp

        TaskQuery.AggregationQuery avgFailedTimeoutTimestamp()

        Adds a result column AvgFailedTimeoutTimestamp to the query, that contains the average of the field FailedTimeoutTimestamp of all (grouped) rows.

        SQL part: AVG(FailedTimeoutTimestamp) AS AvgFailedTimeoutTimestamp

        Returns:
        query for further composition
        API:
        This public API is available in IvyScript and Java. It has the visibility EXPERT.

      • minFailedTimeoutTimestamp

        TaskQuery.AggregationQuery minFailedTimeoutTimestamp()

        Adds a result column MinFailedTimeoutTimestamp to the query, that contains the minimum value of the field FailedTimeoutTimestamp of all (grouped) rows.

        SQL part: MIN(FailedTimeoutTimestamp) AS MinFailedTimeoutTimestamp

        Returns:
        query for further composition
        API:
        This public API is available in IvyScript and Java. It has the visibility EXPERT.

      • maxFailedTimeoutTimestamp

        TaskQuery.AggregationQuery maxFailedTimeoutTimestamp()

        Adds a result column MaxFailedTimeoutTimestamp to the query, that contains the maximum value of the field FailedTimeoutTimestamp of all (grouped) rows.

        SQL part: MAX(FailedTimeoutTimestamp) AS MaxFailedTimeoutTimestamp

        Returns:
        query for further composition
        API:
        This public API is available in IvyScript and Java. It has the visibility EXPERT.

      • sumNumberOfFailures

        TaskQuery.AggregationQuery sumNumberOfFailures()

        Adds a result column SumNumberOfFailures to the query, that contains the sum of the field NumberOfFailures of all (grouped) rows.

        SQL part: SUM(NumberOfFailures) AS SumNumberOfFailures

        Returns:
        query for further composition
        API:
        This public API is available in IvyScript and Java. It has the visibility EXPERT.

      • avgNumberOfFailures

        TaskQuery.AggregationQuery avgNumberOfFailures()

        Adds a result column AvgNumberOfFailures to the query, that contains the average of the field NumberOfFailures of all (grouped) rows.

        SQL part: AVG(NumberOfFailures) AS AvgNumberOfFailures

        Returns:
        query for further composition
        API:
        This public API is available in IvyScript and Java. It has the visibility EXPERT.

      • minNumberOfFailures

        TaskQuery.AggregationQuery minNumberOfFailures()

        Adds a result column MinNumberOfFailures to the query, that contains the minimum value of the field NumberOfFailures of all (grouped) rows.

        SQL part: MIN(NumberOfFailures) AS MinNumberOfFailures

        Returns:
        query for further composition
        API:
        This public API is available in IvyScript and Java. It has the visibility EXPERT.

      • maxNumberOfFailures

        TaskQuery.AggregationQuery maxNumberOfFailures()

        Adds a result column MaxNumberOfFailures to the query, that contains the maximum value of the field NumberOfFailures of all (grouped) rows.

        SQL part: MAX(NumberOfFailures) AS MaxNumberOfFailures

        Returns:
        query for further composition
        API:
        This public API is available in IvyScript and Java. It has the visibility EXPERT.

      • sumNumberOfResumes

        TaskQuery.AggregationQuery sumNumberOfResumes()

        Adds a result column SumNumberOfResumes to the query, that contains the sum of the field NumberOfResumes of all (grouped) rows.

        SQL part: SUM(NumberOfResumes) AS SumNumberOfResumes

        Returns:
        query for further composition
        API:
        This public API is available in IvyScript and Java. It has the visibility EXPERT.

      • avgNumberOfResumes

        TaskQuery.AggregationQuery avgNumberOfResumes()

        Adds a result column AvgNumberOfResumes to the query, that contains the average of the field NumberOfResumes of all (grouped) rows.

        SQL part: AVG(NumberOfResumes) AS AvgNumberOfResumes

        Returns:
        query for further composition
        API:
        This public API is available in IvyScript and Java. It has the visibility EXPERT.

      • minNumberOfResumes

        TaskQuery.AggregationQuery minNumberOfResumes()

        Adds a result column MinNumberOfResumes to the query, that contains the minimum value of the field NumberOfResumes of all (grouped) rows.

        SQL part: MIN(NumberOfResumes) AS MinNumberOfResumes

        Returns:
        query for further composition
        API:
        This public API is available in IvyScript and Java. It has the visibility EXPERT.

      • maxNumberOfResumes

        TaskQuery.AggregationQuery maxNumberOfResumes()

        Adds a result column MaxNumberOfResumes to the query, that contains the maximum value of the field NumberOfResumes of all (grouped) rows.

        SQL part: MAX(NumberOfResumes) AS MaxNumberOfResumes

        Returns:
        query for further composition
        API:
        This public API is available in IvyScript and Java. It has the visibility EXPERT.

      • minCategory

        TaskQuery.AggregationQuery minCategory()

        Adds a result column MinCategory to the query, that contains the minimum value of the field Category of all (grouped) rows.

        SQL part: MIN(Category) AS MinCategory

        Returns:
        query for further composition
        API:
        This public API is available in IvyScript and Java. It has the visibility EXPERT.

      • maxCategory

        TaskQuery.AggregationQuery maxCategory()

        Adds a result column MaxCategory to the query, that contains the maximum value of the field Category of all (grouped) rows.

        SQL part: MAX(Category) AS MaxCategory

        Returns:
        query for further composition
        API:
        This public API is available in IvyScript and Java. It has the visibility EXPERT.

      • minActivatorName

        TaskQuery.AggregationQuery minActivatorName()

        Adds a result column MinActivatorName to the query, that contains the minimum value of the field ActivatorName of all (grouped) rows.

        SQL part: MIN(ActivatorName) AS MinActivatorName

        This is a virtual column. It contains the same value as the column MemberName of the referenced Activator.


        Returns:
        query for further composition
        API:
        This public API is available in IvyScript and Java. It has the visibility EXPERT.

      • maxActivatorName

        TaskQuery.AggregationQuery maxActivatorName()

        Adds a result column MaxActivatorName to the query, that contains the maximum value of the field ActivatorName of all (grouped) rows.

        SQL part: MAX(ActivatorName) AS MaxActivatorName

        This is a virtual column. It contains the same value as the column MemberName of the referenced Activator.


        Returns:
        query for further composition
        API:
        This public API is available in IvyScript and Java. It has the visibility EXPERT.

      • minActivatorDisplayName

        TaskQuery.AggregationQuery minActivatorDisplayName()

        Adds a result column MinActivatorDisplayName to the query, that contains the minimum value of the field ActivatorDisplayName of all (grouped) rows.

        SQL part: MIN(ActivatorDisplayName) AS MinActivatorDisplayName

        This is a virtual column. It contains the same value as the column DisplayName of the referenced Activator.


        Returns:
        query for further composition
        API:
        This public API is available in IvyScript and Java. It has the visibility EXPERT.

      • maxActivatorDisplayName

        TaskQuery.AggregationQuery maxActivatorDisplayName()

        Adds a result column MaxActivatorDisplayName to the query, that contains the maximum value of the field ActivatorDisplayName of all (grouped) rows.

        SQL part: MAX(ActivatorDisplayName) AS MaxActivatorDisplayName

        This is a virtual column. It contains the same value as the column DisplayName of the referenced Activator.


        Returns:
        query for further composition
        API:
        This public API is available in IvyScript and Java. It has the visibility EXPERT.

      • customField

        TaskQuery.ICustomFieldAggregationQuery customField()

        Adds a result custom field to the query. Type and name are specified during further query composition.

        Returns:
        query for further composition
        API:
        This public API is available in IvyScript and Java. It has the visibility EXPERT.