Class TaskQuery.AggregationQuery
- All Implemented Interfaces:
TaskQuery.IAggregationQuery
- Enclosing class:
- TaskQuery
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.ITaskBusinessStateFilterQuery, TaskQuery.ITaskStateFilterQuery, TaskQuery.IUUIDColumnFilterQuery, TaskQuery.IWorkflowPriorityFilterQuery, TaskQuery.OrderByColumnQuery, TaskQuery.OrderByQuery
-
Method Summary
Modifier and TypeMethodDescriptionAdds a result columnAvgBusinessRuntime
to the query, that contains the average of the fieldBusinessRuntime
of all (grouped) rows.Adds a result columnAvgDelayTimestamp
to the query, that contains the average of the fieldDelayTimestamp
of all (grouped) rows.Adds a result columnAvgEndTimestamp
to the query, that contains the average of the fieldEndTimestamp
of all (grouped) rows.Adds a result columnAvgExpiryTimestamp
to the query, that contains the average of the fieldExpiryTimestamp
of all (grouped) rows.Adds a result columnAvgFailedTimeoutTimestamp
to the query, that contains the average of the fieldFailedTimeoutTimestamp
of all (grouped) rows.Adds a result columnAvgNumberOfFailures
to the query, that contains the average of the fieldNumberOfFailures
of all (grouped) rows.Adds a result columnAvgNumberOfResumes
to the query, that contains the average of the fieldNumberOfResumes
of all (grouped) rows.Adds a result columnAvgStartTimestamp
to the query, that contains the average of the fieldStartTimestamp
of all (grouped) rows.Adds a result columnAvgWorkerSessionId
to the query, that contains the average of the fieldWorkerSessionId
of all (grouped) rows.Adds a result columnAvgWorkingTime
to the query, that contains the average of the fieldWorkingTime
of all (grouped) rows.Adds a result columnCount
to the query, that contains the number of (grouped) rows.Adds a result custom field to the query.Adds a result columnMaxActivatorDisplayName
to the query, that contains the maximum value of the fieldActivatorDisplayName
of all (grouped) rows.Adds a result columnMaxActivatorName
to the query, that contains the maximum value of the fieldActivatorName
of all (grouped) rows.Adds a result columnMaxBusinessCalendar
to the query, that contains the maximum value of the fieldBusinessCalendar
of all (grouped) rows.Adds a result columnMaxBusinessRuntime
to the query, that contains the maximum value of the fieldBusinessRuntime
of all (grouped) rows.Adds a result columnMaxCategory
to the query, that contains the maximum value of the fieldCategory
of all (grouped) rows.Adds a result columnMaxDelayTimestamp
to the query, that contains the maximum value of the fieldDelayTimestamp
of all (grouped) rows.Adds a result columnMaxEndTimestamp
to the query, that contains the maximum value of the fieldEndTimestamp
of all (grouped) rows.Adds a result columnMaxExpiryActivatorDisplayName
to the query, that contains the maximum value of the fieldExpiryActivatorDisplayName
of all (grouped) rows.Adds a result columnMaxExpiryActivatorName
to the query, that contains the maximum value of the fieldExpiryActivatorName
of all (grouped) rows.Adds a result columnMaxExpiryTaskStartElementPid
to the query, that contains the maximum value of the fieldExpiryTaskStartElementPid
of all (grouped) rows.Adds a result columnMaxExpiryTimestamp
to the query, that contains the maximum value of the fieldExpiryTimestamp
of all (grouped) rows.Adds a result columnMaxFailedTimeoutTimestamp
to the query, that contains the maximum value of the fieldFailedTimeoutTimestamp
of all (grouped) rows.maxName()
Adds a result columnMaxName
to the query, that contains the maximum value of the fieldName
of all (grouped) rows.Adds a result columnMaxNumberOfFailures
to the query, that contains the maximum value of the fieldNumberOfFailures
of all (grouped) rows.Adds a result columnMaxNumberOfResumes
to the query, that contains the maximum value of the fieldNumberOfResumes
of all (grouped) rows.Adds a result columnMaxOriginalActivatorDisplayName
to the query, that contains the maximum value of the fieldOriginalActivatorDisplayName
of all (grouped) rows.Adds a result columnMaxOriginalActivatorName
to the query, that contains the maximum value of the fieldOriginalActivatorName
of all (grouped) rows.Adds a result columnMaxRequestPath
to the query, that contains the maximum value of the fieldRequestPath
of all (grouped) rows.Adds a result columnMaxStartTimestamp
to the query, that contains the maximum value of the fieldStartTimestamp
of all (grouped) rows.Adds a result columnMaxTaskId
to the query, that contains the maximum value of the fieldTaskId
of all (grouped) rows.Adds a result columnMaxWorkerSessionId
to the query, that contains the maximum value of the fieldWorkerSessionId
of all (grouped) rows.Adds a result columnMaxWorkerUserDisplayName
to the query, that contains the maximum value of the fieldWorkerUserDisplayName
of all (grouped) rows.Adds a result columnMaxWorkerUserName
to the query, that contains the maximum value of the fieldWorkerUserName
of all (grouped) rows.Adds a result columnMaxWorkingTime
to the query, that contains the maximum value of the fieldWorkingTime
of all (grouped) rows.Adds a result columnMinActivatorDisplayName
to the query, that contains the minimum value of the fieldActivatorDisplayName
of all (grouped) rows.Adds a result columnMinActivatorName
to the query, that contains the minimum value of the fieldActivatorName
of all (grouped) rows.Adds a result columnMinBusinessCalendar
to the query, that contains the minimum value of the fieldBusinessCalendar
of all (grouped) rows.Adds a result columnMinBusinessRuntime
to the query, that contains the minimum value of the fieldBusinessRuntime
of all (grouped) rows.Adds a result columnMinCategory
to the query, that contains the minimum value of the fieldCategory
of all (grouped) rows.Adds a result columnMinDelayTimestamp
to the query, that contains the minimum value of the fieldDelayTimestamp
of all (grouped) rows.Adds a result columnMinEndTimestamp
to the query, that contains the minimum value of the fieldEndTimestamp
of all (grouped) rows.Adds a result columnMinExpiryActivatorDisplayName
to the query, that contains the minimum value of the fieldExpiryActivatorDisplayName
of all (grouped) rows.Adds a result columnMinExpiryActivatorName
to the query, that contains the minimum value of the fieldExpiryActivatorName
of all (grouped) rows.Adds a result columnMinExpiryTaskStartElementPid
to the query, that contains the minimum value of the fieldExpiryTaskStartElementPid
of all (grouped) rows.Adds a result columnMinExpiryTimestamp
to the query, that contains the minimum value of the fieldExpiryTimestamp
of all (grouped) rows.Adds a result columnMinFailedTimeoutTimestamp
to the query, that contains the minimum value of the fieldFailedTimeoutTimestamp
of all (grouped) rows.minName()
Adds a result columnMinName
to the query, that contains the minimum value of the fieldName
of all (grouped) rows.Adds a result columnMinNumberOfFailures
to the query, that contains the minimum value of the fieldNumberOfFailures
of all (grouped) rows.Adds a result columnMinNumberOfResumes
to the query, that contains the minimum value of the fieldNumberOfResumes
of all (grouped) rows.Adds a result columnMinOriginalActivatorDisplayName
to the query, that contains the minimum value of the fieldOriginalActivatorDisplayName
of all (grouped) rows.Adds a result columnMinOriginalActivatorName
to the query, that contains the minimum value of the fieldOriginalActivatorName
of all (grouped) rows.Adds a result columnMinRequestPath
to the query, that contains the minimum value of the fieldRequestPath
of all (grouped) rows.Adds a result columnMinStartTimestamp
to the query, that contains the minimum value of the fieldStartTimestamp
of all (grouped) rows.Adds a result columnMinTaskId
to the query, that contains the minimum value of the fieldTaskId
of all (grouped) rows.Adds a result columnMinWorkerSessionId
to the query, that contains the minimum value of the fieldWorkerSessionId
of all (grouped) rows.Adds a result columnMinWorkerUserDisplayName
to the query, that contains the minimum value of the fieldWorkerUserDisplayName
of all (grouped) rows.Adds a result columnMinWorkerUserName
to the query, that contains the minimum value of the fieldWorkerUserName
of all (grouped) rows.Adds a result columnMinWorkingTime
to the query, that contains the minimum value of the fieldWorkingTime
of all (grouped) rows.Adds a result columnSumBusinessRuntime
to the query, that contains the sum of the fieldBusinessRuntime
of all (grouped) rows.Adds a result columnSumNumberOfFailures
to the query, that contains the sum of the fieldNumberOfFailures
of all (grouped) rows.Adds a result columnSumNumberOfResumes
to the query, that contains the sum of the fieldNumberOfResumes
of all (grouped) rows.Adds a result columnSumWorkerSessionId
to the query, that contains the sum of the fieldWorkerSessionId
of all (grouped) rows.Adds a result columnSumWorkingTime
to the query, that contains the sum of the fieldWorkingTime
of all (grouped) rows.
-
Method Details
-
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
- API:
- This public API is available in Java.
-
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
- API:
- This public API is available in Java.
-
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
- API:
- This public API is available in Java.
-
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
- API:
- This public API is available in Java.
-
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
- API:
- This public API is available in Java.
-
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
- API:
- This public API is available in Java.
-
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
- API:
- This public API is available in Java.
-
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
- API:
- This public API is available in Java.
-
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
- API:
- This public API is available in Java.
-
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
- API:
- This public API is available in Java.
-
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
- API:
- This public API is available in Java.
-
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
- API:
- This public API is available in Java.
-
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
- API:
- This public API is available in Java.
-
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
- API:
- This public API is available in Java.
-
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
- API:
- This public API is available in Java.
-
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
- API:
- This public API is available in Java.
-
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
- API:
- This public API is available in Java.
-
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
- API:
- This public API is available in Java.
-
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
- API:
- This public API is available in Java.
-
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
- API:
- This public API is available in Java.
-
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
- API:
- This public API is available in Java.
-
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
- API:
- This public API is available in Java.
-
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
- API:
- This public API is available in Java.
-
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
- API:
- This public API is available in Java.
-
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
- API:
- This public API is available in Java.
-
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
- API:
- This public API is available in Java.
-
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
- API:
- This public API is available in Java.
-
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
- API:
- This public API is available in Java.
-
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
- API:
- This public API is available in Java.
-
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
This is a virtual column. It contains the same value as the column
Name
of the referencedTaskLocalized
.- Specified by:
minName
in interfaceTaskQuery.IAggregationQuery
- Returns:
- query for further composition
- API:
- This public API is available in Java.
-
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
This is a virtual column. It contains the same value as the column
Name
of the referencedTaskLocalized
.- Specified by:
maxName
in interfaceTaskQuery.IAggregationQuery
- Returns:
- query for further composition
- API:
- This public API is available in Java.
-
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
- API:
- This public API is available in Java.
-
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
- API:
- This public API is available in Java.
-
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
- API:
- This public API is available in Java.
-
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
- API:
- This public API is available in Java.
-
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
- API:
- This public API is available in Java.
-
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
- API:
- This public API is available in Java.
-
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
- API:
- This public API is available in Java.
-
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
- API:
- This public API is available in Java.
-
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
- API:
- This public API is available in Java.
-
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
- API:
- This public API is available in Java.
-
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
- API:
- This public API is available in Java.
-
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
- API:
- This public API is available in Java.
-
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
- API:
- This public API is available in Java.
-
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
- API:
- This public API is available in Java.
-
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
- API:
- This public API is available in Java.
-
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
- API:
- This public API is available in Java.
-
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
- API:
- This public API is available in Java.
-
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
- API:
- This public API is available in Java.
-
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
- API:
- This public API is available in Java.
-
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
- API:
- This public API is available in Java.
-
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
- API:
- This public API is available in Java.
-
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
- API:
- This public API is available in Java.
-
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
- API:
- This public API is available in Java.
-
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
- API:
- This public API is available in Java.
-
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
- API:
- This public API is available in Java.
-
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
- API:
- This public API is available in Java.
-
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
- API:
- This public API is available in Java.
-
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
- API:
- This public API is available in Java.
-
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
- API:
- This public API is available in Java.
-
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
- API:
- This public API is available in Java.
-
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
- API:
- This public API is available in Java.
-
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
- API:
- This public API is available in Java.
-
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
- API:
- This public API is available in Java.
-
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 Java.
-