Package ch.ivyteam.ivy.workflow.query

Class TaskQuery.AggregationQuery

java.lang.Object
ch.ivyteam.ivy.persistence.query.Query<ITask>
ch.ivyteam.ivy.workflow.query.TaskQuery
ch.ivyteam.ivy.workflow.query.TaskQuery.AggregationQuery
All Implemented Interfaces:
TaskQuery.IAggregationQuery
Enclosing class:
TaskQuery
public class TaskQuery.AggregationQuery extends TaskQuery implements TaskQuery.IAggregationQuery
This class 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

      public TaskQuery.AggregationQuery countRows()
      Description copied from interface: TaskQuery.IAggregationQuery

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

      SQL part: COUNT(*) AS Count

      Specified by:
      countRows in interface TaskQuery.IAggregationQuery
      Returns:
      query for further composition
      API:
      This public API is available in IvyScript and Java. It has the visibility EXPERT.

    • minTaskId

      public TaskQuery.AggregationQuery minTaskId()
      Description copied from interface: TaskQuery.IAggregationQuery

      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

      Specified by:
      minTaskId in interface TaskQuery.IAggregationQuery
      Returns:
      query for further composition
      API:
      This public API is available in IvyScript and Java. It has the visibility EXPERT.

    • maxTaskId

      public TaskQuery.AggregationQuery maxTaskId()
      Description copied from interface: TaskQuery.IAggregationQuery

      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

      Specified by:
      maxTaskId in interface TaskQuery.IAggregationQuery
      Returns:
      query for further composition
      API:
      This public API is available in IvyScript and Java. It has the visibility EXPERT.

    • minWorkerUserName

      public TaskQuery.AggregationQuery minWorkerUserName()
      Description copied from interface: TaskQuery.IAggregationQuery

      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.


      Specified by:
      minWorkerUserName in interface TaskQuery.IAggregationQuery
      Returns:
      query for further composition
      API:
      This public API is available in IvyScript and Java. It has the visibility EXPERT.

    • maxWorkerUserName

      public TaskQuery.AggregationQuery maxWorkerUserName()
      Description copied from interface: TaskQuery.IAggregationQuery

      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.


      Specified by:
      maxWorkerUserName in interface TaskQuery.IAggregationQuery
      Returns:
      query for further composition
      API:
      This public API is available in IvyScript and Java. It has the visibility EXPERT.

    • minWorkerUserDisplayName

      public TaskQuery.AggregationQuery minWorkerUserDisplayName()
      Description copied from interface: TaskQuery.IAggregationQuery

      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.


      Specified by:
      minWorkerUserDisplayName in interface TaskQuery.IAggregationQuery
      Returns:
      query for further composition
      API:
      This public API is available in IvyScript and Java. It has the visibility EXPERT.

    • maxWorkerUserDisplayName

      public TaskQuery.AggregationQuery maxWorkerUserDisplayName()
      Description copied from interface: TaskQuery.IAggregationQuery

      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.


      Specified by:
      maxWorkerUserDisplayName in interface TaskQuery.IAggregationQuery
      Returns:
      query for further composition
      API:
      This public API is available in IvyScript and Java. It has the visibility EXPERT.

    • sumWorkerSessionId

      public TaskQuery.AggregationQuery sumWorkerSessionId()
      Description copied from interface: TaskQuery.IAggregationQuery

      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

      Specified by:
      sumWorkerSessionId in interface TaskQuery.IAggregationQuery
      Returns:
      query for further composition
      API:
      This public API is available in IvyScript and Java. It has the visibility EXPERT.

    • avgWorkerSessionId

      public TaskQuery.AggregationQuery avgWorkerSessionId()
      Description copied from interface: TaskQuery.IAggregationQuery

      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

      Specified by:
      avgWorkerSessionId in interface TaskQuery.IAggregationQuery
      Returns:
      query for further composition
      API:
      This public API is available in IvyScript and Java. It has the visibility EXPERT.

    • minWorkerSessionId

      public TaskQuery.AggregationQuery minWorkerSessionId()
      Description copied from interface: TaskQuery.IAggregationQuery

      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

      Specified by:
      minWorkerSessionId in interface TaskQuery.IAggregationQuery
      Returns:
      query for further composition
      API:
      This public API is available in IvyScript and Java. It has the visibility EXPERT.

    • maxWorkerSessionId

      public TaskQuery.AggregationQuery maxWorkerSessionId()
      Description copied from interface: TaskQuery.IAggregationQuery

      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

      Specified by:
      maxWorkerSessionId in interface TaskQuery.IAggregationQuery
      Returns:
      query for further composition
      API:
      This public API is available in IvyScript and Java. It has the visibility EXPERT.

    • minOriginalActivatorName

      public TaskQuery.AggregationQuery minOriginalActivatorName()
      Description copied from interface: TaskQuery.IAggregationQuery

      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.


      Specified by:
      minOriginalActivatorName in interface TaskQuery.IAggregationQuery
      Returns:
      query for further composition
      API:
      This public API is available in IvyScript and Java. It has the visibility EXPERT.

    • maxOriginalActivatorName

      public TaskQuery.AggregationQuery maxOriginalActivatorName()
      Description copied from interface: TaskQuery.IAggregationQuery

      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.


      Specified by:
      maxOriginalActivatorName in interface TaskQuery.IAggregationQuery
      Returns:
      query for further composition
      API:
      This public API is available in IvyScript and Java. It has the visibility EXPERT.

    • minOriginalActivatorDisplayName

      public TaskQuery.AggregationQuery minOriginalActivatorDisplayName()
      Description copied from interface: TaskQuery.IAggregationQuery

      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.


      Specified by:
      minOriginalActivatorDisplayName in interface TaskQuery.IAggregationQuery
      Returns:
      query for further composition
      API:
      This public API is available in IvyScript and Java. It has the visibility EXPERT.

    • maxOriginalActivatorDisplayName

      public TaskQuery.AggregationQuery maxOriginalActivatorDisplayName()
      Description copied from interface: TaskQuery.IAggregationQuery

      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.


      Specified by:
      maxOriginalActivatorDisplayName in interface TaskQuery.IAggregationQuery
      Returns:
      query for further composition
      API:
      This public API is available in IvyScript and Java. It has the visibility EXPERT.

    • minExpiryActivatorName

      public TaskQuery.AggregationQuery minExpiryActivatorName()
      Description copied from interface: TaskQuery.IAggregationQuery

      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.


      Specified by:
      minExpiryActivatorName in interface TaskQuery.IAggregationQuery
      Returns:
      query for further composition
      API:
      This public API is available in IvyScript and Java. It has the visibility EXPERT.

    • maxExpiryActivatorName

      public TaskQuery.AggregationQuery maxExpiryActivatorName()
      Description copied from interface: TaskQuery.IAggregationQuery

      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.


      Specified by:
      maxExpiryActivatorName in interface TaskQuery.IAggregationQuery
      Returns:
      query for further composition
      API:
      This public API is available in IvyScript and Java. It has the visibility EXPERT.

    • minExpiryActivatorDisplayName

      public TaskQuery.AggregationQuery minExpiryActivatorDisplayName()
      Description copied from interface: TaskQuery.IAggregationQuery

      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.


      Specified by:
      minExpiryActivatorDisplayName in interface TaskQuery.IAggregationQuery
      Returns:
      query for further composition
      API:
      This public API is available in IvyScript and Java. It has the visibility EXPERT.

    • maxExpiryActivatorDisplayName

      public TaskQuery.AggregationQuery maxExpiryActivatorDisplayName()
      Description copied from interface: TaskQuery.IAggregationQuery

      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.


      Specified by:
      maxExpiryActivatorDisplayName in interface TaskQuery.IAggregationQuery
      Returns:
      query for further composition
      API:
      This public API is available in IvyScript and Java. It has the visibility EXPERT.

    • avgExpiryTimestamp

      public TaskQuery.AggregationQuery avgExpiryTimestamp()
      Description copied from interface: TaskQuery.IAggregationQuery

      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

      Specified by:
      avgExpiryTimestamp in interface TaskQuery.IAggregationQuery
      Returns:
      query for further composition
      API:
      This public API is available in IvyScript and Java. It has the visibility EXPERT.

    • minExpiryTimestamp

      public TaskQuery.AggregationQuery minExpiryTimestamp()
      Description copied from interface: TaskQuery.IAggregationQuery

      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

      Specified by:
      minExpiryTimestamp in interface TaskQuery.IAggregationQuery
      Returns:
      query for further composition
      API:
      This public API is available in IvyScript and Java. It has the visibility EXPERT.

    • maxExpiryTimestamp

      public TaskQuery.AggregationQuery maxExpiryTimestamp()
      Description copied from interface: TaskQuery.IAggregationQuery

      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

      Specified by:
      maxExpiryTimestamp in interface TaskQuery.IAggregationQuery
      Returns:
      query for further composition
      API:
      This public API is available in IvyScript and Java. It has the visibility EXPERT.

    • minExpiryTaskStartElementPid

      public TaskQuery.AggregationQuery minExpiryTaskStartElementPid()
      Description copied from interface: TaskQuery.IAggregationQuery

      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

      Specified by:
      minExpiryTaskStartElementPid in interface TaskQuery.IAggregationQuery
      Returns:
      query for further composition
      API:
      This public API is available in IvyScript and Java. It has the visibility EXPERT.

    • maxExpiryTaskStartElementPid

      public TaskQuery.AggregationQuery maxExpiryTaskStartElementPid()
      Description copied from interface: TaskQuery.IAggregationQuery

      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

      Specified by:
      maxExpiryTaskStartElementPid in interface TaskQuery.IAggregationQuery
      Returns:
      query for further composition
      API:
      This public API is available in IvyScript and Java. It has the visibility EXPERT.

    • avgDelayTimestamp

      public TaskQuery.AggregationQuery avgDelayTimestamp()
      Description copied from interface: TaskQuery.IAggregationQuery

      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

      Specified by:
      avgDelayTimestamp in interface TaskQuery.IAggregationQuery
      Returns:
      query for further composition
      API:
      This public API is available in IvyScript and Java. It has the visibility EXPERT.

    • minDelayTimestamp

      public TaskQuery.AggregationQuery minDelayTimestamp()
      Description copied from interface: TaskQuery.IAggregationQuery

      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

      Specified by:
      minDelayTimestamp in interface TaskQuery.IAggregationQuery
      Returns:
      query for further composition
      API:
      This public API is available in IvyScript and Java. It has the visibility EXPERT.

    • maxDelayTimestamp

      public TaskQuery.AggregationQuery maxDelayTimestamp()
      Description copied from interface: TaskQuery.IAggregationQuery

      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

      Specified by:
      maxDelayTimestamp in interface TaskQuery.IAggregationQuery
      Returns:
      query for further composition
      API:
      This public API is available in IvyScript and Java. It has the visibility EXPERT.

    • minRequestPath

      public TaskQuery.AggregationQuery minRequestPath()
      Description copied from interface: TaskQuery.IAggregationQuery

      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

      Specified by:
      minRequestPath in interface TaskQuery.IAggregationQuery
      Returns:
      query for further composition
      API:
      This public API is available in IvyScript and Java. It has the visibility EXPERT.

    • maxRequestPath

      public TaskQuery.AggregationQuery maxRequestPath()
      Description copied from interface: TaskQuery.IAggregationQuery

      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

      Specified by:
      maxRequestPath in interface TaskQuery.IAggregationQuery
      Returns:
      query for further composition
      API:
      This public API is available in IvyScript and Java. It has the visibility EXPERT.

    • minName

      public TaskQuery.AggregationQuery minName()
      Description copied from interface: TaskQuery.IAggregationQuery

      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.


      Specified by:
      minName in interface TaskQuery.IAggregationQuery
      Returns:
      query for further composition
      API:
      This public API is available in IvyScript and Java. It has the visibility EXPERT.

    • maxName

      public TaskQuery.AggregationQuery maxName()
      Description copied from interface: TaskQuery.IAggregationQuery

      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.


      Specified by:
      maxName in interface TaskQuery.IAggregationQuery
      Returns:
      query for further composition
      API:
      This public API is available in IvyScript and Java. It has the visibility EXPERT.

    • avgStartTimestamp

      public TaskQuery.AggregationQuery avgStartTimestamp()
      Description copied from interface: TaskQuery.IAggregationQuery

      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

      Specified by:
      avgStartTimestamp in interface TaskQuery.IAggregationQuery
      Returns:
      query for further composition
      API:
      This public API is available in IvyScript and Java. It has the visibility EXPERT.

    • minStartTimestamp

      public TaskQuery.AggregationQuery minStartTimestamp()
      Description copied from interface: TaskQuery.IAggregationQuery

      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

      Specified by:
      minStartTimestamp in interface TaskQuery.IAggregationQuery
      Returns:
      query for further composition
      API:
      This public API is available in IvyScript and Java. It has the visibility EXPERT.

    • maxStartTimestamp

      public TaskQuery.AggregationQuery maxStartTimestamp()
      Description copied from interface: TaskQuery.IAggregationQuery

      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

      Specified by:
      maxStartTimestamp in interface TaskQuery.IAggregationQuery
      Returns:
      query for further composition
      API:
      This public API is available in IvyScript and Java. It has the visibility EXPERT.

    • avgEndTimestamp

      public TaskQuery.AggregationQuery avgEndTimestamp()
      Description copied from interface: TaskQuery.IAggregationQuery

      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

      Specified by:
      avgEndTimestamp in interface TaskQuery.IAggregationQuery
      Returns:
      query for further composition
      API:
      This public API is available in IvyScript and Java. It has the visibility EXPERT.

    • minEndTimestamp

      public TaskQuery.AggregationQuery minEndTimestamp()
      Description copied from interface: TaskQuery.IAggregationQuery

      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

      Specified by:
      minEndTimestamp in interface TaskQuery.IAggregationQuery
      Returns:
      query for further composition
      API:
      This public API is available in IvyScript and Java. It has the visibility EXPERT.

    • maxEndTimestamp

      public TaskQuery.AggregationQuery maxEndTimestamp()
      Description copied from interface: TaskQuery.IAggregationQuery

      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

      Specified by:
      maxEndTimestamp in interface TaskQuery.IAggregationQuery
      Returns:
      query for further composition
      API:
      This public API is available in IvyScript and Java. It has the visibility EXPERT.

    • minBusinessCalendar

      public TaskQuery.AggregationQuery minBusinessCalendar()
      Description copied from interface: TaskQuery.IAggregationQuery

      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

      Specified by:
      minBusinessCalendar in interface TaskQuery.IAggregationQuery
      Returns:
      query for further composition
      API:
      This public API is available in IvyScript and Java. It has the visibility EXPERT.

    • maxBusinessCalendar

      public TaskQuery.AggregationQuery maxBusinessCalendar()
      Description copied from interface: TaskQuery.IAggregationQuery

      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

      Specified by:
      maxBusinessCalendar in interface TaskQuery.IAggregationQuery
      Returns:
      query for further composition
      API:
      This public API is available in IvyScript and Java. It has the visibility EXPERT.

    • sumWorkingTime

      public TaskQuery.AggregationQuery sumWorkingTime()
      Description copied from interface: TaskQuery.IAggregationQuery

      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

      Specified by:
      sumWorkingTime in interface TaskQuery.IAggregationQuery
      Returns:
      query for further composition
      API:
      This public API is available in IvyScript and Java. It has the visibility EXPERT.

    • avgWorkingTime

      public TaskQuery.AggregationQuery avgWorkingTime()
      Description copied from interface: TaskQuery.IAggregationQuery

      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

      Specified by:
      avgWorkingTime in interface TaskQuery.IAggregationQuery
      Returns:
      query for further composition
      API:
      This public API is available in IvyScript and Java. It has the visibility EXPERT.

    • minWorkingTime

      public TaskQuery.AggregationQuery minWorkingTime()
      Description copied from interface: TaskQuery.IAggregationQuery

      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

      Specified by:
      minWorkingTime in interface TaskQuery.IAggregationQuery
      Returns:
      query for further composition
      API:
      This public API is available in IvyScript and Java. It has the visibility EXPERT.

    • maxWorkingTime

      public TaskQuery.AggregationQuery maxWorkingTime()
      Description copied from interface: TaskQuery.IAggregationQuery

      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

      Specified by:
      maxWorkingTime in interface TaskQuery.IAggregationQuery
      Returns:
      query for further composition
      API:
      This public API is available in IvyScript and Java. It has the visibility EXPERT.

    • sumBusinessRuntime

      public TaskQuery.AggregationQuery sumBusinessRuntime()
      Description copied from interface: TaskQuery.IAggregationQuery

      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

      Specified by:
      sumBusinessRuntime in interface TaskQuery.IAggregationQuery
      Returns:
      query for further composition
      API:
      This public API is available in IvyScript and Java. It has the visibility EXPERT.

    • avgBusinessRuntime

      public TaskQuery.AggregationQuery avgBusinessRuntime()
      Description copied from interface: TaskQuery.IAggregationQuery

      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

      Specified by:
      avgBusinessRuntime in interface TaskQuery.IAggregationQuery
      Returns:
      query for further composition
      API:
      This public API is available in IvyScript and Java. It has the visibility EXPERT.

    • minBusinessRuntime

      public TaskQuery.AggregationQuery minBusinessRuntime()
      Description copied from interface: TaskQuery.IAggregationQuery

      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

      Specified by:
      minBusinessRuntime in interface TaskQuery.IAggregationQuery
      Returns:
      query for further composition
      API:
      This public API is available in IvyScript and Java. It has the visibility EXPERT.

    • maxBusinessRuntime

      public TaskQuery.AggregationQuery maxBusinessRuntime()
      Description copied from interface: TaskQuery.IAggregationQuery

      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

      Specified by:
      maxBusinessRuntime in interface TaskQuery.IAggregationQuery
      Returns:
      query for further composition
      API:
      This public API is available in IvyScript and Java. It has the visibility EXPERT.

    • avgFailedTimeoutTimestamp

      public TaskQuery.AggregationQuery avgFailedTimeoutTimestamp()
      Description copied from interface: TaskQuery.IAggregationQuery

      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

      Specified by:
      avgFailedTimeoutTimestamp in interface TaskQuery.IAggregationQuery
      Returns:
      query for further composition
      API:
      This public API is available in IvyScript and Java. It has the visibility EXPERT.

    • minFailedTimeoutTimestamp

      public TaskQuery.AggregationQuery minFailedTimeoutTimestamp()
      Description copied from interface: TaskQuery.IAggregationQuery

      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

      Specified by:
      minFailedTimeoutTimestamp in interface TaskQuery.IAggregationQuery
      Returns:
      query for further composition
      API:
      This public API is available in IvyScript and Java. It has the visibility EXPERT.

    • maxFailedTimeoutTimestamp

      public TaskQuery.AggregationQuery maxFailedTimeoutTimestamp()
      Description copied from interface: TaskQuery.IAggregationQuery

      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

      Specified by:
      maxFailedTimeoutTimestamp in interface TaskQuery.IAggregationQuery
      Returns:
      query for further composition
      API:
      This public API is available in IvyScript and Java. It has the visibility EXPERT.

    • sumNumberOfFailures

      public TaskQuery.AggregationQuery sumNumberOfFailures()
      Description copied from interface: TaskQuery.IAggregationQuery

      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

      Specified by:
      sumNumberOfFailures in interface TaskQuery.IAggregationQuery
      Returns:
      query for further composition
      API:
      This public API is available in IvyScript and Java. It has the visibility EXPERT.

    • avgNumberOfFailures

      public TaskQuery.AggregationQuery avgNumberOfFailures()
      Description copied from interface: TaskQuery.IAggregationQuery

      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

      Specified by:
      avgNumberOfFailures in interface TaskQuery.IAggregationQuery
      Returns:
      query for further composition
      API:
      This public API is available in IvyScript and Java. It has the visibility EXPERT.

    • minNumberOfFailures

      public TaskQuery.AggregationQuery minNumberOfFailures()
      Description copied from interface: TaskQuery.IAggregationQuery

      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

      Specified by:
      minNumberOfFailures in interface TaskQuery.IAggregationQuery
      Returns:
      query for further composition
      API:
      This public API is available in IvyScript and Java. It has the visibility EXPERT.

    • maxNumberOfFailures

      public TaskQuery.AggregationQuery maxNumberOfFailures()
      Description copied from interface: TaskQuery.IAggregationQuery

      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

      Specified by:
      maxNumberOfFailures in interface TaskQuery.IAggregationQuery
      Returns:
      query for further composition
      API:
      This public API is available in IvyScript and Java. It has the visibility EXPERT.

    • sumNumberOfResumes

      public TaskQuery.AggregationQuery sumNumberOfResumes()
      Description copied from interface: TaskQuery.IAggregationQuery

      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

      Specified by:
      sumNumberOfResumes in interface TaskQuery.IAggregationQuery
      Returns:
      query for further composition
      API:
      This public API is available in IvyScript and Java. It has the visibility EXPERT.

    • avgNumberOfResumes

      public TaskQuery.AggregationQuery avgNumberOfResumes()
      Description copied from interface: TaskQuery.IAggregationQuery

      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

      Specified by:
      avgNumberOfResumes in interface TaskQuery.IAggregationQuery
      Returns:
      query for further composition
      API:
      This public API is available in IvyScript and Java. It has the visibility EXPERT.

    • minNumberOfResumes

      public TaskQuery.AggregationQuery minNumberOfResumes()
      Description copied from interface: TaskQuery.IAggregationQuery

      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

      Specified by:
      minNumberOfResumes in interface TaskQuery.IAggregationQuery
      Returns:
      query for further composition
      API:
      This public API is available in IvyScript and Java. It has the visibility EXPERT.

    • maxNumberOfResumes

      public TaskQuery.AggregationQuery maxNumberOfResumes()
      Description copied from interface: TaskQuery.IAggregationQuery

      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

      Specified by:
      maxNumberOfResumes in interface TaskQuery.IAggregationQuery
      Returns:
      query for further composition
      API:
      This public API is available in IvyScript and Java. It has the visibility EXPERT.

    • minCategory

      public TaskQuery.AggregationQuery minCategory()
      Description copied from interface: TaskQuery.IAggregationQuery

      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

      Specified by:
      minCategory in interface TaskQuery.IAggregationQuery
      Returns:
      query for further composition
      API:
      This public API is available in IvyScript and Java. It has the visibility EXPERT.

    • maxCategory

      public TaskQuery.AggregationQuery maxCategory()
      Description copied from interface: TaskQuery.IAggregationQuery

      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

      Specified by:
      maxCategory in interface TaskQuery.IAggregationQuery
      Returns:
      query for further composition
      API:
      This public API is available in IvyScript and Java. It has the visibility EXPERT.

    • minActivatorName

      public TaskQuery.AggregationQuery minActivatorName()
      Description copied from interface: TaskQuery.IAggregationQuery

      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.


      Specified by:
      minActivatorName in interface TaskQuery.IAggregationQuery
      Returns:
      query for further composition
      API:
      This public API is available in IvyScript and Java. It has the visibility EXPERT.

    • maxActivatorName

      public TaskQuery.AggregationQuery maxActivatorName()
      Description copied from interface: TaskQuery.IAggregationQuery

      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.


      Specified by:
      maxActivatorName in interface TaskQuery.IAggregationQuery
      Returns:
      query for further composition
      API:
      This public API is available in IvyScript and Java. It has the visibility EXPERT.

    • minActivatorDisplayName

      public TaskQuery.AggregationQuery minActivatorDisplayName()
      Description copied from interface: TaskQuery.IAggregationQuery

      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.


      Specified by:
      minActivatorDisplayName in interface TaskQuery.IAggregationQuery
      Returns:
      query for further composition
      API:
      This public API is available in IvyScript and Java. It has the visibility EXPERT.

    • maxActivatorDisplayName

      public TaskQuery.AggregationQuery maxActivatorDisplayName()
      Description copied from interface: TaskQuery.IAggregationQuery

      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.


      Specified by:
      maxActivatorDisplayName in interface TaskQuery.IAggregationQuery
      Returns:
      query for further composition
      API:
      This public API is available in IvyScript and Java. It has the visibility EXPERT.

    • customField

      public TaskQuery.ICustomFieldAggregationQuery customField()
      Description copied from interface: TaskQuery.IAggregationQuery

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

      Specified by:
      customField in interface TaskQuery.IAggregationQuery
      Returns:
      query for further composition
      API:
      This public API is available in IvyScript and Java. It has the visibility EXPERT.