Interface CaseQuery.IGroupByQueryColumns
-
- All Known Implementing Classes:
CaseQuery.GroupByQuery
- Enclosing class:
- CaseQuery
public static interface CaseQuery.IGroupByQueryColumns
Provides methods to group the result by certain fields.Example:
Corresponds to SQL:CaseQuery.businessCases().groupBy().ownerRoleId().ownerName().aggregate().countRows();
SELECT OwnerRoleId, OwnerUserId, Count(*) AS Count FROM IWA_Case GROUP BY OwnerRoleId, OwnerUserId
- API:
- This is a public API.
-
-
Method Summary
All Methods Instance Methods Abstract Methods Modifier and Type Method Description CaseQuery.GroupByQuery
activatorId()
Groups the result of the query by the fieldActivatorId
.CaseQuery.GroupByQuery
applicationId()
Groups the result of the query by the fieldApplicationId
.CaseQuery.GroupByQuery
businessCalendar()
Groups the result of the query by the fieldBusinessCalendar
.CaseQuery.GroupByQuery
businessCaseId()
Groups the result of the query by the fieldBusinessCaseId
.CaseQuery.GroupByQuery
businessRuntime()
Groups the result of the query by the fieldBusinessRuntime
.CaseQuery.GroupByQuery
caseId()
Groups the result of the query by the fieldCaseId
.CaseQuery.GroupByQuery
category()
Groups the result of the query by the fieldCategory
.CaseQuery.GroupByQuery
creatorId()
Groups the result of the query by the fieldCreatorId
.CaseQuery.GroupByQuery
creatorTaskId()
Groups the result of the query by the fieldCreatorTaskId
.CaseQuery.GroupByQuery
creatorUserDisplayName()
Groups the result of the query by the fieldCreatorUserDisplayName
.CaseQuery.GroupByQuery
creatorUserName()
Groups the result of the query by the fieldCreatorUserName
.CaseQuery.ICustomFieldGroupBy
customField()
Groups the result of the query by a custom field specified during further composition.CaseQuery.GroupByQuery
description()
Groups the result of the query by the fieldDescription
.CaseQuery.GroupByQuery
displayDescriptionTemplate()
Groups the result of the query by the fieldDisplayDescriptionTemplate
.CaseQuery.GroupByQuery
displayNameTemplate()
Groups the result of the query by the fieldDisplayNameTemplate
.CaseQuery.GroupByQuery
endTimestamp()
Groups the result of the query by the fieldEndTimestamp
.CaseQuery.GroupByQuery
environmentId()
Groups the result of the query by the fieldEnvironmentId
.CaseQuery.GroupByQuery
name()
Groups the result of the query by the fieldName
.CaseQuery.GroupByQuery
ownerDisplayName()
Groups the result of the query by the fieldOwnerDisplayName
.CaseQuery.GroupByQuery
ownerId()
Groups the result of the query by the fieldOwnerId
.CaseQuery.GroupByQuery
ownerName()
Groups the result of the query by the fieldOwnerName
.CaseQuery.GroupByQuery
priority()
Groups the result of the query by the fieldPriority
.CaseQuery.GroupByQuery
processModelId()
Groups the result of the query by the fieldProcessModelId
.CaseQuery.GroupByQuery
stage()
Groups the result of the query by the fieldStage
.CaseQuery.GroupByQuery
startTimestamp()
Groups the result of the query by the fieldStartTimestamp
.CaseQuery.GroupByQuery
state()
Groups the result of the query by the fieldState
.CaseQuery.GroupByQuery
taskStartId()
Groups the result of the query by the fieldTaskStartId
.CaseQuery.GroupByQuery
workingTime()
Groups the result of the query by the fieldWorkingTime
.
-
-
-
Method Detail
-
caseId
CaseQuery.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
CaseQuery.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.
-
applicationId
CaseQuery.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.
-
processModelId
CaseQuery.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.
-
taskStartId
CaseQuery.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.
-
activatorId
CaseQuery.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.
-
creatorId
CaseQuery.GroupByQuery creatorId()
Groups the result of the query by the field
CreatorId
.SQL part:
GROUP BY CreatorId
- Returns:
- query for further composition
- API:
- This public API is available in IvyScript and Java. It has the visibility EXPERT.
-
creatorUserName
CaseQuery.GroupByQuery creatorUserName()
Groups the result of the query by the field
CreatorUserName
.SQL part:
GROUP BY CreatorUserName
This is a virtual column. It contains the same value as the column
Name
of the referencedCreator
.- Returns:
- query for further composition
- API:
- This public API is available in IvyScript and Java. It has the visibility EXPERT.
-
creatorUserDisplayName
CaseQuery.GroupByQuery creatorUserDisplayName()
Groups the result of the query by the field
CreatorUserDisplayName
.SQL part:
GROUP BY CreatorUserDisplayName
This is a virtual column. It contains the same value as the column
DisplayName
of the referencedCreator
.- Returns:
- query for further composition
- API:
- This public API is available in IvyScript and Java. It has the visibility EXPERT.
-
creatorTaskId
CaseQuery.GroupByQuery creatorTaskId()
Groups the result of the query by the field
CreatorTaskId
.SQL part:
GROUP BY CreatorTaskId
- Returns:
- query for further composition
- API:
- This public API is available in IvyScript and Java. It has the visibility EXPERT.
-
environmentId
CaseQuery.GroupByQuery environmentId()
Groups the result of the query by the field
EnvironmentId
.SQL part:
GROUP BY EnvironmentId
- Returns:
- query for further composition
- API:
- This public API is available in IvyScript and Java. It has the visibility EXPERT.
-
displayNameTemplate
CaseQuery.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
CaseQuery.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
CaseQuery.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
CaseQuery.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.
-
startTimestamp
CaseQuery.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
CaseQuery.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
CaseQuery.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
CaseQuery.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
CaseQuery.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.
-
state
CaseQuery.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.
-
priority
CaseQuery.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.
-
stage
CaseQuery.GroupByQuery stage()
Groups the result of the query by the field
Stage
.SQL part:
GROUP BY Stage
- Returns:
- query for further composition
- API:
- This public API is available in IvyScript and Java. It has the visibility EXPERT.
-
ownerId
CaseQuery.GroupByQuery ownerId()
Groups the result of the query by the field
OwnerId
.SQL part:
GROUP BY OwnerId
- Returns:
- query for further composition
- API:
- This public API is available in IvyScript and Java. It has the visibility EXPERT.
-
ownerName
CaseQuery.GroupByQuery ownerName()
Groups the result of the query by the field
OwnerName
.SQL part:
GROUP BY OwnerName
This is a virtual column. It contains the same value as the column
MemberName
of the referencedOwner
.- Returns:
- query for further composition
- API:
- This public API is available in IvyScript and Java. It has the visibility EXPERT.
-
ownerDisplayName
CaseQuery.GroupByQuery ownerDisplayName()
Groups the result of the query by the field
OwnerDisplayName
.SQL part:
GROUP BY OwnerDisplayName
This is a virtual column. It contains the same value as the column
DisplayName
of the referencedOwner
.- Returns:
- query for further composition
- API:
- This public API is available in IvyScript and Java. It has the visibility EXPERT.
-
category
CaseQuery.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.
-
customField
CaseQuery.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.
-
-