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
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
creatorTaskId()
Groups the result of the query by the fieldCreatorTaskId
.CaseQuery.GroupByQuery
creatorUserDisplayName()
Groups the result of the query by the fieldCreatorUserDisplayName
.CaseQuery.GroupByQuery
creatorUserId()
Groups the result of the query by the fieldCreatorUserId
.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
ownerName()
Groups the result of the query by the fieldOwnerName
.CaseQuery.GroupByQuery
ownerRoleId()
Groups the result of the query by the fieldOwnerRoleId
.CaseQuery.GroupByQuery
ownerUserId()
Groups the result of the query by the fieldOwnerUserId
.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.
-
creatorUserId
CaseQuery.GroupByQuery creatorUserId()
Groups the result of the query by the field
CreatorUserId
.SQL part:
GROUP BY CreatorUserId
- 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
- 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
- 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.
-
ownerRoleId
CaseQuery.GroupByQuery ownerRoleId()
Groups the result of the query by the field
OwnerRoleId
.SQL part:
GROUP BY OwnerRoleId
- Returns:
- query for further composition
- API:
- This public API is available in IvyScript and Java. It has the visibility EXPERT.
-
ownerUserId
CaseQuery.GroupByQuery ownerUserId()
Groups the result of the query by the field
OwnerUserId
.SQL part:
GROUP BY OwnerUserId
- 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
- 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.
-
-