Interface TaskQuery.IGroupByQueryColumns
-
- All Known Implementing Classes:
TaskQuery.GroupByQuery
- Enclosing class:
- TaskQuery
public static interface TaskQuery.IGroupByQueryColumns
Provides methods to group the result by certain fields.Example:
Corresponds to SQL:TaskQuery.create().groupBy().activatorUserId().priority().aggregate().countRows();
SELECT ActivatorUserId, Priority, Count(*) AS Count FROM IWA_Task GROUP BY ActivatorUserId, Priority
- API:
- This is a public API.
-
-
Method Summary
All Methods Instance Methods Abstract Methods Modifier and Type Method Description TaskQuery.GroupByQuery
activatorDisplayName()
Groups the result of the query by the fieldActivatorDisplayName
.TaskQuery.GroupByQuery
activatorId()
Groups the result of the query by the fieldActivatorId
.TaskQuery.GroupByQuery
activatorName()
Groups the result of the query by the fieldActivatorName
.TaskQuery.GroupByQuery
applicationId()
Groups the result of the query by the fieldApplicationId
.TaskQuery.GroupByQuery
businessCalendar()
Groups the result of the query by the fieldBusinessCalendar
.TaskQuery.GroupByQuery
businessCaseId()
Groups the result of the query by the fieldBusinessCaseId
.TaskQuery.GroupByQuery
businessRuntime()
Groups the result of the query by the fieldBusinessRuntime
.TaskQuery.GroupByQuery
caseId()
Groups the result of the query by the fieldCaseId
.TaskQuery.GroupByQuery
category()
Groups the result of the query by the fieldCategory
.TaskQuery.ICustomFieldGroupBy
customField()
Groups the result of the query by a custom field specified during further composition.TaskQuery.GroupByQuery
delayTimestamp()
Groups the result of the query by the fieldDelayTimestamp
.TaskQuery.GroupByQuery
description()
Groups the result of the query by the fieldDescription
.TaskQuery.GroupByQuery
displayDescriptionTemplate()
Groups the result of the query by the fieldDisplayDescriptionTemplate
.TaskQuery.GroupByQuery
displayNameTemplate()
Groups the result of the query by the fieldDisplayNameTemplate
.TaskQuery.GroupByQuery
endTaskSwitchEventId()
Groups the result of the query by the fieldEndTaskSwitchEventId
.TaskQuery.GroupByQuery
endTimestamp()
Groups the result of the query by the fieldEndTimestamp
.TaskQuery.GroupByQuery
expiredCreatorTaskId()
Groups the result of the query by the fieldExpiredCreatorTaskId
.TaskQuery.GroupByQuery
expiryActivatorDisplayName()
Groups the result of the query by the fieldExpiryActivatorDisplayName
.TaskQuery.GroupByQuery
expiryActivatorId()
Groups the result of the query by the fieldExpiryActivatorId
.TaskQuery.GroupByQuery
expiryActivatorName()
Groups the result of the query by the fieldExpiryActivatorName
.TaskQuery.GroupByQuery
expiryPriority()
Groups the result of the query by the fieldExpiryPriority
.TaskQuery.GroupByQuery
expiryTaskStartElementPid()
Groups the result of the query by the fieldExpiryTaskStartElementPid
.TaskQuery.GroupByQuery
expiryTimestamp()
Groups the result of the query by the fieldExpiryTimestamp
.TaskQuery.GroupByQuery
failedTimeoutTimestamp()
Groups the result of the query by the fieldFailedTimeoutTimestamp
.TaskQuery.GroupByQuery
isExpired()
Groups the result of the query by the fieldIsExpired
.TaskQuery.GroupByQuery
isOffline()
Groups the result of the query by the fieldIsOffline
.TaskQuery.GroupByQuery
isUpdatedOnStart()
Groups the result of the query by the fieldIsUpdatedOnStart
.TaskQuery.GroupByQuery
name()
Groups the result of the query by the fieldName
.TaskQuery.GroupByQuery
numberOfFailures()
Groups the result of the query by the fieldNumberOfFailures
.TaskQuery.GroupByQuery
numberOfResumes()
Groups the result of the query by the fieldNumberOfResumes
.TaskQuery.GroupByQuery
originalActivatorDisplayName()
Groups the result of the query by the fieldOriginalActivatorDisplayName
.TaskQuery.GroupByQuery
originalActivatorId()
Groups the result of the query by the fieldOriginalActivatorId
.TaskQuery.GroupByQuery
originalActivatorName()
Groups the result of the query by the fieldOriginalActivatorName
.TaskQuery.GroupByQuery
originalPriority()
Groups the result of the query by the fieldOriginalPriority
.TaskQuery.GroupByQuery
priority()
Groups the result of the query by the fieldPriority
.TaskQuery.GroupByQuery
processModelId()
Groups the result of the query by the fieldProcessModelId
.TaskQuery.GroupByQuery
requestPath()
Groups the result of the query by the fieldRequestPath
.TaskQuery.GroupByQuery
startTaskSwitchEventId()
Groups the result of the query by the fieldStartTaskSwitchEventId
.TaskQuery.GroupByQuery
startTimestamp()
Groups the result of the query by the fieldStartTimestamp
.TaskQuery.GroupByQuery
state()
Groups the result of the query by the fieldState
.TaskQuery.GroupByQuery
taskEndId()
Groups the result of the query by the fieldTaskEndId
.TaskQuery.GroupByQuery
taskId()
Groups the result of the query by the fieldTaskId
.TaskQuery.GroupByQuery
taskStartId()
Groups the result of the query by the fieldTaskStartId
.TaskQuery.GroupByQuery
timeoutedCreatorIntrmdtEventId()
Groups the result of the query by the fieldTimeoutedCreatorIntrmdtEventId
.TaskQuery.GroupByQuery
workerId()
Groups the result of the query by the fieldWorkerId
.TaskQuery.GroupByQuery
workerSessionId()
Groups the result of the query by the fieldWorkerSessionId
.TaskQuery.GroupByQuery
workerUserDisplayName()
Groups the result of the query by the fieldWorkerUserDisplayName
.TaskQuery.GroupByQuery
workerUserName()
Groups the result of the query by the fieldWorkerUserName
.TaskQuery.GroupByQuery
workingTime()
Groups the result of the query by the fieldWorkingTime
.
-
-
-
Method Detail
-
taskId
TaskQuery.GroupByQuery taskId()
Groups the result of the query by the field
TaskId
.SQL part:
GROUP BY TaskId
- Returns:
- query for further composition
- API:
- This public API is available in IvyScript and Java. It has the visibility EXPERT.
-
caseId
TaskQuery.GroupByQuery caseId()
Groups the result of the query by the field
CaseId
.SQL part:
GROUP BY CaseId
- Returns:
- query for further composition
- API:
- This public API is available in IvyScript and Java. It has the visibility EXPERT.
-
businessCaseId
TaskQuery.GroupByQuery businessCaseId()
Groups the result of the query by the field
BusinessCaseId
.SQL part:
GROUP BY BusinessCaseId
- Returns:
- query for further composition
- API:
- This public API is available in IvyScript and Java. It has the visibility EXPERT.
-
processModelId
TaskQuery.GroupByQuery processModelId()
Groups the result of the query by the field
ProcessModelId
.SQL part:
GROUP BY ProcessModelId
- Returns:
- query for further composition
- API:
- This public API is available in IvyScript and Java. It has the visibility EXPERT.
-
applicationId
TaskQuery.GroupByQuery applicationId()
Groups the result of the query by the field
ApplicationId
.SQL part:
GROUP BY ApplicationId
- Returns:
- query for further composition
- API:
- This public API is available in IvyScript and Java. It has the visibility EXPERT.
-
startTaskSwitchEventId
TaskQuery.GroupByQuery startTaskSwitchEventId()
Groups the result of the query by the field
StartTaskSwitchEventId
.SQL part:
GROUP BY StartTaskSwitchEventId
- Returns:
- query for further composition
- API:
- This public API is available in IvyScript and Java. It has the visibility EXPERT.
-
endTaskSwitchEventId
TaskQuery.GroupByQuery endTaskSwitchEventId()
Groups the result of the query by the field
EndTaskSwitchEventId
.SQL part:
GROUP BY EndTaskSwitchEventId
- Returns:
- query for further composition
- API:
- This public API is available in IvyScript and Java. It has the visibility EXPERT.
-
taskStartId
TaskQuery.GroupByQuery taskStartId()
Groups the result of the query by the field
TaskStartId
.SQL part:
GROUP BY TaskStartId
- Returns:
- query for further composition
- API:
- This public API is available in IvyScript and Java. It has the visibility EXPERT.
-
taskEndId
TaskQuery.GroupByQuery taskEndId()
Groups the result of the query by the field
TaskEndId
.SQL part:
GROUP BY TaskEndId
- Returns:
- query for further composition
- API:
- This public API is available in IvyScript and Java. It has the visibility EXPERT.
-
workerId
TaskQuery.GroupByQuery workerId()
Groups the result of the query by the field
WorkerId
.SQL part:
GROUP BY WorkerId
- Returns:
- query for further composition
- API:
- This public API is available in IvyScript and Java. It has the visibility EXPERT.
-
workerUserName
TaskQuery.GroupByQuery workerUserName()
Groups the result of the query by the field
WorkerUserName
.SQL part:
GROUP BY WorkerUserName
This is a virtual column. It contains the same value as the column
Name
of the referencedWorker
.- Returns:
- query for further composition
- API:
- This public API is available in IvyScript and Java. It has the visibility EXPERT.
-
workerUserDisplayName
TaskQuery.GroupByQuery workerUserDisplayName()
Groups the result of the query by the field
WorkerUserDisplayName
.SQL part:
GROUP BY WorkerUserDisplayName
This is a virtual column. It contains the same value as the column
DisplayName
of the referencedWorker
.- Returns:
- query for further composition
- API:
- This public API is available in IvyScript and Java. It has the visibility EXPERT.
-
workerSessionId
TaskQuery.GroupByQuery workerSessionId()
Groups the result of the query by the field
WorkerSessionId
.SQL part:
GROUP BY WorkerSessionId
- Returns:
- query for further composition
- API:
- This public API is available in IvyScript and Java. It has the visibility EXPERT.
-
activatorId
TaskQuery.GroupByQuery activatorId()
Groups the result of the query by the field
ActivatorId
.SQL part:
GROUP BY ActivatorId
- Returns:
- query for further composition
- API:
- This public API is available in IvyScript and Java. It has the visibility EXPERT.
-
originalActivatorId
TaskQuery.GroupByQuery originalActivatorId()
Groups the result of the query by the field
OriginalActivatorId
.SQL part:
GROUP BY OriginalActivatorId
- Returns:
- query for further composition
- API:
- This public API is available in IvyScript and Java. It has the visibility EXPERT.
-
originalActivatorName
TaskQuery.GroupByQuery originalActivatorName()
Groups the result of the query by the field
OriginalActivatorName
.SQL part:
GROUP BY OriginalActivatorName
This is a virtual column. It contains the same value as the column
MemberName
of the referencedOriginalActivator
.- Returns:
- query for further composition
- API:
- This public API is available in IvyScript and Java. It has the visibility EXPERT.
-
originalActivatorDisplayName
TaskQuery.GroupByQuery originalActivatorDisplayName()
Groups the result of the query by the field
OriginalActivatorDisplayName
.SQL part:
GROUP BY OriginalActivatorDisplayName
This is a virtual column. It contains the same value as the column
DisplayName
of the referencedOriginalActivator
.- Returns:
- query for further composition
- API:
- This public API is available in IvyScript and Java. It has the visibility EXPERT.
-
expiryActivatorId
TaskQuery.GroupByQuery expiryActivatorId()
Groups the result of the query by the field
ExpiryActivatorId
.SQL part:
GROUP BY ExpiryActivatorId
- Returns:
- query for further composition
- API:
- This public API is available in IvyScript and Java. It has the visibility EXPERT.
-
expiryActivatorName
TaskQuery.GroupByQuery expiryActivatorName()
Groups the result of the query by the field
ExpiryActivatorName
.SQL part:
GROUP BY ExpiryActivatorName
This is a virtual column. It contains the same value as the column
MemberName
of the referencedExpiryActivator
.- Returns:
- query for further composition
- API:
- This public API is available in IvyScript and Java. It has the visibility EXPERT.
-
expiryActivatorDisplayName
TaskQuery.GroupByQuery expiryActivatorDisplayName()
Groups the result of the query by the field
ExpiryActivatorDisplayName
.SQL part:
GROUP BY ExpiryActivatorDisplayName
This is a virtual column. It contains the same value as the column
DisplayName
of the referencedExpiryActivator
.- Returns:
- query for further composition
- API:
- This public API is available in IvyScript and Java. It has the visibility EXPERT.
-
expiryPriority
TaskQuery.GroupByQuery expiryPriority()
Groups the result of the query by the field
ExpiryPriority
.SQL part:
GROUP BY ExpiryPriority
- Returns:
- query for further composition
- API:
- This public API is available in IvyScript and Java. It has the visibility EXPERT.
-
expiryTimestamp
TaskQuery.GroupByQuery expiryTimestamp()
Groups the result of the query by the field
ExpiryTimestamp
.SQL part:
GROUP BY ExpiryTimestamp
- Returns:
- query for further composition
- API:
- This public API is available in IvyScript and Java. It has the visibility EXPERT.
-
expiryTaskStartElementPid
TaskQuery.GroupByQuery expiryTaskStartElementPid()
Groups the result of the query by the field
ExpiryTaskStartElementPid
.SQL part:
GROUP BY ExpiryTaskStartElementPid
- Returns:
- query for further composition
- API:
- This public API is available in IvyScript and Java. It has the visibility EXPERT.
-
isExpired
TaskQuery.GroupByQuery isExpired()
Groups the result of the query by the field
IsExpired
.SQL part:
GROUP BY IsExpired
- Returns:
- query for further composition
- API:
- This public API is available in IvyScript and Java. It has the visibility EXPERT.
-
expiredCreatorTaskId
TaskQuery.GroupByQuery expiredCreatorTaskId()
Groups the result of the query by the field
ExpiredCreatorTaskId
.SQL part:
GROUP BY ExpiredCreatorTaskId
- Returns:
- query for further composition
- API:
- This public API is available in IvyScript and Java. It has the visibility EXPERT.
-
timeoutedCreatorIntrmdtEventId
TaskQuery.GroupByQuery timeoutedCreatorIntrmdtEventId()
Groups the result of the query by the field
TimeoutedCreatorIntrmdtEventId
.SQL part:
GROUP BY TimeoutedCreatorIntrmdtEventId
- Returns:
- query for further composition
- API:
- This public API is available in IvyScript and Java. It has the visibility EXPERT.
-
delayTimestamp
TaskQuery.GroupByQuery delayTimestamp()
Groups the result of the query by the field
DelayTimestamp
.SQL part:
GROUP BY DelayTimestamp
- Returns:
- query for further composition
- API:
- This public API is available in IvyScript and Java. It has the visibility EXPERT.
-
state
TaskQuery.GroupByQuery state()
Groups the result of the query by the field
State
.SQL part:
GROUP BY State
- Returns:
- query for further composition
- API:
- This public API is available in IvyScript and Java. It has the visibility EXPERT.
-
requestPath
TaskQuery.GroupByQuery requestPath()
Groups the result of the query by the field
RequestPath
.SQL part:
GROUP BY RequestPath
- Returns:
- query for further composition
- API:
- This public API is available in IvyScript and Java. It has the visibility EXPERT.
-
displayNameTemplate
TaskQuery.GroupByQuery displayNameTemplate()
Groups the result of the query by the field
DisplayNameTemplate
.SQL part:
GROUP BY DisplayNameTemplate
- Returns:
- query for further composition
- API:
- This public API is available in IvyScript and Java. It has the visibility EXPERT.
-
name
TaskQuery.GroupByQuery name()
Groups the result of the query by the field
Name
.SQL part:
GROUP BY Name
- Returns:
- query for further composition
- API:
- This public API is available in IvyScript and Java. It has the visibility EXPERT.
-
displayDescriptionTemplate
TaskQuery.GroupByQuery displayDescriptionTemplate()
Groups the result of the query by the field
DisplayDescriptionTemplate
.SQL part:
GROUP BY DisplayDescriptionTemplate
- Returns:
- query for further composition
- API:
- This public API is available in IvyScript and Java. It has the visibility EXPERT.
-
description
TaskQuery.GroupByQuery description()
Groups the result of the query by the field
Description
.SQL part:
GROUP BY Description
- Returns:
- query for further composition
- API:
- This public API is available in IvyScript and Java. It has the visibility EXPERT.
-
priority
TaskQuery.GroupByQuery priority()
Groups the result of the query by the field
Priority
.SQL part:
GROUP BY Priority
- Returns:
- query for further composition
- API:
- This public API is available in IvyScript and Java. It has the visibility EXPERT.
-
originalPriority
TaskQuery.GroupByQuery originalPriority()
Groups the result of the query by the field
OriginalPriority
.SQL part:
GROUP BY OriginalPriority
- Returns:
- query for further composition
- API:
- This public API is available in IvyScript and Java. It has the visibility EXPERT.
-
startTimestamp
TaskQuery.GroupByQuery startTimestamp()
Groups the result of the query by the field
StartTimestamp
.SQL part:
GROUP BY StartTimestamp
- Returns:
- query for further composition
- API:
- This public API is available in IvyScript and Java. It has the visibility EXPERT.
-
endTimestamp
TaskQuery.GroupByQuery endTimestamp()
Groups the result of the query by the field
EndTimestamp
.SQL part:
GROUP BY EndTimestamp
- Returns:
- query for further composition
- API:
- This public API is available in IvyScript and Java. It has the visibility EXPERT.
-
businessCalendar
TaskQuery.GroupByQuery businessCalendar()
Groups the result of the query by the field
BusinessCalendar
.SQL part:
GROUP BY BusinessCalendar
- Returns:
- query for further composition
- API:
- This public API is available in IvyScript and Java. It has the visibility EXPERT.
-
workingTime
TaskQuery.GroupByQuery workingTime()
Groups the result of the query by the field
WorkingTime
.SQL part:
GROUP BY WorkingTime
- Returns:
- query for further composition
- API:
- This public API is available in IvyScript and Java. It has the visibility EXPERT.
-
businessRuntime
TaskQuery.GroupByQuery businessRuntime()
Groups the result of the query by the field
BusinessRuntime
.SQL part:
GROUP BY BusinessRuntime
- Returns:
- query for further composition
- API:
- This public API is available in IvyScript and Java. It has the visibility EXPERT.
-
failedTimeoutTimestamp
TaskQuery.GroupByQuery failedTimeoutTimestamp()
Groups the result of the query by the field
FailedTimeoutTimestamp
.SQL part:
GROUP BY FailedTimeoutTimestamp
- Returns:
- query for further composition
- API:
- This public API is available in IvyScript and Java. It has the visibility EXPERT.
-
numberOfFailures
TaskQuery.GroupByQuery numberOfFailures()
Groups the result of the query by the field
NumberOfFailures
.SQL part:
GROUP BY NumberOfFailures
- Returns:
- query for further composition
- API:
- This public API is available in IvyScript and Java. It has the visibility EXPERT.
-
numberOfResumes
TaskQuery.GroupByQuery numberOfResumes()
Groups the result of the query by the field
NumberOfResumes
.SQL part:
GROUP BY NumberOfResumes
- Returns:
- query for further composition
- API:
- This public API is available in IvyScript and Java. It has the visibility EXPERT.
-
category
TaskQuery.GroupByQuery category()
Groups the result of the query by the field
Category
.SQL part:
GROUP BY Category
- Returns:
- query for further composition
- API:
- This public API is available in IvyScript and Java. It has the visibility EXPERT.
-
isUpdatedOnStart
TaskQuery.GroupByQuery isUpdatedOnStart()
Groups the result of the query by the field
IsUpdatedOnStart
.SQL part:
GROUP BY IsUpdatedOnStart
- Returns:
- query for further composition
- API:
- This public API is available in IvyScript and Java. It has the visibility EXPERT.
-
isOffline
TaskQuery.GroupByQuery isOffline()
Groups the result of the query by the field
IsOffline
.SQL part:
GROUP BY IsOffline
- Returns:
- query for further composition
- API:
- This public API is available in IvyScript and Java. It has the visibility EXPERT.
-
activatorName
TaskQuery.GroupByQuery activatorName()
Groups the result of the query by the field
ActivatorName
.SQL part:
GROUP BY ActivatorName
This is a virtual column. It contains the same value as the column
MemberName
of the referencedActivator
.- Returns:
- query for further composition
- API:
- This public API is available in IvyScript and Java. It has the visibility EXPERT.
-
activatorDisplayName
TaskQuery.GroupByQuery activatorDisplayName()
Groups the result of the query by the field
ActivatorDisplayName
.SQL part:
GROUP BY ActivatorDisplayName
This is a virtual column. It contains the same value as the column
DisplayName
of the referencedActivator
.- Returns:
- query for further composition
- API:
- This public API is available in IvyScript and Java. It has the visibility EXPERT.
-
customField
TaskQuery.ICustomFieldGroupBy customField()
Groups the result of the query by a custom field specified during further composition.
- Returns:
- query for further composition
- API:
- This public API is available in IvyScript and Java. It has the visibility EXPERT.
-
-