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 static 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:
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.
-
-
Nested Class Summary
-
Nested classes/interfaces inherited from class ch.ivyteam.ivy.workflow.query.TaskQuery
TaskQuery.AggregationQuery, TaskQuery.FilterLink, TaskQuery.FilterQuery, TaskQuery.GroupByQuery, TaskQuery.IAggregationQuery, TaskQuery.IBooleanColumnFilterQuery, TaskQuery.IBoolFilterQuery, TaskQuery.IClobColumnFilterQuery, TaskQuery.IColumnFilterQuery, TaskQuery.ICustomFieldAggregationQuery, TaskQuery.ICustomFieldFilterQuery, TaskQuery.ICustomFieldGroupBy, TaskQuery.ICustomFieldOrderBy, TaskQuery.IDateColumnFilterQuery, TaskQuery.IFilterableColumns, TaskQuery.IFilterLink, TaskQuery.IFilterQuery, TaskQuery.IGroupByQueryColumns, TaskQuery.IIntegerColumnFilterQuery, TaskQuery.INumberColumnFilterQuery, TaskQuery.IOrderByQueryColumns, TaskQuery.IPatternColumnFilterQuery, TaskQuery.IStringColumnFilterQuery, TaskQuery.ITaskStateFilterQuery, TaskQuery.IWorkflowPriorityFilterQuery, TaskQuery.OrderByColumnQuery, TaskQuery.OrderByQuery
-
-
Method Summary
All Methods Instance Methods Concrete 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
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 interfaceTaskQuery.IAggregationQuery
- Returns:
- query for further composition
- See Also:
TaskQuery.IAggregationQuery.countRows()
- 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 fieldTaskId
of all (grouped) rows.SQL part:
MIN(TaskId) AS MinTaskId
- Specified by:
minTaskId
in interfaceTaskQuery.IAggregationQuery
- Returns:
- query for further composition
- See Also:
TaskQuery.IAggregationQuery.minTaskId()
- 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 fieldTaskId
of all (grouped) rows.SQL part:
MAX(TaskId) AS MaxTaskId
- Specified by:
maxTaskId
in interfaceTaskQuery.IAggregationQuery
- Returns:
- query for further composition
- See Also:
TaskQuery.IAggregationQuery.maxTaskId()
- 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 fieldWorkerUserName
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 referencedWorker
.- Specified by:
minWorkerUserName
in interfaceTaskQuery.IAggregationQuery
- Returns:
- query for further composition
- See Also:
TaskQuery.IAggregationQuery.minWorkerUserName()
- 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 fieldWorkerUserName
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 referencedWorker
.- Specified by:
maxWorkerUserName
in interfaceTaskQuery.IAggregationQuery
- Returns:
- query for further composition
- See Also:
TaskQuery.IAggregationQuery.maxWorkerUserName()
- 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 fieldWorkerUserDisplayName
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 referencedWorker
.- Specified by:
minWorkerUserDisplayName
in interfaceTaskQuery.IAggregationQuery
- Returns:
- query for further composition
- See Also:
TaskQuery.IAggregationQuery.minWorkerUserDisplayName()
- 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 fieldWorkerUserDisplayName
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 referencedWorker
.- Specified by:
maxWorkerUserDisplayName
in interfaceTaskQuery.IAggregationQuery
- Returns:
- query for further composition
- See Also:
TaskQuery.IAggregationQuery.maxWorkerUserDisplayName()
- 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 fieldWorkerSessionId
of all (grouped) rows.SQL part:
SUM(WorkerSessionId) AS SumWorkerSessionId
- Specified by:
sumWorkerSessionId
in interfaceTaskQuery.IAggregationQuery
- Returns:
- query for further composition
- See Also:
TaskQuery.IAggregationQuery.sumWorkerSessionId()
- 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 fieldWorkerSessionId
of all (grouped) rows.SQL part:
AVG(WorkerSessionId) AS AvgWorkerSessionId
- Specified by:
avgWorkerSessionId
in interfaceTaskQuery.IAggregationQuery
- Returns:
- query for further composition
- See Also:
TaskQuery.IAggregationQuery.avgWorkerSessionId()
- 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 fieldWorkerSessionId
of all (grouped) rows.SQL part:
MIN(WorkerSessionId) AS MinWorkerSessionId
- Specified by:
minWorkerSessionId
in interfaceTaskQuery.IAggregationQuery
- Returns:
- query for further composition
- See Also:
TaskQuery.IAggregationQuery.minWorkerSessionId()
- 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 fieldWorkerSessionId
of all (grouped) rows.SQL part:
MAX(WorkerSessionId) AS MaxWorkerSessionId
- Specified by:
maxWorkerSessionId
in interfaceTaskQuery.IAggregationQuery
- Returns:
- query for further composition
- See Also:
TaskQuery.IAggregationQuery.maxWorkerSessionId()
- 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 fieldOriginalActivatorName
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 referencedOriginalActivator
.- Specified by:
minOriginalActivatorName
in interfaceTaskQuery.IAggregationQuery
- Returns:
- query for further composition
- See Also:
TaskQuery.IAggregationQuery.minOriginalActivatorName()
- 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 fieldOriginalActivatorName
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 referencedOriginalActivator
.- Specified by:
maxOriginalActivatorName
in interfaceTaskQuery.IAggregationQuery
- Returns:
- query for further composition
- See Also:
TaskQuery.IAggregationQuery.maxOriginalActivatorName()
- 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 fieldOriginalActivatorDisplayName
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 referencedOriginalActivator
.- Specified by:
minOriginalActivatorDisplayName
in interfaceTaskQuery.IAggregationQuery
- Returns:
- query for further composition
- See Also:
TaskQuery.IAggregationQuery.minOriginalActivatorDisplayName()
- 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 fieldOriginalActivatorDisplayName
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 referencedOriginalActivator
.- Specified by:
maxOriginalActivatorDisplayName
in interfaceTaskQuery.IAggregationQuery
- Returns:
- query for further composition
- See Also:
TaskQuery.IAggregationQuery.maxOriginalActivatorDisplayName()
- 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 fieldExpiryActivatorName
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 referencedExpiryActivator
.- Specified by:
minExpiryActivatorName
in interfaceTaskQuery.IAggregationQuery
- Returns:
- query for further composition
- See Also:
TaskQuery.IAggregationQuery.minExpiryActivatorName()
- 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 fieldExpiryActivatorName
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 referencedExpiryActivator
.- Specified by:
maxExpiryActivatorName
in interfaceTaskQuery.IAggregationQuery
- Returns:
- query for further composition
- See Also:
TaskQuery.IAggregationQuery.maxExpiryActivatorName()
- 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 fieldExpiryActivatorDisplayName
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 referencedExpiryActivator
.- Specified by:
minExpiryActivatorDisplayName
in interfaceTaskQuery.IAggregationQuery
- Returns:
- query for further composition
- See Also:
TaskQuery.IAggregationQuery.minExpiryActivatorDisplayName()
- 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 fieldExpiryActivatorDisplayName
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 referencedExpiryActivator
.- Specified by:
maxExpiryActivatorDisplayName
in interfaceTaskQuery.IAggregationQuery
- Returns:
- query for further composition
- See Also:
TaskQuery.IAggregationQuery.maxExpiryActivatorDisplayName()
- 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 fieldExpiryTimestamp
of all (grouped) rows.SQL part:
AVG(ExpiryTimestamp) AS AvgExpiryTimestamp
- Specified by:
avgExpiryTimestamp
in interfaceTaskQuery.IAggregationQuery
- Returns:
- query for further composition
- See Also:
TaskQuery.IAggregationQuery.avgExpiryTimestamp()
- 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 fieldExpiryTimestamp
of all (grouped) rows.SQL part:
MIN(ExpiryTimestamp) AS MinExpiryTimestamp
- Specified by:
minExpiryTimestamp
in interfaceTaskQuery.IAggregationQuery
- Returns:
- query for further composition
- See Also:
TaskQuery.IAggregationQuery.minExpiryTimestamp()
- 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 fieldExpiryTimestamp
of all (grouped) rows.SQL part:
MAX(ExpiryTimestamp) AS MaxExpiryTimestamp
- Specified by:
maxExpiryTimestamp
in interfaceTaskQuery.IAggregationQuery
- Returns:
- query for further composition
- See Also:
TaskQuery.IAggregationQuery.maxExpiryTimestamp()
- 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 fieldExpiryTaskStartElementPid
of all (grouped) rows.SQL part:
MIN(ExpiryTaskStartElementPid) AS MinExpiryTaskStartElementPid
- Specified by:
minExpiryTaskStartElementPid
in interfaceTaskQuery.IAggregationQuery
- Returns:
- query for further composition
- See Also:
TaskQuery.IAggregationQuery.minExpiryTaskStartElementPid()
- 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 fieldExpiryTaskStartElementPid
of all (grouped) rows.SQL part:
MAX(ExpiryTaskStartElementPid) AS MaxExpiryTaskStartElementPid
- Specified by:
maxExpiryTaskStartElementPid
in interfaceTaskQuery.IAggregationQuery
- Returns:
- query for further composition
- See Also:
TaskQuery.IAggregationQuery.maxExpiryTaskStartElementPid()
- 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 fieldDelayTimestamp
of all (grouped) rows.SQL part:
AVG(DelayTimestamp) AS AvgDelayTimestamp
- Specified by:
avgDelayTimestamp
in interfaceTaskQuery.IAggregationQuery
- Returns:
- query for further composition
- See Also:
TaskQuery.IAggregationQuery.avgDelayTimestamp()
- 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 fieldDelayTimestamp
of all (grouped) rows.SQL part:
MIN(DelayTimestamp) AS MinDelayTimestamp
- Specified by:
minDelayTimestamp
in interfaceTaskQuery.IAggregationQuery
- Returns:
- query for further composition
- See Also:
TaskQuery.IAggregationQuery.minDelayTimestamp()
- 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 fieldDelayTimestamp
of all (grouped) rows.SQL part:
MAX(DelayTimestamp) AS MaxDelayTimestamp
- Specified by:
maxDelayTimestamp
in interfaceTaskQuery.IAggregationQuery
- Returns:
- query for further composition
- See Also:
TaskQuery.IAggregationQuery.maxDelayTimestamp()
- 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 fieldRequestPath
of all (grouped) rows.SQL part:
MIN(RequestPath) AS MinRequestPath
- Specified by:
minRequestPath
in interfaceTaskQuery.IAggregationQuery
- Returns:
- query for further composition
- See Also:
TaskQuery.IAggregationQuery.minRequestPath()
- 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 fieldRequestPath
of all (grouped) rows.SQL part:
MAX(RequestPath) AS MaxRequestPath
- Specified by:
maxRequestPath
in interfaceTaskQuery.IAggregationQuery
- Returns:
- query for further composition
- See Also:
TaskQuery.IAggregationQuery.maxRequestPath()
- API:
- This public API is available in IvyScript and Java. It has the visibility EXPERT.
-
minDisplayNameTemplate
public TaskQuery.AggregationQuery minDisplayNameTemplate()
Description copied from interface:TaskQuery.IAggregationQuery
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
- Specified by:
minDisplayNameTemplate
in interfaceTaskQuery.IAggregationQuery
- Returns:
- query for further composition
- See Also:
TaskQuery.IAggregationQuery.minDisplayNameTemplate()
- API:
- This public API is available in IvyScript and Java. It has the visibility EXPERT.
-
maxDisplayNameTemplate
public TaskQuery.AggregationQuery maxDisplayNameTemplate()
Description copied from interface:TaskQuery.IAggregationQuery
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
- Specified by:
maxDisplayNameTemplate
in interfaceTaskQuery.IAggregationQuery
- Returns:
- query for further composition
- See Also:
TaskQuery.IAggregationQuery.maxDisplayNameTemplate()
- 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 fieldName
of all (grouped) rows.SQL part:
MIN(Name) AS MinName
- Specified by:
minName
in interfaceTaskQuery.IAggregationQuery
- Returns:
- query for further composition
- See Also:
TaskQuery.IAggregationQuery.minName()
- 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 fieldName
of all (grouped) rows.SQL part:
MAX(Name) AS MaxName
- Specified by:
maxName
in interfaceTaskQuery.IAggregationQuery
- Returns:
- query for further composition
- See Also:
TaskQuery.IAggregationQuery.maxName()
- 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 fieldStartTimestamp
of all (grouped) rows.SQL part:
AVG(StartTimestamp) AS AvgStartTimestamp
- Specified by:
avgStartTimestamp
in interfaceTaskQuery.IAggregationQuery
- Returns:
- query for further composition
- See Also:
TaskQuery.IAggregationQuery.avgStartTimestamp()
- 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 fieldStartTimestamp
of all (grouped) rows.SQL part:
MIN(StartTimestamp) AS MinStartTimestamp
- Specified by:
minStartTimestamp
in interfaceTaskQuery.IAggregationQuery
- Returns:
- query for further composition
- See Also:
TaskQuery.IAggregationQuery.minStartTimestamp()
- 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 fieldStartTimestamp
of all (grouped) rows.SQL part:
MAX(StartTimestamp) AS MaxStartTimestamp
- Specified by:
maxStartTimestamp
in interfaceTaskQuery.IAggregationQuery
- Returns:
- query for further composition
- See Also:
TaskQuery.IAggregationQuery.maxStartTimestamp()
- 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 fieldEndTimestamp
of all (grouped) rows.SQL part:
AVG(EndTimestamp) AS AvgEndTimestamp
- Specified by:
avgEndTimestamp
in interfaceTaskQuery.IAggregationQuery
- Returns:
- query for further composition
- See Also:
TaskQuery.IAggregationQuery.avgEndTimestamp()
- 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 fieldEndTimestamp
of all (grouped) rows.SQL part:
MIN(EndTimestamp) AS MinEndTimestamp
- Specified by:
minEndTimestamp
in interfaceTaskQuery.IAggregationQuery
- Returns:
- query for further composition
- See Also:
TaskQuery.IAggregationQuery.minEndTimestamp()
- 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 fieldEndTimestamp
of all (grouped) rows.SQL part:
MAX(EndTimestamp) AS MaxEndTimestamp
- Specified by:
maxEndTimestamp
in interfaceTaskQuery.IAggregationQuery
- Returns:
- query for further composition
- See Also:
TaskQuery.IAggregationQuery.maxEndTimestamp()
- 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 fieldBusinessCalendar
of all (grouped) rows.SQL part:
MIN(BusinessCalendar) AS MinBusinessCalendar
- Specified by:
minBusinessCalendar
in interfaceTaskQuery.IAggregationQuery
- Returns:
- query for further composition
- See Also:
TaskQuery.IAggregationQuery.minBusinessCalendar()
- 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 fieldBusinessCalendar
of all (grouped) rows.SQL part:
MAX(BusinessCalendar) AS MaxBusinessCalendar
- Specified by:
maxBusinessCalendar
in interfaceTaskQuery.IAggregationQuery
- Returns:
- query for further composition
- See Also:
TaskQuery.IAggregationQuery.maxBusinessCalendar()
- 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 fieldWorkingTime
of all (grouped) rows.SQL part:
SUM(WorkingTime) AS SumWorkingTime
- Specified by:
sumWorkingTime
in interfaceTaskQuery.IAggregationQuery
- Returns:
- query for further composition
- See Also:
TaskQuery.IAggregationQuery.sumWorkingTime()
- 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 fieldWorkingTime
of all (grouped) rows.SQL part:
AVG(WorkingTime) AS AvgWorkingTime
- Specified by:
avgWorkingTime
in interfaceTaskQuery.IAggregationQuery
- Returns:
- query for further composition
- See Also:
TaskQuery.IAggregationQuery.avgWorkingTime()
- 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 fieldWorkingTime
of all (grouped) rows.SQL part:
MIN(WorkingTime) AS MinWorkingTime
- Specified by:
minWorkingTime
in interfaceTaskQuery.IAggregationQuery
- Returns:
- query for further composition
- See Also:
TaskQuery.IAggregationQuery.minWorkingTime()
- 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 fieldWorkingTime
of all (grouped) rows.SQL part:
MAX(WorkingTime) AS MaxWorkingTime
- Specified by:
maxWorkingTime
in interfaceTaskQuery.IAggregationQuery
- Returns:
- query for further composition
- See Also:
TaskQuery.IAggregationQuery.maxWorkingTime()
- 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 fieldBusinessRuntime
of all (grouped) rows.SQL part:
SUM(BusinessRuntime) AS SumBusinessRuntime
- Specified by:
sumBusinessRuntime
in interfaceTaskQuery.IAggregationQuery
- Returns:
- query for further composition
- See Also:
TaskQuery.IAggregationQuery.sumBusinessRuntime()
- 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 fieldBusinessRuntime
of all (grouped) rows.SQL part:
AVG(BusinessRuntime) AS AvgBusinessRuntime
- Specified by:
avgBusinessRuntime
in interfaceTaskQuery.IAggregationQuery
- Returns:
- query for further composition
- See Also:
TaskQuery.IAggregationQuery.avgBusinessRuntime()
- 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 fieldBusinessRuntime
of all (grouped) rows.SQL part:
MIN(BusinessRuntime) AS MinBusinessRuntime
- Specified by:
minBusinessRuntime
in interfaceTaskQuery.IAggregationQuery
- Returns:
- query for further composition
- See Also:
TaskQuery.IAggregationQuery.minBusinessRuntime()
- 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 fieldBusinessRuntime
of all (grouped) rows.SQL part:
MAX(BusinessRuntime) AS MaxBusinessRuntime
- Specified by:
maxBusinessRuntime
in interfaceTaskQuery.IAggregationQuery
- Returns:
- query for further composition
- See Also:
TaskQuery.IAggregationQuery.maxBusinessRuntime()
- 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 fieldFailedTimeoutTimestamp
of all (grouped) rows.SQL part:
AVG(FailedTimeoutTimestamp) AS AvgFailedTimeoutTimestamp
- Specified by:
avgFailedTimeoutTimestamp
in interfaceTaskQuery.IAggregationQuery
- Returns:
- query for further composition
- See Also:
TaskQuery.IAggregationQuery.avgFailedTimeoutTimestamp()
- 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 fieldFailedTimeoutTimestamp
of all (grouped) rows.SQL part:
MIN(FailedTimeoutTimestamp) AS MinFailedTimeoutTimestamp
- Specified by:
minFailedTimeoutTimestamp
in interfaceTaskQuery.IAggregationQuery
- Returns:
- query for further composition
- See Also:
TaskQuery.IAggregationQuery.minFailedTimeoutTimestamp()
- 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 fieldFailedTimeoutTimestamp
of all (grouped) rows.SQL part:
MAX(FailedTimeoutTimestamp) AS MaxFailedTimeoutTimestamp
- Specified by:
maxFailedTimeoutTimestamp
in interfaceTaskQuery.IAggregationQuery
- Returns:
- query for further composition
- See Also:
TaskQuery.IAggregationQuery.maxFailedTimeoutTimestamp()
- 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 fieldNumberOfFailures
of all (grouped) rows.SQL part:
SUM(NumberOfFailures) AS SumNumberOfFailures
- Specified by:
sumNumberOfFailures
in interfaceTaskQuery.IAggregationQuery
- Returns:
- query for further composition
- See Also:
TaskQuery.IAggregationQuery.sumNumberOfFailures()
- 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 fieldNumberOfFailures
of all (grouped) rows.SQL part:
AVG(NumberOfFailures) AS AvgNumberOfFailures
- Specified by:
avgNumberOfFailures
in interfaceTaskQuery.IAggregationQuery
- Returns:
- query for further composition
- See Also:
TaskQuery.IAggregationQuery.avgNumberOfFailures()
- 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 fieldNumberOfFailures
of all (grouped) rows.SQL part:
MIN(NumberOfFailures) AS MinNumberOfFailures
- Specified by:
minNumberOfFailures
in interfaceTaskQuery.IAggregationQuery
- Returns:
- query for further composition
- See Also:
TaskQuery.IAggregationQuery.minNumberOfFailures()
- 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 fieldNumberOfFailures
of all (grouped) rows.SQL part:
MAX(NumberOfFailures) AS MaxNumberOfFailures
- Specified by:
maxNumberOfFailures
in interfaceTaskQuery.IAggregationQuery
- Returns:
- query for further composition
- See Also:
TaskQuery.IAggregationQuery.maxNumberOfFailures()
- 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 fieldNumberOfResumes
of all (grouped) rows.SQL part:
SUM(NumberOfResumes) AS SumNumberOfResumes
- Specified by:
sumNumberOfResumes
in interfaceTaskQuery.IAggregationQuery
- Returns:
- query for further composition
- See Also:
TaskQuery.IAggregationQuery.sumNumberOfResumes()
- 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 fieldNumberOfResumes
of all (grouped) rows.SQL part:
AVG(NumberOfResumes) AS AvgNumberOfResumes
- Specified by:
avgNumberOfResumes
in interfaceTaskQuery.IAggregationQuery
- Returns:
- query for further composition
- See Also:
TaskQuery.IAggregationQuery.avgNumberOfResumes()
- 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 fieldNumberOfResumes
of all (grouped) rows.SQL part:
MIN(NumberOfResumes) AS MinNumberOfResumes
- Specified by:
minNumberOfResumes
in interfaceTaskQuery.IAggregationQuery
- Returns:
- query for further composition
- See Also:
TaskQuery.IAggregationQuery.minNumberOfResumes()
- 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 fieldNumberOfResumes
of all (grouped) rows.SQL part:
MAX(NumberOfResumes) AS MaxNumberOfResumes
- Specified by:
maxNumberOfResumes
in interfaceTaskQuery.IAggregationQuery
- Returns:
- query for further composition
- See Also:
TaskQuery.IAggregationQuery.maxNumberOfResumes()
- 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 fieldCategory
of all (grouped) rows.SQL part:
MIN(Category) AS MinCategory
- Specified by:
minCategory
in interfaceTaskQuery.IAggregationQuery
- Returns:
- query for further composition
- See Also:
TaskQuery.IAggregationQuery.minCategory()
- 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 fieldCategory
of all (grouped) rows.SQL part:
MAX(Category) AS MaxCategory
- Specified by:
maxCategory
in interfaceTaskQuery.IAggregationQuery
- Returns:
- query for further composition
- See Also:
TaskQuery.IAggregationQuery.maxCategory()
- 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 fieldActivatorName
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 referencedActivator
.- Specified by:
minActivatorName
in interfaceTaskQuery.IAggregationQuery
- Returns:
- query for further composition
- See Also:
TaskQuery.IAggregationQuery.minActivatorName()
- 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 fieldActivatorName
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 referencedActivator
.- Specified by:
maxActivatorName
in interfaceTaskQuery.IAggregationQuery
- Returns:
- query for further composition
- See Also:
TaskQuery.IAggregationQuery.maxActivatorName()
- 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 fieldActivatorDisplayName
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 referencedActivator
.- Specified by:
minActivatorDisplayName
in interfaceTaskQuery.IAggregationQuery
- Returns:
- query for further composition
- See Also:
TaskQuery.IAggregationQuery.minActivatorDisplayName()
- 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 fieldActivatorDisplayName
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 referencedActivator
.- Specified by:
maxActivatorDisplayName
in interfaceTaskQuery.IAggregationQuery
- Returns:
- query for further composition
- See Also:
TaskQuery.IAggregationQuery.maxActivatorDisplayName()
- 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 interfaceTaskQuery.IAggregationQuery
- Returns:
- query for further composition
- API:
- This public API is available in IvyScript and Java. It has the visibility EXPERT.
-
-