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:
Corresponds to SQL:TaskQuery.create().aggregate().sumWorkingTime().avgWorkingTime();
SELECT SUM(WorkingTime) AS SumWorkingTime, AVG(WorkingTime) AS AvgWorkingTime FROM IWA_Task
- API:
- This is a public API.
-
-
Method Summary
All Methods Instance Methods Abstract Methods Modifier and Type Method Description TaskQuery.AggregationQuery
avgBusinessRuntime()
Adds a result columnAvgBusinessRuntime
to the query, that contains the average of the fieldBusinessRuntime
of all (grouped) rows.TaskQuery.AggregationQuery
avgDelayTimestamp()
Adds a result columnAvgDelayTimestamp
to the query, that contains the average of the fieldDelayTimestamp
of all (grouped) rows.TaskQuery.AggregationQuery
avgEndTimestamp()
Adds a result columnAvgEndTimestamp
to the query, that contains the average of the fieldEndTimestamp
of all (grouped) rows.TaskQuery.AggregationQuery
avgExpiryTimestamp()
Adds a result columnAvgExpiryTimestamp
to the query, that contains the average of the fieldExpiryTimestamp
of all (grouped) rows.TaskQuery.AggregationQuery
avgFailedTimeoutTimestamp()
Adds a result columnAvgFailedTimeoutTimestamp
to the query, that contains the average of the fieldFailedTimeoutTimestamp
of all (grouped) rows.TaskQuery.AggregationQuery
avgNumberOfFailures()
Adds a result columnAvgNumberOfFailures
to the query, that contains the average of the fieldNumberOfFailures
of all (grouped) rows.TaskQuery.AggregationQuery
avgNumberOfResumes()
Adds a result columnAvgNumberOfResumes
to the query, that contains the average of the fieldNumberOfResumes
of all (grouped) rows.TaskQuery.AggregationQuery
avgStartTimestamp()
Adds a result columnAvgStartTimestamp
to the query, that contains the average of the fieldStartTimestamp
of all (grouped) rows.TaskQuery.AggregationQuery
avgWorkerSessionId()
Adds a result columnAvgWorkerSessionId
to the query, that contains the average of the fieldWorkerSessionId
of all (grouped) rows.TaskQuery.AggregationQuery
avgWorkingTime()
Adds a result columnAvgWorkingTime
to the query, that contains the average of the fieldWorkingTime
of all (grouped) rows.TaskQuery.AggregationQuery
countRows()
Adds a result columnCount
to the query, that contains the number of (grouped) rows.TaskQuery.ICustomFieldAggregationQuery
customField()
Adds a result custom field to the query.TaskQuery.AggregationQuery
maxActivatorDisplayName()
Adds a result columnMaxActivatorDisplayName
to the query, that contains the maximum value of the fieldActivatorDisplayName
of all (grouped) rows.TaskQuery.AggregationQuery
maxActivatorName()
Adds a result columnMaxActivatorName
to the query, that contains the maximum value of the fieldActivatorName
of all (grouped) rows.TaskQuery.AggregationQuery
maxBusinessCalendar()
Adds a result columnMaxBusinessCalendar
to the query, that contains the maximum value of the fieldBusinessCalendar
of all (grouped) rows.TaskQuery.AggregationQuery
maxBusinessRuntime()
Adds a result columnMaxBusinessRuntime
to the query, that contains the maximum value of the fieldBusinessRuntime
of all (grouped) rows.TaskQuery.AggregationQuery
maxCategory()
Adds a result columnMaxCategory
to the query, that contains the maximum value of the fieldCategory
of all (grouped) rows.TaskQuery.AggregationQuery
maxDelayTimestamp()
Adds a result columnMaxDelayTimestamp
to the query, that contains the maximum value of the fieldDelayTimestamp
of all (grouped) rows.TaskQuery.AggregationQuery
maxDisplayNameTemplate()
Adds a result columnMaxDisplayNameTemplate
to the query, that contains the maximum value of the fieldDisplayNameTemplate
of all (grouped) rows.TaskQuery.AggregationQuery
maxEndTimestamp()
Adds a result columnMaxEndTimestamp
to the query, that contains the maximum value of the fieldEndTimestamp
of all (grouped) rows.TaskQuery.AggregationQuery
maxExpiryActivatorDisplayName()
Adds a result columnMaxExpiryActivatorDisplayName
to the query, that contains the maximum value of the fieldExpiryActivatorDisplayName
of all (grouped) rows.TaskQuery.AggregationQuery
maxExpiryActivatorName()
Adds a result columnMaxExpiryActivatorName
to the query, that contains the maximum value of the fieldExpiryActivatorName
of all (grouped) rows.TaskQuery.AggregationQuery
maxExpiryTaskStartElementPid()
Adds a result columnMaxExpiryTaskStartElementPid
to the query, that contains the maximum value of the fieldExpiryTaskStartElementPid
of all (grouped) rows.TaskQuery.AggregationQuery
maxExpiryTimestamp()
Adds a result columnMaxExpiryTimestamp
to the query, that contains the maximum value of the fieldExpiryTimestamp
of all (grouped) rows.TaskQuery.AggregationQuery
maxFailedTimeoutTimestamp()
Adds a result columnMaxFailedTimeoutTimestamp
to the query, that contains the maximum value of the fieldFailedTimeoutTimestamp
of all (grouped) rows.TaskQuery.AggregationQuery
maxName()
Adds a result columnMaxName
to the query, that contains the maximum value of the fieldName
of all (grouped) rows.TaskQuery.AggregationQuery
maxNumberOfFailures()
Adds a result columnMaxNumberOfFailures
to the query, that contains the maximum value of the fieldNumberOfFailures
of all (grouped) rows.TaskQuery.AggregationQuery
maxNumberOfResumes()
Adds a result columnMaxNumberOfResumes
to the query, that contains the maximum value of the fieldNumberOfResumes
of all (grouped) rows.TaskQuery.AggregationQuery
maxOriginalActivatorDisplayName()
Adds a result columnMaxOriginalActivatorDisplayName
to the query, that contains the maximum value of the fieldOriginalActivatorDisplayName
of all (grouped) rows.TaskQuery.AggregationQuery
maxOriginalActivatorName()
Adds a result columnMaxOriginalActivatorName
to the query, that contains the maximum value of the fieldOriginalActivatorName
of all (grouped) rows.TaskQuery.AggregationQuery
maxRequestPath()
Adds a result columnMaxRequestPath
to the query, that contains the maximum value of the fieldRequestPath
of all (grouped) rows.TaskQuery.AggregationQuery
maxStartTimestamp()
Adds a result columnMaxStartTimestamp
to the query, that contains the maximum value of the fieldStartTimestamp
of all (grouped) rows.TaskQuery.AggregationQuery
maxTaskId()
Adds a result columnMaxTaskId
to the query, that contains the maximum value of the fieldTaskId
of all (grouped) rows.TaskQuery.AggregationQuery
maxWorkerSessionId()
Adds a result columnMaxWorkerSessionId
to the query, that contains the maximum value of the fieldWorkerSessionId
of all (grouped) rows.TaskQuery.AggregationQuery
maxWorkerUserDisplayName()
Adds a result columnMaxWorkerUserDisplayName
to the query, that contains the maximum value of the fieldWorkerUserDisplayName
of all (grouped) rows.TaskQuery.AggregationQuery
maxWorkerUserName()
Adds a result columnMaxWorkerUserName
to the query, that contains the maximum value of the fieldWorkerUserName
of all (grouped) rows.TaskQuery.AggregationQuery
maxWorkingTime()
Adds a result columnMaxWorkingTime
to the query, that contains the maximum value of the fieldWorkingTime
of all (grouped) rows.TaskQuery.AggregationQuery
minActivatorDisplayName()
Adds a result columnMinActivatorDisplayName
to the query, that contains the minimum value of the fieldActivatorDisplayName
of all (grouped) rows.TaskQuery.AggregationQuery
minActivatorName()
Adds a result columnMinActivatorName
to the query, that contains the minimum value of the fieldActivatorName
of all (grouped) rows.TaskQuery.AggregationQuery
minBusinessCalendar()
Adds a result columnMinBusinessCalendar
to the query, that contains the minimum value of the fieldBusinessCalendar
of all (grouped) rows.TaskQuery.AggregationQuery
minBusinessRuntime()
Adds a result columnMinBusinessRuntime
to the query, that contains the minimum value of the fieldBusinessRuntime
of all (grouped) rows.TaskQuery.AggregationQuery
minCategory()
Adds a result columnMinCategory
to the query, that contains the minimum value of the fieldCategory
of all (grouped) rows.TaskQuery.AggregationQuery
minDelayTimestamp()
Adds a result columnMinDelayTimestamp
to the query, that contains the minimum value of the fieldDelayTimestamp
of all (grouped) rows.TaskQuery.AggregationQuery
minDisplayNameTemplate()
Adds a result columnMinDisplayNameTemplate
to the query, that contains the minimum value of the fieldDisplayNameTemplate
of all (grouped) rows.TaskQuery.AggregationQuery
minEndTimestamp()
Adds a result columnMinEndTimestamp
to the query, that contains the minimum value of the fieldEndTimestamp
of all (grouped) rows.TaskQuery.AggregationQuery
minExpiryActivatorDisplayName()
Adds a result columnMinExpiryActivatorDisplayName
to the query, that contains the minimum value of the fieldExpiryActivatorDisplayName
of all (grouped) rows.TaskQuery.AggregationQuery
minExpiryActivatorName()
Adds a result columnMinExpiryActivatorName
to the query, that contains the minimum value of the fieldExpiryActivatorName
of all (grouped) rows.TaskQuery.AggregationQuery
minExpiryTaskStartElementPid()
Adds a result columnMinExpiryTaskStartElementPid
to the query, that contains the minimum value of the fieldExpiryTaskStartElementPid
of all (grouped) rows.TaskQuery.AggregationQuery
minExpiryTimestamp()
Adds a result columnMinExpiryTimestamp
to the query, that contains the minimum value of the fieldExpiryTimestamp
of all (grouped) rows.TaskQuery.AggregationQuery
minFailedTimeoutTimestamp()
Adds a result columnMinFailedTimeoutTimestamp
to the query, that contains the minimum value of the fieldFailedTimeoutTimestamp
of all (grouped) rows.TaskQuery.AggregationQuery
minName()
Adds a result columnMinName
to the query, that contains the minimum value of the fieldName
of all (grouped) rows.TaskQuery.AggregationQuery
minNumberOfFailures()
Adds a result columnMinNumberOfFailures
to the query, that contains the minimum value of the fieldNumberOfFailures
of all (grouped) rows.TaskQuery.AggregationQuery
minNumberOfResumes()
Adds a result columnMinNumberOfResumes
to the query, that contains the minimum value of the fieldNumberOfResumes
of all (grouped) rows.TaskQuery.AggregationQuery
minOriginalActivatorDisplayName()
Adds a result columnMinOriginalActivatorDisplayName
to the query, that contains the minimum value of the fieldOriginalActivatorDisplayName
of all (grouped) rows.TaskQuery.AggregationQuery
minOriginalActivatorName()
Adds a result columnMinOriginalActivatorName
to the query, that contains the minimum value of the fieldOriginalActivatorName
of all (grouped) rows.TaskQuery.AggregationQuery
minRequestPath()
Adds a result columnMinRequestPath
to the query, that contains the minimum value of the fieldRequestPath
of all (grouped) rows.TaskQuery.AggregationQuery
minStartTimestamp()
Adds a result columnMinStartTimestamp
to the query, that contains the minimum value of the fieldStartTimestamp
of all (grouped) rows.TaskQuery.AggregationQuery
minTaskId()
Adds a result columnMinTaskId
to the query, that contains the minimum value of the fieldTaskId
of all (grouped) rows.TaskQuery.AggregationQuery
minWorkerSessionId()
Adds a result columnMinWorkerSessionId
to the query, that contains the minimum value of the fieldWorkerSessionId
of all (grouped) rows.TaskQuery.AggregationQuery
minWorkerUserDisplayName()
Adds a result columnMinWorkerUserDisplayName
to the query, that contains the minimum value of the fieldWorkerUserDisplayName
of all (grouped) rows.TaskQuery.AggregationQuery
minWorkerUserName()
Adds a result columnMinWorkerUserName
to the query, that contains the minimum value of the fieldWorkerUserName
of all (grouped) rows.TaskQuery.AggregationQuery
minWorkingTime()
Adds a result columnMinWorkingTime
to the query, that contains the minimum value of the fieldWorkingTime
of all (grouped) rows.TaskQuery.AggregationQuery
sumBusinessRuntime()
Adds a result columnSumBusinessRuntime
to the query, that contains the sum of the fieldBusinessRuntime
of all (grouped) rows.TaskQuery.AggregationQuery
sumNumberOfFailures()
Adds a result columnSumNumberOfFailures
to the query, that contains the sum of the fieldNumberOfFailures
of all (grouped) rows.TaskQuery.AggregationQuery
sumNumberOfResumes()
Adds a result columnSumNumberOfResumes
to the query, that contains the sum of the fieldNumberOfResumes
of all (grouped) rows.TaskQuery.AggregationQuery
sumWorkerSessionId()
Adds a result columnSumWorkerSessionId
to the query, that contains the sum of the fieldWorkerSessionId
of all (grouped) rows.TaskQuery.AggregationQuery
sumWorkingTime()
Adds a result columnSumWorkingTime
to the query, that contains the sum of the fieldWorkingTime
of all (grouped) rows.
-
-
-
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 fieldTaskId
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 fieldTaskId
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 fieldWorkerUserName
of all (grouped) rows.SQL part:
MIN(WorkerUserName) AS MinWorkerUserName
- 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 fieldWorkerUserName
of all (grouped) rows.SQL part:
MAX(WorkerUserName) AS MaxWorkerUserName
- 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 fieldWorkerUserDisplayName
of all (grouped) rows.SQL part:
MIN(WorkerUserDisplayName) AS MinWorkerUserDisplayName
- 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 fieldWorkerUserDisplayName
of all (grouped) rows.SQL part:
MAX(WorkerUserDisplayName) AS MaxWorkerUserDisplayName
- 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 fieldWorkerSessionId
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 fieldWorkerSessionId
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 fieldWorkerSessionId
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 fieldWorkerSessionId
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 fieldOriginalActivatorName
of all (grouped) rows.SQL part:
MIN(OriginalActivatorName) AS MinOriginalActivatorName
- 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 fieldOriginalActivatorName
of all (grouped) rows.SQL part:
MAX(OriginalActivatorName) AS MaxOriginalActivatorName
- 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 fieldOriginalActivatorDisplayName
of all (grouped) rows.SQL part:
MIN(OriginalActivatorDisplayName) AS MinOriginalActivatorDisplayName
- 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 fieldOriginalActivatorDisplayName
of all (grouped) rows.SQL part:
MAX(OriginalActivatorDisplayName) AS MaxOriginalActivatorDisplayName
- 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 fieldExpiryActivatorName
of all (grouped) rows.SQL part:
MIN(ExpiryActivatorName) AS MinExpiryActivatorName
- 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 fieldExpiryActivatorName
of all (grouped) rows.SQL part:
MAX(ExpiryActivatorName) AS MaxExpiryActivatorName
- 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 fieldExpiryActivatorDisplayName
of all (grouped) rows.SQL part:
MIN(ExpiryActivatorDisplayName) AS MinExpiryActivatorDisplayName
- 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 fieldExpiryActivatorDisplayName
of all (grouped) rows.SQL part:
MAX(ExpiryActivatorDisplayName) AS MaxExpiryActivatorDisplayName
- 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 fieldExpiryTimestamp
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 fieldExpiryTimestamp
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 fieldExpiryTimestamp
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 fieldExpiryTaskStartElementPid
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 fieldExpiryTaskStartElementPid
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 fieldDelayTimestamp
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 fieldDelayTimestamp
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 fieldDelayTimestamp
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 fieldRequestPath
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 fieldRequestPath
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 fieldDisplayNameTemplate
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 fieldDisplayNameTemplate
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 fieldName
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 fieldName
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 fieldStartTimestamp
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 fieldStartTimestamp
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 fieldStartTimestamp
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 fieldEndTimestamp
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 fieldEndTimestamp
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 fieldEndTimestamp
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 fieldBusinessCalendar
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 fieldBusinessCalendar
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 fieldWorkingTime
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 fieldWorkingTime
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 fieldWorkingTime
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 fieldWorkingTime
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 fieldBusinessRuntime
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 fieldBusinessRuntime
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 fieldBusinessRuntime
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 fieldBusinessRuntime
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 fieldFailedTimeoutTimestamp
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 fieldFailedTimeoutTimestamp
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 fieldFailedTimeoutTimestamp
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 fieldNumberOfFailures
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 fieldNumberOfFailures
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 fieldNumberOfFailures
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 fieldNumberOfFailures
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 fieldNumberOfResumes
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 fieldNumberOfResumes
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 fieldNumberOfResumes
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 fieldNumberOfResumes
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 fieldCategory
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 fieldCategory
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 fieldActivatorName
of all (grouped) rows.SQL part:
MIN(ActivatorName) AS MinActivatorName
- 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 fieldActivatorName
of all (grouped) rows.SQL part:
MAX(ActivatorName) AS MaxActivatorName
- 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 fieldActivatorDisplayName
of all (grouped) rows.SQL part:
MIN(ActivatorDisplayName) AS MinActivatorDisplayName
- 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 fieldActivatorDisplayName
of all (grouped) rows.SQL part:
MAX(ActivatorDisplayName) AS MaxActivatorDisplayName
- 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.
-
-