Class TaskQuery.GroupByQuery
- All Implemented Interfaces:
TaskQuery.IGroupByQueryColumns
- Enclosing class:
- TaskQuery
- 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
Modifier and TypeMethodDescriptionGroups the result of the query by the fieldActivatorDisplayName
.Groups the result of the query by the fieldActivatorId
.Groups the result of the query by the fieldActivatorName
.Groups the result of the query by the fieldApplicationId
.Groups the result of the query by the fieldBusinessCalendar
.Groups the result of the query by the fieldBusinessCaseId
.Groups the result of the query by the fieldBusinessRuntime
.caseId()
Groups the result of the query by the fieldCaseId
.category()
Groups the result of the query by the fieldCategory
.Groups the result of the query by a custom field specified during further composition.Groups the result of the query by the fieldDelayTimestamp
.Groups the result of the query by the fieldDescription
.Groups the result of the query by the fieldEndTaskSwitchEventId
.Groups the result of the query by the fieldEndTimestamp
.Groups the result of the query by the fieldExpiredCreatorTaskId
.Groups the result of the query by the fieldExpiryActivatorDisplayName
.Groups the result of the query by the fieldExpiryActivatorId
.Groups the result of the query by the fieldExpiryActivatorName
.Groups the result of the query by the fieldExpiryPriority
.Groups the result of the query by the fieldExpiryTaskStartElementPid
.Groups the result of the query by the fieldExpiryTimestamp
.Groups the result of the query by the fieldFailedTimeoutTimestamp
.Groups the result of the query by the fieldIsExpired
.Groups the result of the query by the fieldIsOffline
.Groups the result of the query by the fieldIsUpdatedOnStart
.Groups the result of the query by the fieldLanguageId
.name()
Groups the result of the query by the fieldName
.Groups the result of the query by the fieldNumberOfFailures
.Groups the result of the query by the fieldNumberOfResumes
.Groups the result of the query by the fieldOriginalActivatorDisplayName
.Groups the result of the query by the fieldOriginalActivatorId
.Groups the result of the query by the fieldOriginalActivatorName
.Groups the result of the query by the fieldOriginalPriority
.priority()
Groups the result of the query by the fieldPriority
.Groups the result of the query by the fieldProcessModelId
.Groups the result of the query by the fieldRequestPath
.Groups the result of the query by the fieldSecuritySystemId
.Groups the result of the query by the fieldStartTaskSwitchEventId
.Groups the result of the query by the fieldStartTimestamp
.state()
Groups the result of the query by the fieldState
.Groups the result of the query by the fieldTaskEndId
.taskId()
Groups the result of the query by the fieldTaskId
.Groups the result of the query by the fieldTaskStartId
.Groups the result of the query by the fieldTimeoutedCreatorIntrmdtEventId
.workerId()
Groups the result of the query by the fieldWorkerId
.Groups the result of the query by the fieldWorkerSessionId
.Groups the result of the query by the fieldWorkerUserDisplayName
.Groups the result of the query by the fieldWorkerUserName
.Groups the result of the query by the fieldWorkingTime
.
-
Method Details
-
taskId
Description copied from interface:TaskQuery.IGroupByQueryColumns
Groups the result of the query by the field
TaskId
.SQL part:
GROUP BY TaskId
- Specified by:
taskId
in interfaceTaskQuery.IGroupByQueryColumns
- Returns:
- query for further composition
- API:
- This public API is available in IvyScript and Java. It has the visibility EXPERT.
-
caseId
Description copied from interface:TaskQuery.IGroupByQueryColumns
Groups the result of the query by the field
CaseId
.SQL part:
GROUP BY CaseId
- Specified by:
caseId
in interfaceTaskQuery.IGroupByQueryColumns
- Returns:
- query for further composition
- API:
- This public API is available in IvyScript and Java. It has the visibility EXPERT.
-
businessCaseId
Description copied from interface:TaskQuery.IGroupByQueryColumns
Groups the result of the query by the field
BusinessCaseId
.SQL part:
GROUP BY BusinessCaseId
- Specified by:
businessCaseId
in interfaceTaskQuery.IGroupByQueryColumns
- Returns:
- query for further composition
- API:
- This public API is available in IvyScript and Java. It has the visibility EXPERT.
-
processModelId
Description copied from interface:TaskQuery.IGroupByQueryColumns
Groups the result of the query by the field
ProcessModelId
.SQL part:
GROUP BY ProcessModelId
- Specified by:
processModelId
in interfaceTaskQuery.IGroupByQueryColumns
- Returns:
- query for further composition
- API:
- This public API is available in IvyScript and Java. It has the visibility EXPERT.
-
securitySystemId
Description copied from interface:TaskQuery.IGroupByQueryColumns
Groups the result of the query by the field
SecuritySystemId
.SQL part:
GROUP BY SecuritySystemId
- Specified by:
securitySystemId
in interfaceTaskQuery.IGroupByQueryColumns
- Returns:
- query for further composition
- API:
- This public API is available in IvyScript and Java. It has the visibility EXPERT.
-
applicationId
Description copied from interface:TaskQuery.IGroupByQueryColumns
Groups the result of the query by the field
ApplicationId
.SQL part:
GROUP BY ApplicationId
- Specified by:
applicationId
in interfaceTaskQuery.IGroupByQueryColumns
- Returns:
- query for further composition
- API:
- This public API is available in IvyScript and Java. It has the visibility EXPERT.
-
startTaskSwitchEventId
Description copied from interface:TaskQuery.IGroupByQueryColumns
Groups the result of the query by the field
StartTaskSwitchEventId
.SQL part:
GROUP BY StartTaskSwitchEventId
- Specified by:
startTaskSwitchEventId
in interfaceTaskQuery.IGroupByQueryColumns
- Returns:
- query for further composition
- API:
- This public API is available in IvyScript and Java. It has the visibility EXPERT.
-
endTaskSwitchEventId
Description copied from interface:TaskQuery.IGroupByQueryColumns
Groups the result of the query by the field
EndTaskSwitchEventId
.SQL part:
GROUP BY EndTaskSwitchEventId
- Specified by:
endTaskSwitchEventId
in interfaceTaskQuery.IGroupByQueryColumns
- Returns:
- query for further composition
- API:
- This public API is available in IvyScript and Java. It has the visibility EXPERT.
-
taskStartId
Description copied from interface:TaskQuery.IGroupByQueryColumns
Groups the result of the query by the field
TaskStartId
.SQL part:
GROUP BY TaskStartId
- Specified by:
taskStartId
in interfaceTaskQuery.IGroupByQueryColumns
- Returns:
- query for further composition
- API:
- This public API is available in IvyScript and Java. It has the visibility EXPERT.
-
taskEndId
Description copied from interface:TaskQuery.IGroupByQueryColumns
Groups the result of the query by the field
TaskEndId
.SQL part:
GROUP BY TaskEndId
- Specified by:
taskEndId
in interfaceTaskQuery.IGroupByQueryColumns
- Returns:
- query for further composition
- API:
- This public API is available in IvyScript and Java. It has the visibility EXPERT.
-
workerId
Description copied from interface:TaskQuery.IGroupByQueryColumns
Groups the result of the query by the field
WorkerId
.SQL part:
GROUP BY WorkerId
- Specified by:
workerId
in interfaceTaskQuery.IGroupByQueryColumns
- Returns:
- query for further composition
- API:
- This public API is available in IvyScript and Java. It has the visibility EXPERT.
-
workerUserName
Description copied from interface:TaskQuery.IGroupByQueryColumns
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
.- Specified by:
workerUserName
in interfaceTaskQuery.IGroupByQueryColumns
- Returns:
- query for further composition
- API:
- This public API is available in IvyScript and Java. It has the visibility EXPERT.
-
workerUserDisplayName
Description copied from interface:TaskQuery.IGroupByQueryColumns
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
.- Specified by:
workerUserDisplayName
in interfaceTaskQuery.IGroupByQueryColumns
- Returns:
- query for further composition
- API:
- This public API is available in IvyScript and Java. It has the visibility EXPERT.
-
workerSessionId
Description copied from interface:TaskQuery.IGroupByQueryColumns
Groups the result of the query by the field
WorkerSessionId
.SQL part:
GROUP BY WorkerSessionId
- Specified by:
workerSessionId
in interfaceTaskQuery.IGroupByQueryColumns
- Returns:
- query for further composition
- API:
- This public API is available in IvyScript and Java. It has the visibility EXPERT.
-
activatorId
Description copied from interface:TaskQuery.IGroupByQueryColumns
Groups the result of the query by the field
ActivatorId
.SQL part:
GROUP BY ActivatorId
- Specified by:
activatorId
in interfaceTaskQuery.IGroupByQueryColumns
- Returns:
- query for further composition
- API:
- This public API is available in IvyScript and Java. It has the visibility EXPERT.
-
originalActivatorId
Description copied from interface:TaskQuery.IGroupByQueryColumns
Groups the result of the query by the field
OriginalActivatorId
.SQL part:
GROUP BY OriginalActivatorId
- Specified by:
originalActivatorId
in interfaceTaskQuery.IGroupByQueryColumns
- Returns:
- query for further composition
- API:
- This public API is available in IvyScript and Java. It has the visibility EXPERT.
-
originalActivatorName
Description copied from interface:TaskQuery.IGroupByQueryColumns
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
.- Specified by:
originalActivatorName
in interfaceTaskQuery.IGroupByQueryColumns
- Returns:
- query for further composition
- API:
- This public API is available in IvyScript and Java. It has the visibility EXPERT.
-
originalActivatorDisplayName
Description copied from interface:TaskQuery.IGroupByQueryColumns
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
.- Specified by:
originalActivatorDisplayName
in interfaceTaskQuery.IGroupByQueryColumns
- Returns:
- query for further composition
- API:
- This public API is available in IvyScript and Java. It has the visibility EXPERT.
-
expiryActivatorId
Description copied from interface:TaskQuery.IGroupByQueryColumns
Groups the result of the query by the field
ExpiryActivatorId
.SQL part:
GROUP BY ExpiryActivatorId
- Specified by:
expiryActivatorId
in interfaceTaskQuery.IGroupByQueryColumns
- Returns:
- query for further composition
- API:
- This public API is available in IvyScript and Java. It has the visibility EXPERT.
-
expiryActivatorName
Description copied from interface:TaskQuery.IGroupByQueryColumns
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
.- Specified by:
expiryActivatorName
in interfaceTaskQuery.IGroupByQueryColumns
- Returns:
- query for further composition
- API:
- This public API is available in IvyScript and Java. It has the visibility EXPERT.
-
expiryActivatorDisplayName
Description copied from interface:TaskQuery.IGroupByQueryColumns
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
.- Specified by:
expiryActivatorDisplayName
in interfaceTaskQuery.IGroupByQueryColumns
- Returns:
- query for further composition
- API:
- This public API is available in IvyScript and Java. It has the visibility EXPERT.
-
expiryPriority
Description copied from interface:TaskQuery.IGroupByQueryColumns
Groups the result of the query by the field
ExpiryPriority
.SQL part:
GROUP BY ExpiryPriority
- Specified by:
expiryPriority
in interfaceTaskQuery.IGroupByQueryColumns
- Returns:
- query for further composition
- API:
- This public API is available in IvyScript and Java. It has the visibility EXPERT.
-
expiryTimestamp
Description copied from interface:TaskQuery.IGroupByQueryColumns
Groups the result of the query by the field
ExpiryTimestamp
.SQL part:
GROUP BY ExpiryTimestamp
- Specified by:
expiryTimestamp
in interfaceTaskQuery.IGroupByQueryColumns
- Returns:
- query for further composition
- API:
- This public API is available in IvyScript and Java. It has the visibility EXPERT.
-
expiryTaskStartElementPid
Description copied from interface:TaskQuery.IGroupByQueryColumns
Groups the result of the query by the field
ExpiryTaskStartElementPid
.SQL part:
GROUP BY ExpiryTaskStartElementPid
- Specified by:
expiryTaskStartElementPid
in interfaceTaskQuery.IGroupByQueryColumns
- Returns:
- query for further composition
- API:
- This public API is available in IvyScript and Java. It has the visibility EXPERT.
-
isExpired
Description copied from interface:TaskQuery.IGroupByQueryColumns
Groups the result of the query by the field
IsExpired
.SQL part:
GROUP BY IsExpired
- Specified by:
isExpired
in interfaceTaskQuery.IGroupByQueryColumns
- Returns:
- query for further composition
- API:
- This public API is available in IvyScript and Java. It has the visibility EXPERT.
-
expiredCreatorTaskId
Description copied from interface:TaskQuery.IGroupByQueryColumns
Groups the result of the query by the field
ExpiredCreatorTaskId
.SQL part:
GROUP BY ExpiredCreatorTaskId
- Specified by:
expiredCreatorTaskId
in interfaceTaskQuery.IGroupByQueryColumns
- Returns:
- query for further composition
- API:
- This public API is available in IvyScript and Java. It has the visibility EXPERT.
-
timeoutedCreatorIntrmdtEventId
Description copied from interface:TaskQuery.IGroupByQueryColumns
Groups the result of the query by the field
TimeoutedCreatorIntrmdtEventId
.SQL part:
GROUP BY TimeoutedCreatorIntrmdtEventId
- Specified by:
timeoutedCreatorIntrmdtEventId
in interfaceTaskQuery.IGroupByQueryColumns
- Returns:
- query for further composition
- API:
- This public API is available in IvyScript and Java. It has the visibility EXPERT.
-
delayTimestamp
Description copied from interface:TaskQuery.IGroupByQueryColumns
Groups the result of the query by the field
DelayTimestamp
.SQL part:
GROUP BY DelayTimestamp
- Specified by:
delayTimestamp
in interfaceTaskQuery.IGroupByQueryColumns
- Returns:
- query for further composition
- API:
- This public API is available in IvyScript and Java. It has the visibility EXPERT.
-
state
Description copied from interface:TaskQuery.IGroupByQueryColumns
Groups the result of the query by the field
State
.SQL part:
GROUP BY State
- Specified by:
state
in interfaceTaskQuery.IGroupByQueryColumns
- Returns:
- query for further composition
- API:
- This public API is available in IvyScript and Java. It has the visibility EXPERT.
-
requestPath
Description copied from interface:TaskQuery.IGroupByQueryColumns
Groups the result of the query by the field
RequestPath
.SQL part:
GROUP BY RequestPath
- Specified by:
requestPath
in interfaceTaskQuery.IGroupByQueryColumns
- Returns:
- query for further composition
- API:
- This public API is available in IvyScript and Java. It has the visibility EXPERT.
-
name
Description copied from interface:TaskQuery.IGroupByQueryColumns
Groups the result of the query by the field
Name
.SQL part:
GROUP BY Name
This is a virtual column. It contains the same value as the column
Name
of the referencedTaskLocalized
.- Specified by:
name
in interfaceTaskQuery.IGroupByQueryColumns
- Returns:
- query for further composition
- API:
- This public API is available in IvyScript and Java. It has the visibility EXPERT.
-
description
Description copied from interface:TaskQuery.IGroupByQueryColumns
Groups the result of the query by the field
Description
.SQL part:
GROUP BY Description
This is a virtual column. It contains the same value as the column
Description
of the referencedTaskLocalized
.- Specified by:
description
in interfaceTaskQuery.IGroupByQueryColumns
- Returns:
- query for further composition
- API:
- This public API is available in IvyScript and Java. It has the visibility EXPERT.
-
priority
Description copied from interface:TaskQuery.IGroupByQueryColumns
Groups the result of the query by the field
Priority
.SQL part:
GROUP BY Priority
- Specified by:
priority
in interfaceTaskQuery.IGroupByQueryColumns
- Returns:
- query for further composition
- API:
- This public API is available in IvyScript and Java. It has the visibility EXPERT.
-
originalPriority
Description copied from interface:TaskQuery.IGroupByQueryColumns
Groups the result of the query by the field
OriginalPriority
.SQL part:
GROUP BY OriginalPriority
- Specified by:
originalPriority
in interfaceTaskQuery.IGroupByQueryColumns
- Returns:
- query for further composition
- API:
- This public API is available in IvyScript and Java. It has the visibility EXPERT.
-
startTimestamp
Description copied from interface:TaskQuery.IGroupByQueryColumns
Groups the result of the query by the field
StartTimestamp
.SQL part:
GROUP BY StartTimestamp
- Specified by:
startTimestamp
in interfaceTaskQuery.IGroupByQueryColumns
- Returns:
- query for further composition
- API:
- This public API is available in IvyScript and Java. It has the visibility EXPERT.
-
endTimestamp
Description copied from interface:TaskQuery.IGroupByQueryColumns
Groups the result of the query by the field
EndTimestamp
.SQL part:
GROUP BY EndTimestamp
- Specified by:
endTimestamp
in interfaceTaskQuery.IGroupByQueryColumns
- Returns:
- query for further composition
- API:
- This public API is available in IvyScript and Java. It has the visibility EXPERT.
-
businessCalendar
Description copied from interface:TaskQuery.IGroupByQueryColumns
Groups the result of the query by the field
BusinessCalendar
.SQL part:
GROUP BY BusinessCalendar
- Specified by:
businessCalendar
in interfaceTaskQuery.IGroupByQueryColumns
- Returns:
- query for further composition
- API:
- This public API is available in IvyScript and Java. It has the visibility EXPERT.
-
workingTime
Description copied from interface:TaskQuery.IGroupByQueryColumns
Groups the result of the query by the field
WorkingTime
.SQL part:
GROUP BY WorkingTime
- Specified by:
workingTime
in interfaceTaskQuery.IGroupByQueryColumns
- Returns:
- query for further composition
- API:
- This public API is available in IvyScript and Java. It has the visibility EXPERT.
-
businessRuntime
Description copied from interface:TaskQuery.IGroupByQueryColumns
Groups the result of the query by the field
BusinessRuntime
.SQL part:
GROUP BY BusinessRuntime
- Specified by:
businessRuntime
in interfaceTaskQuery.IGroupByQueryColumns
- Returns:
- query for further composition
- API:
- This public API is available in IvyScript and Java. It has the visibility EXPERT.
-
failedTimeoutTimestamp
Description copied from interface:TaskQuery.IGroupByQueryColumns
Groups the result of the query by the field
FailedTimeoutTimestamp
.SQL part:
GROUP BY FailedTimeoutTimestamp
- Specified by:
failedTimeoutTimestamp
in interfaceTaskQuery.IGroupByQueryColumns
- Returns:
- query for further composition
- See Also:
- API:
- This public API is available in IvyScript and Java. It has the visibility EXPERT.
-
numberOfFailures
Description copied from interface:TaskQuery.IGroupByQueryColumns
Groups the result of the query by the field
NumberOfFailures
.SQL part:
GROUP BY NumberOfFailures
- Specified by:
numberOfFailures
in interfaceTaskQuery.IGroupByQueryColumns
- Returns:
- query for further composition
- API:
- This public API is available in IvyScript and Java. It has the visibility EXPERT.
-
numberOfResumes
Description copied from interface:TaskQuery.IGroupByQueryColumns
Groups the result of the query by the field
NumberOfResumes
.SQL part:
GROUP BY NumberOfResumes
- Specified by:
numberOfResumes
in interfaceTaskQuery.IGroupByQueryColumns
- Returns:
- query for further composition
- API:
- This public API is available in IvyScript and Java. It has the visibility EXPERT.
-
category
Description copied from interface:TaskQuery.IGroupByQueryColumns
Groups the result of the query by the field
Category
.SQL part:
GROUP BY Category
- Specified by:
category
in interfaceTaskQuery.IGroupByQueryColumns
- Returns:
- query for further composition
- API:
- This public API is available in IvyScript and Java. It has the visibility EXPERT.
-
isUpdatedOnStart
Description copied from interface:TaskQuery.IGroupByQueryColumns
Groups the result of the query by the field
IsUpdatedOnStart
.SQL part:
GROUP BY IsUpdatedOnStart
- Specified by:
isUpdatedOnStart
in interfaceTaskQuery.IGroupByQueryColumns
- Returns:
- query for further composition
- API:
- This public API is available in IvyScript and Java. It has the visibility EXPERT.
-
isOffline
Description copied from interface:TaskQuery.IGroupByQueryColumns
Groups the result of the query by the field
IsOffline
.SQL part:
GROUP BY IsOffline
- Specified by:
isOffline
in interfaceTaskQuery.IGroupByQueryColumns
- Returns:
- query for further composition
- API:
- This public API is available in IvyScript and Java. It has the visibility EXPERT.
-
activatorName
Description copied from interface:TaskQuery.IGroupByQueryColumns
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
.- Specified by:
activatorName
in interfaceTaskQuery.IGroupByQueryColumns
- Returns:
- query for further composition
- API:
- This public API is available in IvyScript and Java. It has the visibility EXPERT.
-
activatorDisplayName
Description copied from interface:TaskQuery.IGroupByQueryColumns
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
.- Specified by:
activatorDisplayName
in interfaceTaskQuery.IGroupByQueryColumns
- Returns:
- query for further composition
- API:
- This public API is available in IvyScript and Java. It has the visibility EXPERT.
-
languageId
Description copied from interface:TaskQuery.IGroupByQueryColumns
Groups the result of the query by the field
LanguageId
.SQL part:
GROUP BY LanguageId
This is a virtual column. It contains the same value as the column
LanguageId
of the referencedTaskLocalized
.- Specified by:
languageId
in interfaceTaskQuery.IGroupByQueryColumns
- Returns:
- query for further composition
- API:
- This public API is available in IvyScript and Java. It has the visibility EXPERT.
-
customField
Description copied from interface:TaskQuery.IGroupByQueryColumns
Groups the result of the query by a custom field specified during further composition.
- Specified by:
customField
in interfaceTaskQuery.IGroupByQueryColumns
- Returns:
- query for further composition
- API:
- This public API is available in IvyScript and Java. It has the visibility EXPERT.
-