Class CaseQuery.OrderByQuery
- All Implemented Interfaces:
CaseQuery.IOrderByQueryColumns
- Direct Known Subclasses:
CaseQuery.OrderByColumnQuery
- Enclosing class:
CaseQuery
ICase.
Example:
Corresponds to SQL:
CaseQuery.businessCases()
.orderBy()
.ownerUserId()
.startTimestamp().descending();SELECT * FROM IWA_Case
ORDER BY
OwnerUserId ASC,
StartTimestamp DESC
- API:
- This is a public API.
-
Nested Class Summary
Nested classes/interfaces inherited from class ch.ivyteam.ivy.workflow.query.CaseQuery
CaseQuery.AggregationQuery, CaseQuery.EnumValueOrderByColumnQuery<T extends ch.ivyteam.ivy.persistence.IPersistentEnumeration>, CaseQuery.FilterLink, CaseQuery.FilterQuery, CaseQuery.GroupByQuery, CaseQuery.IAggregationQuery, CaseQuery.IBoolFilterQuery, CaseQuery.ICaseBusinessStateFilterQuery, 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.IUUIDColumnFilterQuery, CaseQuery.IWorkflowPriorityFilterQuery, CaseQuery.LongValueOrderByColumnQuery, CaseQuery.OrderByColumnQuery, CaseQuery.OrderByQuery, CaseQuery.StringValueOrderByColumnQuery -
Method Summary
Modifier and TypeMethodDescriptionAdds an order by statement for the columnActivatorIdin the default direction ascending.
To change the order to descending useactivatorId().descending()Adds an order by statement for the columnApplicationIdin the default direction ascending.
To change the order to descending useapplicationId().descending()Adds an order by statement for the columnBusinessCalendarin the default direction ascending.
To change the order to descending usebusinessCalendar().descending()Deprecated.Adds an order by statement for the columnBusinessCaseIdin the default direction ascending.
To change the order to descending usebusinessCaseId().descending()Adds an order by statement for the columnBusinessRuntimein the default direction ascending.
To change the order to descending usebusinessRuntime().descending()Adds an order by statement for the columnBusinessStatein the default direction ascending.
To change the order to descending usebusinessState().descending()caseId()Adds an order by statement for the columnCaseIdin the default direction ascending.
To change the order to descending usecaseId().descending()category()Adds an order by statement for the columnCategoryin the default direction ascending.
To change the order to descending usecategory().descending()Adds an order by statement for the columnCreatorIdin the default direction ascending.
To change the order to descending usecreatorId().descending()Adds an order by statement for the columnCreatorTaskIdin the default direction ascending.
To change the order to descending usecreatorTaskId().descending()Adds an order by statement for the columnCreatorUserDisplayNamein the default direction ascending.
To change the order to descending usecreatorUserDisplayName().descending()Adds an order by statement for the columnCreatorUserNamein the default direction ascending.
To change the order to descending usecreatorUserName().descending()Adds an order by statement for a custom field in the default direction ascending.
To change the order to descending usecustomField().descending()Deprecated.Deprecated, for removal: This API element is subject to removal in a future version.Deprecated, for removal: This API element is subject to removal in a future version.Adds an order by statement for the columnEndTimestampin the default direction ascending.
To change the order to descending useendTimestamp().descending()Adds an order by statement for the columnLanguageIdin the default direction ascending.
To change the order to descending uselanguageId().descending()name()Adds an order by statement for the columnNamein the default direction ascending.
To change the order to descending usename().descending()ownerId()priority()Adds an order by statement for the columnPriorityin the default direction ascending.
To change the order to descending usepriority().descending()Adds an order by statement for the columnProcessModelIdin the default direction ascending.
To change the order to descending useprocessModelId().descending()Adds an order by statement for the columnSecuritySystemIdin the default direction ascending.
To change the order to descending usesecuritySystemId().descending()stage()Adds an order by statement for the columnStagein the default direction ascending.
To change the order to descending usestage().descending()Adds an order by statement for the columnStartTimestampin the default direction ascending.
To change the order to descending usestartTimestamp().descending()state()Adds an order by statement for the columnStatein the default direction ascending.
To change the order to descending usestate().descending()Adds an order by statement for the columnTaskStartIdin the default direction ascending.
To change the order to descending usetaskStartId().descending()Adds an order by statement for the columnWorkingTimein the default direction ascending.
To change the order to descending useworkingTime().descending()
-
Method Details
-
caseId
Description copied from interface:CaseQuery.IOrderByQueryColumnsAdds an order by statement for the column
CaseIdin the default direction ascending.
To change the order to descending usecaseId().descending()Example:
CaseQuery.businessCases().orderBy().caseId()
SQL part:
ORDER BY CaseId ASC- Specified by:
caseIdin interfaceCaseQuery.IOrderByQueryColumns- Returns:
- query for further composition
- See Also:
- API:
- This public API is available in Java.
-
businessCaseId
Description copied from interface:CaseQuery.IOrderByQueryColumnsAdds an order by statement for the column
BusinessCaseIdin the default direction ascending.
To change the order to descending usebusinessCaseId().descending()Example:
CaseQuery.businessCases().orderBy().businessCaseId()
SQL part:
ORDER BY BusinessCaseId ASC- Specified by:
businessCaseIdin interfaceCaseQuery.IOrderByQueryColumns- Returns:
- query for further composition
- See Also:
- API:
- This public API is available in Java.
-
securitySystemId
Description copied from interface:CaseQuery.IOrderByQueryColumnsAdds an order by statement for the column
SecuritySystemIdin the default direction ascending.
To change the order to descending usesecuritySystemId().descending()Example:
CaseQuery.businessCases().orderBy().securitySystemId()
SQL part:
ORDER BY SecuritySystemId ASC- Specified by:
securitySystemIdin interfaceCaseQuery.IOrderByQueryColumns- Returns:
- query for further composition
- See Also:
- API:
- This public API is available in Java.
-
applicationId
Description copied from interface:CaseQuery.IOrderByQueryColumnsAdds an order by statement for the column
ApplicationIdin the default direction ascending.
To change the order to descending useapplicationId().descending()Example:
CaseQuery.businessCases().orderBy().applicationId()
SQL part:
ORDER BY ApplicationId ASC- Specified by:
applicationIdin interfaceCaseQuery.IOrderByQueryColumns- Returns:
- query for further composition
- See Also:
- API:
- This public API is available in Java.
-
processModelId
Description copied from interface:CaseQuery.IOrderByQueryColumnsAdds an order by statement for the column
ProcessModelIdin the default direction ascending.
To change the order to descending useprocessModelId().descending()Example:
CaseQuery.businessCases().orderBy().processModelId()
SQL part:
ORDER BY ProcessModelId ASC- Specified by:
processModelIdin interfaceCaseQuery.IOrderByQueryColumns- Returns:
- query for further composition
- See Also:
- API:
- This public API is available in Java.
-
taskStartId
Description copied from interface:CaseQuery.IOrderByQueryColumnsAdds an order by statement for the column
TaskStartIdin the default direction ascending.
To change the order to descending usetaskStartId().descending()Example:
CaseQuery.businessCases().orderBy().taskStartId()
SQL part:
ORDER BY TaskStartId ASC- Specified by:
taskStartIdin interfaceCaseQuery.IOrderByQueryColumns- Returns:
- query for further composition
- See Also:
- API:
- This public API is available in Java.
-
activatorId
Description copied from interface:CaseQuery.IOrderByQueryColumnsAdds an order by statement for the column
ActivatorIdin the default direction ascending.
To change the order to descending useactivatorId().descending()Example:
CaseQuery.businessCases().orderBy().activatorId()
SQL part:
ORDER BY ActivatorId ASC- Specified by:
activatorIdin interfaceCaseQuery.IOrderByQueryColumns- Returns:
- query for further composition
- See Also:
- API:
- This public API is available in Java.
-
creatorId
Description copied from interface:CaseQuery.IOrderByQueryColumnsAdds an order by statement for the column
CreatorIdin the default direction ascending.
To change the order to descending usecreatorId().descending()Example:
CaseQuery.businessCases().orderBy().creatorId()
SQL part:
ORDER BY CreatorId ASC- Specified by:
creatorIdin interfaceCaseQuery.IOrderByQueryColumns- Returns:
- query for further composition
- See Also:
- API:
- This public API is available in Java.
-
creatorUserName
Description copied from interface:CaseQuery.IOrderByQueryColumnsAdds an order by statement for the column
CreatorUserNamein the default direction ascending.
To change the order to descending usecreatorUserName().descending()Example:
CaseQuery.businessCases().orderBy().creatorUserName()
SQL part:
ORDER BY CreatorUserName ASCThis is a virtual column. It contains the same value as the column
Nameof the referencedCreator.- Specified by:
creatorUserNamein interfaceCaseQuery.IOrderByQueryColumns- Returns:
- query for further composition
- See Also:
- API:
- This public API is available in Java.
-
creatorUserDisplayName
Description copied from interface:CaseQuery.IOrderByQueryColumnsAdds an order by statement for the column
CreatorUserDisplayNamein the default direction ascending.
To change the order to descending usecreatorUserDisplayName().descending()Example:
CaseQuery.businessCases().orderBy().creatorUserDisplayName()
SQL part:
ORDER BY CreatorUserDisplayName ASCThis is a virtual column. It contains the same value as the column
DisplayNameof the referencedCreator.- Specified by:
creatorUserDisplayNamein interfaceCaseQuery.IOrderByQueryColumns- Returns:
- query for further composition
- See Also:
- API:
- This public API is available in Java.
-
creatorTaskId
Description copied from interface:CaseQuery.IOrderByQueryColumnsAdds an order by statement for the column
CreatorTaskIdin the default direction ascending.
To change the order to descending usecreatorTaskId().descending()Example:
CaseQuery.businessCases().orderBy().creatorTaskId()
SQL part:
ORDER BY CreatorTaskId ASC- Specified by:
creatorTaskIdin interfaceCaseQuery.IOrderByQueryColumns- Returns:
- query for further composition
- See Also:
- API:
- This public API is available in Java.
-
name
Description copied from interface:CaseQuery.IOrderByQueryColumnsAdds an order by statement for the column
Namein the default direction ascending.
To change the order to descending usename().descending()Example:
CaseQuery.businessCases().orderBy().name()
SQL part:
ORDER BY Name ASCThis is a virtual column. It contains the same value as the column
Nameof the referencedCaseLocalized.- Specified by:
namein interfaceCaseQuery.IOrderByQueryColumns- Returns:
- query for further composition
- See Also:
- API:
- This public API is available in Java.
-
description
Deprecated.Description copied from interface:CaseQuery.IOrderByQueryColumnsAdds an order by statement for the column
Descriptionin the default direction ascending.
To change the order to descending usedescription().descending()Example:
CaseQuery.businessCases().orderBy().description()
SQL part:
ORDER BY Description ASCThis is a virtual column. It contains the same value as the column
Descriptionof the referencedCaseLocalized.- Specified by:
descriptionin interfaceCaseQuery.IOrderByQueryColumns- Returns:
- query for further composition
- See Also:
- API:
- This public API is available in Java.
-
startTimestamp
Description copied from interface:CaseQuery.IOrderByQueryColumnsAdds an order by statement for the column
StartTimestampin the default direction ascending.
To change the order to descending usestartTimestamp().descending()Example:
CaseQuery.businessCases().orderBy().startTimestamp()
SQL part:
ORDER BY StartTimestamp ASC- Specified by:
startTimestampin interfaceCaseQuery.IOrderByQueryColumns- Returns:
- query for further composition
- See Also:
- API:
- This public API is available in Java.
-
endTimestamp
Description copied from interface:CaseQuery.IOrderByQueryColumnsAdds an order by statement for the column
EndTimestampin the default direction ascending.
To change the order to descending useendTimestamp().descending()Example:
CaseQuery.businessCases().orderBy().endTimestamp()
SQL part:
ORDER BY EndTimestamp ASC- Specified by:
endTimestampin interfaceCaseQuery.IOrderByQueryColumns- Returns:
- query for further composition
- See Also:
- API:
- This public API is available in Java.
-
businessCalendar
Description copied from interface:CaseQuery.IOrderByQueryColumnsAdds an order by statement for the column
BusinessCalendarin the default direction ascending.
To change the order to descending usebusinessCalendar().descending()Example:
CaseQuery.businessCases().orderBy().businessCalendar()
SQL part:
ORDER BY BusinessCalendar ASC- Specified by:
businessCalendarin interfaceCaseQuery.IOrderByQueryColumns- Returns:
- query for further composition
- See Also:
- API:
- This public API is available in Java.
-
workingTime
Description copied from interface:CaseQuery.IOrderByQueryColumnsAdds an order by statement for the column
WorkingTimein the default direction ascending.
To change the order to descending useworkingTime().descending()Example:
CaseQuery.businessCases().orderBy().workingTime()
SQL part:
ORDER BY WorkingTime ASC- Specified by:
workingTimein interfaceCaseQuery.IOrderByQueryColumns- Returns:
- query for further composition
- See Also:
- API:
- This public API is available in Java.
-
businessRuntime
Description copied from interface:CaseQuery.IOrderByQueryColumnsAdds an order by statement for the column
BusinessRuntimein the default direction ascending.
To change the order to descending usebusinessRuntime().descending()Example:
CaseQuery.businessCases().orderBy().businessRuntime()
SQL part:
ORDER BY BusinessRuntime ASC- Specified by:
businessRuntimein interfaceCaseQuery.IOrderByQueryColumns- Returns:
- query for further composition
- See Also:
- API:
- This public API is available in Java.
-
state
Description copied from interface:CaseQuery.IOrderByQueryColumnsAdds an order by statement for the column
Statein the default direction ascending.
To change the order to descending usestate().descending()Example:
CaseQuery.businessCases().orderBy().state()
SQL part:
ORDER BY State ASC- Specified by:
statein interfaceCaseQuery.IOrderByQueryColumns- Returns:
- query for further composition
- See Also:
- API:
- This public API is available in Java.
-
businessState
Description copied from interface:CaseQuery.IOrderByQueryColumnsAdds an order by statement for the column
BusinessStatein the default direction ascending.
To change the order to descending usebusinessState().descending()Example:
CaseQuery.businessCases().orderBy().businessState()
SQL part:
ORDER BY BusinessState ASC- Specified by:
businessStatein interfaceCaseQuery.IOrderByQueryColumns- Returns:
- query for further composition
- See Also:
- API:
- This public API is available in Java.
-
priority
Description copied from interface:CaseQuery.IOrderByQueryColumnsAdds an order by statement for the column
Priorityin the default direction ascending.
To change the order to descending usepriority().descending()Example:
CaseQuery.businessCases().orderBy().priority()
SQL part:
ORDER BY Priority ASC- Specified by:
priorityin interfaceCaseQuery.IOrderByQueryColumns- Returns:
- query for further composition
- See Also:
- API:
- This public API is available in Java.
-
stage
Description copied from interface:CaseQuery.IOrderByQueryColumnsAdds an order by statement for the column
Stagein the default direction ascending.
To change the order to descending usestage().descending()Example:
CaseQuery.businessCases().orderBy().stage()
SQL part:
ORDER BY Stage ASC- Specified by:
stagein interfaceCaseQuery.IOrderByQueryColumns- Returns:
- query for further composition
- See Also:
- API:
- This public API is available in Java.
-
ownerId
- Specified by:
ownerIdin interfaceCaseQuery.IOrderByQueryColumns- API:
- This public API is available in Java.
-
ownerName
- Specified by:
ownerNamein interfaceCaseQuery.IOrderByQueryColumns- API:
- This public API is available in Java.
-
ownerDisplayName
- Specified by:
ownerDisplayNamein interfaceCaseQuery.IOrderByQueryColumns- API:
- This public API is available in Java.
-
category
Description copied from interface:CaseQuery.IOrderByQueryColumnsAdds an order by statement for the column
Categoryin the default direction ascending.
To change the order to descending usecategory().descending()Example:
CaseQuery.businessCases().orderBy().category()
SQL part:
ORDER BY Category ASC- Specified by:
categoryin interfaceCaseQuery.IOrderByQueryColumns- Returns:
- query for further composition
- See Also:
- API:
- This public API is available in Java.
-
languageId
Description copied from interface:CaseQuery.IOrderByQueryColumnsAdds an order by statement for the column
LanguageIdin the default direction ascending.
To change the order to descending uselanguageId().descending()Example:
CaseQuery.businessCases().orderBy().languageId()
SQL part:
ORDER BY LanguageId ASCThis is a virtual column. It contains the same value as the column
LanguageIdof the referencedCaseLocalized.- Specified by:
languageIdin interfaceCaseQuery.IOrderByQueryColumns- Returns:
- query for further composition
- See Also:
- API:
- This public API is available in Java.
-
customField
Description copied from interface:CaseQuery.IOrderByQueryColumnsAdds an order by statement for a custom field in the default direction ascending.
To change the order to descending usecustomField().descending()Example:
CaseQuery.businessCases().orderBy().customField().stringField("myStringField")- Specified by:
customFieldin interfaceCaseQuery.IOrderByQueryColumns- Returns:
- query for further composition
- See Also:
- API:
- This public API is available in Java.
-
businessCalendarId
Deprecated.Description copied from interface:CaseQuery.IOrderByQueryColumnsThis method is deprecated. Instead of adding an order by statement for the column
BusinessCalendarIdit adds one for the columnBusinessCalendarin the default direction ascending.
To change the order to descending usebusinessCalendarId().descending()Example:
TaskQuery.create().orderBy().businessCalendarId()
SQL part:
ORDER BY BusinessCalendar ASC- Specified by:
businessCalendarIdin interfaceCaseQuery.IOrderByQueryColumns- Returns:
- query for further composition
- See Also:
- API:
- This public API is available in Java.
-
displayNameTemplate
Deprecated, for removal: This API element is subject to removal in a future version.Description copied from interface:CaseQuery.IOrderByQueryColumnsOrders by primary key because column
DisplayNameTemplatewas removed without any replacement.- Specified by:
displayNameTemplatein interfaceCaseQuery.IOrderByQueryColumns- Returns:
- query for further composition
- See Also:
- API:
- This public API is available in Java.
-
displayDescriptionTemplate
@Deprecated(since="9.1", forRemoval=true) public CaseQuery.OrderByColumnQuery displayDescriptionTemplate()Deprecated, for removal: This API element is subject to removal in a future version.Description copied from interface:CaseQuery.IOrderByQueryColumnsOrders by primary key because column
DisplayDescriptionTemplatewas removed without any replacement.- Specified by:
displayDescriptionTemplatein interfaceCaseQuery.IOrderByQueryColumns- Returns:
- query for further composition
- See Also:
- API:
- This public API is available in Java.
-