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 Details

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

    • 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

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


      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

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


      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.