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
activatorName()
Groups the result of the query by the fieldActivatorName
.TaskQuery.GroupByQuery
activatorRoleId()
Groups the result of the query by the fieldActivatorRoleId
.TaskQuery.GroupByQuery
activatorUserId()
Groups the result of the query by the fieldActivatorUserId
.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
expiryActivatorName()
Groups the result of the query by the fieldExpiryActivatorName
.TaskQuery.GroupByQuery
expiryActivatorRoleId()
Groups the result of the query by the fieldExpiryActivatorRoleId
.TaskQuery.GroupByQuery
expiryActivatorUserId()
Groups the result of the query by the fieldExpiryActivatorUserId
.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
originalActivatorName()
Groups the result of the query by the fieldOriginalActivatorName
.TaskQuery.GroupByQuery
originalActivatorRoleId()
Groups the result of the query by the fieldOriginalActivatorRoleId
.TaskQuery.GroupByQuery
originalActivatorUserId()
Groups the result of the query by the fieldOriginalActivatorUserId
.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
workerSessionId()
Groups the result of the query by the fieldWorkerSessionId
.TaskQuery.GroupByQuery
workerUserDisplayName()
Groups the result of the query by the fieldWorkerUserDisplayName
.TaskQuery.GroupByQuery
workerUserId()
Groups the result of the query by the fieldWorkerUserId
.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.
-
workerUserId
TaskQuery.GroupByQuery workerUserId()
Groups the result of the query by the field
WorkerUserId
.SQL part:
GROUP BY WorkerUserId
- 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
- 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
- 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.
-
originalActivatorRoleId
TaskQuery.GroupByQuery originalActivatorRoleId()
Groups the result of the query by the field
OriginalActivatorRoleId
.SQL part:
GROUP BY OriginalActivatorRoleId
- Returns:
- query for further composition
- API:
- This public API is available in IvyScript and Java. It has the visibility EXPERT.
-
originalActivatorUserId
TaskQuery.GroupByQuery originalActivatorUserId()
Groups the result of the query by the field
OriginalActivatorUserId
.SQL part:
GROUP BY OriginalActivatorUserId
- 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
- 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
- Returns:
- query for further composition
- API:
- This public API is available in IvyScript and Java. It has the visibility EXPERT.
-
expiryActivatorRoleId
TaskQuery.GroupByQuery expiryActivatorRoleId()
Groups the result of the query by the field
ExpiryActivatorRoleId
.SQL part:
GROUP BY ExpiryActivatorRoleId
- Returns:
- query for further composition
- API:
- This public API is available in IvyScript and Java. It has the visibility EXPERT.
-
expiryActivatorUserId
TaskQuery.GroupByQuery expiryActivatorUserId()
Groups the result of the query by the field
ExpiryActivatorUserId
.SQL part:
GROUP BY ExpiryActivatorUserId
- 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
- 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
- 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.
-
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.
-
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.
-
activatorName
TaskQuery.GroupByQuery activatorName()
Groups the result of the query by the field
ActivatorName
.SQL part:
GROUP BY ActivatorName
- 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
- Returns:
- query for further composition
- API:
- This public API is available in IvyScript and Java. It has the visibility EXPERT.
-
activatorRoleId
TaskQuery.GroupByQuery activatorRoleId()
Groups the result of the query by the field
ActivatorRoleId
.SQL part:
GROUP BY ActivatorRoleId
- Returns:
- query for further composition
- API:
- This public API is available in IvyScript and Java. It has the visibility EXPERT.
-
activatorUserId
TaskQuery.GroupByQuery activatorUserId()
Groups the result of the query by the field
ActivatorUserId
.SQL part:
GROUP BY ActivatorUserId
- 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.
-
-