Class CaseQuery.GroupByQuery
- java.lang.Object
-
- ch.ivyteam.ivy.persistence.query.Query<ICase>
-
- ch.ivyteam.ivy.workflow.query.CaseQuery
-
- ch.ivyteam.ivy.workflow.query.CaseQuery.GroupByQuery
-
- All Implemented Interfaces:
CaseQuery.IGroupByQueryColumns
- Enclosing class:
- CaseQuery
public static class CaseQuery.GroupByQuery extends CaseQuery implements 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.
-
-
Nested Class Summary
-
Nested classes/interfaces inherited from class ch.ivyteam.ivy.workflow.query.CaseQuery
CaseQuery.AggregationQuery, CaseQuery.FilterLink, CaseQuery.FilterQuery, CaseQuery.GroupByQuery, CaseQuery.IAggregationQuery, CaseQuery.ICaseStateFilterQuery, CaseQuery.IClobColumnFilterQuery, CaseQuery.IColumnFilterQuery, CaseQuery.ICustomFieldAggregationQuery, CaseQuery.ICustomFieldFilterQuery, CaseQuery.ICustomFieldGroupBy, CaseQuery.ICustomFieldOrderBy, CaseQuery.IDateColumnFilterQuery, CaseQuery.IFilterableColumns, CaseQuery.IFilterLink, CaseQuery.IFilterQuery, CaseQuery.IGroupByQueryColumns, CaseQuery.IIntegerColumnFilterQuery, CaseQuery.INumberColumnFilterQuery, CaseQuery.IOrderByQueryColumns, CaseQuery.IPatternColumnFilterQuery, CaseQuery.IStringColumnFilterQuery, CaseQuery.IWorkflowPriorityFilterQuery, CaseQuery.OrderByColumnQuery, CaseQuery.OrderByQuery
-
-
Method Summary
All Methods Instance Methods Concrete 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
public CaseQuery.GroupByQuery caseId()
Description copied from interface:CaseQuery.IGroupByQueryColumns
Groups the result of the query by the field
CaseId
.SQL part:
GROUP BY CaseId
- Specified by:
caseId
in interfaceCaseQuery.IGroupByQueryColumns
- Returns:
- query for further composition
- See Also:
CaseQuery.IGroupByQueryColumns.caseId()
- API:
- This public API is available in IvyScript and Java. It has the visibility EXPERT.
-
businessCaseId
public CaseQuery.GroupByQuery businessCaseId()
Description copied from interface:CaseQuery.IGroupByQueryColumns
Groups the result of the query by the field
BusinessCaseId
.SQL part:
GROUP BY BusinessCaseId
- Specified by:
businessCaseId
in interfaceCaseQuery.IGroupByQueryColumns
- Returns:
- query for further composition
- See Also:
CaseQuery.IGroupByQueryColumns.businessCaseId()
- API:
- This public API is available in IvyScript and Java. It has the visibility EXPERT.
-
applicationId
public CaseQuery.GroupByQuery applicationId()
Description copied from interface:CaseQuery.IGroupByQueryColumns
Groups the result of the query by the field
ApplicationId
.SQL part:
GROUP BY ApplicationId
- Specified by:
applicationId
in interfaceCaseQuery.IGroupByQueryColumns
- Returns:
- query for further composition
- See Also:
CaseQuery.IGroupByQueryColumns.applicationId()
- API:
- This public API is available in IvyScript and Java. It has the visibility EXPERT.
-
processModelId
public CaseQuery.GroupByQuery processModelId()
Description copied from interface:CaseQuery.IGroupByQueryColumns
Groups the result of the query by the field
ProcessModelId
.SQL part:
GROUP BY ProcessModelId
- Specified by:
processModelId
in interfaceCaseQuery.IGroupByQueryColumns
- Returns:
- query for further composition
- See Also:
CaseQuery.IGroupByQueryColumns.processModelId()
- API:
- This public API is available in IvyScript and Java. It has the visibility EXPERT.
-
taskStartId
public CaseQuery.GroupByQuery taskStartId()
Description copied from interface:CaseQuery.IGroupByQueryColumns
Groups the result of the query by the field
TaskStartId
.SQL part:
GROUP BY TaskStartId
- Specified by:
taskStartId
in interfaceCaseQuery.IGroupByQueryColumns
- Returns:
- query for further composition
- See Also:
CaseQuery.IGroupByQueryColumns.taskStartId()
- API:
- This public API is available in IvyScript and Java. It has the visibility EXPERT.
-
creatorUserId
public CaseQuery.GroupByQuery creatorUserId()
Description copied from interface:CaseQuery.IGroupByQueryColumns
Groups the result of the query by the field
CreatorUserId
.SQL part:
GROUP BY CreatorUserId
- Specified by:
creatorUserId
in interfaceCaseQuery.IGroupByQueryColumns
- Returns:
- query for further composition
- See Also:
CaseQuery.IGroupByQueryColumns.creatorUserId()
- API:
- This public API is available in IvyScript and Java. It has the visibility EXPERT.
-
creatorUserName
public CaseQuery.GroupByQuery creatorUserName()
Description copied from interface:CaseQuery.IGroupByQueryColumns
Groups the result of the query by the field
CreatorUserName
.SQL part:
GROUP BY CreatorUserName
- Specified by:
creatorUserName
in interfaceCaseQuery.IGroupByQueryColumns
- Returns:
- query for further composition
- See Also:
CaseQuery.IGroupByQueryColumns.creatorUserName()
- API:
- This public API is available in IvyScript and Java. It has the visibility EXPERT.
-
creatorUserDisplayName
public CaseQuery.GroupByQuery creatorUserDisplayName()
Description copied from interface:CaseQuery.IGroupByQueryColumns
Groups the result of the query by the field
CreatorUserDisplayName
.SQL part:
GROUP BY CreatorUserDisplayName
- Specified by:
creatorUserDisplayName
in interfaceCaseQuery.IGroupByQueryColumns
- Returns:
- query for further composition
- See Also:
CaseQuery.IGroupByQueryColumns.creatorUserDisplayName()
- API:
- This public API is available in IvyScript and Java. It has the visibility EXPERT.
-
creatorTaskId
public CaseQuery.GroupByQuery creatorTaskId()
Description copied from interface:CaseQuery.IGroupByQueryColumns
Groups the result of the query by the field
CreatorTaskId
.SQL part:
GROUP BY CreatorTaskId
- Specified by:
creatorTaskId
in interfaceCaseQuery.IGroupByQueryColumns
- Returns:
- query for further composition
- See Also:
CaseQuery.IGroupByQueryColumns.creatorTaskId()
- API:
- This public API is available in IvyScript and Java. It has the visibility EXPERT.
-
environmentId
public CaseQuery.GroupByQuery environmentId()
Description copied from interface:CaseQuery.IGroupByQueryColumns
Groups the result of the query by the field
EnvironmentId
.SQL part:
GROUP BY EnvironmentId
- Specified by:
environmentId
in interfaceCaseQuery.IGroupByQueryColumns
- Returns:
- query for further composition
- See Also:
CaseQuery.IGroupByQueryColumns.environmentId()
- API:
- This public API is available in IvyScript and Java. It has the visibility EXPERT.
-
displayNameTemplate
public CaseQuery.GroupByQuery displayNameTemplate()
Description copied from interface:CaseQuery.IGroupByQueryColumns
Groups the result of the query by the field
DisplayNameTemplate
.SQL part:
GROUP BY DisplayNameTemplate
- Specified by:
displayNameTemplate
in interfaceCaseQuery.IGroupByQueryColumns
- Returns:
- query for further composition
- See Also:
CaseQuery.IGroupByQueryColumns.displayNameTemplate()
- API:
- This public API is available in IvyScript and Java. It has the visibility EXPERT.
-
name
public CaseQuery.GroupByQuery name()
Description copied from interface:CaseQuery.IGroupByQueryColumns
Groups the result of the query by the field
Name
.SQL part:
GROUP BY Name
- Specified by:
name
in interfaceCaseQuery.IGroupByQueryColumns
- Returns:
- query for further composition
- See Also:
CaseQuery.IGroupByQueryColumns.name()
- API:
- This public API is available in IvyScript and Java. It has the visibility EXPERT.
-
displayDescriptionTemplate
public CaseQuery.GroupByQuery displayDescriptionTemplate()
Description copied from interface:CaseQuery.IGroupByQueryColumns
Groups the result of the query by the field
DisplayDescriptionTemplate
.SQL part:
GROUP BY DisplayDescriptionTemplate
- Specified by:
displayDescriptionTemplate
in interfaceCaseQuery.IGroupByQueryColumns
- Returns:
- query for further composition
- See Also:
CaseQuery.IGroupByQueryColumns.displayDescriptionTemplate()
- API:
- This public API is available in IvyScript and Java. It has the visibility EXPERT.
-
description
public CaseQuery.GroupByQuery description()
Description copied from interface:CaseQuery.IGroupByQueryColumns
Groups the result of the query by the field
Description
.SQL part:
GROUP BY Description
- Specified by:
description
in interfaceCaseQuery.IGroupByQueryColumns
- Returns:
- query for further composition
- See Also:
CaseQuery.IGroupByQueryColumns.description()
- API:
- This public API is available in IvyScript and Java. It has the visibility EXPERT.
-
startTimestamp
public CaseQuery.GroupByQuery startTimestamp()
Description copied from interface:CaseQuery.IGroupByQueryColumns
Groups the result of the query by the field
StartTimestamp
.SQL part:
GROUP BY StartTimestamp
- Specified by:
startTimestamp
in interfaceCaseQuery.IGroupByQueryColumns
- Returns:
- query for further composition
- See Also:
CaseQuery.IGroupByQueryColumns.startTimestamp()
- API:
- This public API is available in IvyScript and Java. It has the visibility EXPERT.
-
endTimestamp
public CaseQuery.GroupByQuery endTimestamp()
Description copied from interface:CaseQuery.IGroupByQueryColumns
Groups the result of the query by the field
EndTimestamp
.SQL part:
GROUP BY EndTimestamp
- Specified by:
endTimestamp
in interfaceCaseQuery.IGroupByQueryColumns
- Returns:
- query for further composition
- See Also:
CaseQuery.IGroupByQueryColumns.endTimestamp()
- API:
- This public API is available in IvyScript and Java. It has the visibility EXPERT.
-
businessCalendar
public CaseQuery.GroupByQuery businessCalendar()
Description copied from interface:CaseQuery.IGroupByQueryColumns
Groups the result of the query by the field
BusinessCalendar
.SQL part:
GROUP BY BusinessCalendar
- Specified by:
businessCalendar
in interfaceCaseQuery.IGroupByQueryColumns
- Returns:
- query for further composition
- See Also:
CaseQuery.IGroupByQueryColumns.businessCalendar()
- API:
- This public API is available in IvyScript and Java. It has the visibility EXPERT.
-
workingTime
public CaseQuery.GroupByQuery workingTime()
Description copied from interface:CaseQuery.IGroupByQueryColumns
Groups the result of the query by the field
WorkingTime
.SQL part:
GROUP BY WorkingTime
- Specified by:
workingTime
in interfaceCaseQuery.IGroupByQueryColumns
- Returns:
- query for further composition
- See Also:
CaseQuery.IGroupByQueryColumns.workingTime()
- API:
- This public API is available in IvyScript and Java. It has the visibility EXPERT.
-
businessRuntime
public CaseQuery.GroupByQuery businessRuntime()
Description copied from interface:CaseQuery.IGroupByQueryColumns
Groups the result of the query by the field
BusinessRuntime
.SQL part:
GROUP BY BusinessRuntime
- Specified by:
businessRuntime
in interfaceCaseQuery.IGroupByQueryColumns
- Returns:
- query for further composition
- See Also:
CaseQuery.IGroupByQueryColumns.businessRuntime()
- API:
- This public API is available in IvyScript and Java. It has the visibility EXPERT.
-
state
public CaseQuery.GroupByQuery state()
Description copied from interface:CaseQuery.IGroupByQueryColumns
Groups the result of the query by the field
State
.SQL part:
GROUP BY State
- Specified by:
state
in interfaceCaseQuery.IGroupByQueryColumns
- Returns:
- query for further composition
- See Also:
CaseQuery.IGroupByQueryColumns.state()
- API:
- This public API is available in IvyScript and Java. It has the visibility EXPERT.
-
priority
public CaseQuery.GroupByQuery priority()
Description copied from interface:CaseQuery.IGroupByQueryColumns
Groups the result of the query by the field
Priority
.SQL part:
GROUP BY Priority
- Specified by:
priority
in interfaceCaseQuery.IGroupByQueryColumns
- Returns:
- query for further composition
- See Also:
CaseQuery.IGroupByQueryColumns.priority()
- API:
- This public API is available in IvyScript and Java. It has the visibility EXPERT.
-
stage
public CaseQuery.GroupByQuery stage()
Description copied from interface:CaseQuery.IGroupByQueryColumns
Groups the result of the query by the field
Stage
.SQL part:
GROUP BY Stage
- Specified by:
stage
in interfaceCaseQuery.IGroupByQueryColumns
- Returns:
- query for further composition
- See Also:
CaseQuery.IGroupByQueryColumns.stage()
- API:
- This public API is available in IvyScript and Java. It has the visibility EXPERT.
-
ownerRoleId
public CaseQuery.GroupByQuery ownerRoleId()
Description copied from interface:CaseQuery.IGroupByQueryColumns
Groups the result of the query by the field
OwnerRoleId
.SQL part:
GROUP BY OwnerRoleId
- Specified by:
ownerRoleId
in interfaceCaseQuery.IGroupByQueryColumns
- Returns:
- query for further composition
- See Also:
CaseQuery.IGroupByQueryColumns.ownerRoleId()
- API:
- This public API is available in IvyScript and Java. It has the visibility EXPERT.
-
ownerUserId
public CaseQuery.GroupByQuery ownerUserId()
Description copied from interface:CaseQuery.IGroupByQueryColumns
Groups the result of the query by the field
OwnerUserId
.SQL part:
GROUP BY OwnerUserId
- Specified by:
ownerUserId
in interfaceCaseQuery.IGroupByQueryColumns
- Returns:
- query for further composition
- See Also:
CaseQuery.IGroupByQueryColumns.ownerUserId()
- API:
- This public API is available in IvyScript and Java. It has the visibility EXPERT.
-
ownerName
public CaseQuery.GroupByQuery ownerName()
Description copied from interface:CaseQuery.IGroupByQueryColumns
Groups the result of the query by the field
OwnerName
.SQL part:
GROUP BY OwnerName
- Specified by:
ownerName
in interfaceCaseQuery.IGroupByQueryColumns
- Returns:
- query for further composition
- See Also:
CaseQuery.IGroupByQueryColumns.ownerName()
- API:
- This public API is available in IvyScript and Java. It has the visibility EXPERT.
-
category
public CaseQuery.GroupByQuery category()
Description copied from interface:CaseQuery.IGroupByQueryColumns
Groups the result of the query by the field
Category
.SQL part:
GROUP BY Category
- Specified by:
category
in interfaceCaseQuery.IGroupByQueryColumns
- Returns:
- query for further composition
- See Also:
CaseQuery.IGroupByQueryColumns.category()
- API:
- This public API is available in IvyScript and Java. It has the visibility EXPERT.
-
customField
public CaseQuery.ICustomFieldGroupBy customField()
Description copied from interface:CaseQuery.IGroupByQueryColumns
Groups the result of the query by a custom field specified during further composition.
- Specified by:
customField
in interfaceCaseQuery.IGroupByQueryColumns
- Returns:
- query for further composition
- API:
- This public API is available in IvyScript and Java. It has the visibility EXPERT.
-
-