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.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.OrderByColumnQuery, CaseQuery.OrderByQuery
-
Method Summary
Modifier and TypeMethodDescriptionAdds an order by statement for the columnActivatorId
in the default direction ascending.
To change the order to descending useactivatorId().descending()
Adds an order by statement for the columnApplicationId
in the default direction ascending.
To change the order to descending useapplicationId().descending()
Adds an order by statement for the columnBusinessCalendar
in the default direction ascending.
To change the order to descending usebusinessCalendar().descending()
Deprecated.Adds an order by statement for the columnBusinessCaseId
in the default direction ascending.
To change the order to descending usebusinessCaseId().descending()
Adds an order by statement for the columnBusinessRuntime
in the default direction ascending.
To change the order to descending usebusinessRuntime().descending()
Adds an order by statement for the columnBusinessState
in the default direction ascending.
To change the order to descending usebusinessState().descending()
caseId()
Adds an order by statement for the columnCaseId
in the default direction ascending.
To change the order to descending usecaseId().descending()
category()
Adds an order by statement for the columnCategory
in the default direction ascending.
To change the order to descending usecategory().descending()
Adds an order by statement for the columnCreatorId
in the default direction ascending.
To change the order to descending usecreatorId().descending()
Adds an order by statement for the columnCreatorTaskId
in the default direction ascending.
To change the order to descending usecreatorTaskId().descending()
Adds an order by statement for the columnCreatorUserDisplayName
in the default direction ascending.
To change the order to descending usecreatorUserDisplayName().descending()
Adds an order by statement for the columnCreatorUserName
in 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 columnEndTimestamp
in the default direction ascending.
To change the order to descending useendTimestamp().descending()
Adds an order by statement for the columnLanguageId
in the default direction ascending.
To change the order to descending uselanguageId().descending()
name()
Adds an order by statement for the columnName
in the default direction ascending.
To change the order to descending usename().descending()
Adds an order by statement for the columnOwnerDisplayName
in the default direction ascending.
To change the order to descending useownerDisplayName().descending()
ownerId()
Adds an order by statement for the columnOwnerId
in the default direction ascending.
To change the order to descending useownerId().descending()
Adds an order by statement for the columnOwnerName
in the default direction ascending.
To change the order to descending useownerName().descending()
priority()
Adds an order by statement for the columnPriority
in the default direction ascending.
To change the order to descending usepriority().descending()
Adds an order by statement for the columnProcessModelId
in the default direction ascending.
To change the order to descending useprocessModelId().descending()
Adds an order by statement for the columnSecuritySystemId
in the default direction ascending.
To change the order to descending usesecuritySystemId().descending()
stage()
Adds an order by statement for the columnStage
in the default direction ascending.
To change the order to descending usestage().descending()
Adds an order by statement for the columnStartTimestamp
in the default direction ascending.
To change the order to descending usestartTimestamp().descending()
state()
Adds an order by statement for the columnState
in the default direction ascending.
To change the order to descending usestate().descending()
Adds an order by statement for the columnTaskStartId
in the default direction ascending.
To change the order to descending usetaskStartId().descending()
Adds an order by statement for the columnWorkingTime
in the default direction ascending.
To change the order to descending useworkingTime().descending()
-
Method Details
-
caseId
Description copied from interface:CaseQuery.IOrderByQueryColumns
Adds an order by statement for the column
CaseId
in 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:
caseId
in interfaceCaseQuery.IOrderByQueryColumns
- Returns:
- query for further composition
- See Also:
- API:
- This public API is available in Java.
-
businessCaseId
Description copied from interface:CaseQuery.IOrderByQueryColumns
Adds an order by statement for the column
BusinessCaseId
in 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:
businessCaseId
in interfaceCaseQuery.IOrderByQueryColumns
- Returns:
- query for further composition
- See Also:
- API:
- This public API is available in Java.
-
securitySystemId
Description copied from interface:CaseQuery.IOrderByQueryColumns
Adds an order by statement for the column
SecuritySystemId
in 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:
securitySystemId
in interfaceCaseQuery.IOrderByQueryColumns
- Returns:
- query for further composition
- See Also:
- API:
- This public API is available in Java.
-
applicationId
Description copied from interface:CaseQuery.IOrderByQueryColumns
Adds an order by statement for the column
ApplicationId
in 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:
applicationId
in interfaceCaseQuery.IOrderByQueryColumns
- Returns:
- query for further composition
- See Also:
- API:
- This public API is available in Java.
-
processModelId
Description copied from interface:CaseQuery.IOrderByQueryColumns
Adds an order by statement for the column
ProcessModelId
in 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:
processModelId
in interfaceCaseQuery.IOrderByQueryColumns
- Returns:
- query for further composition
- See Also:
- API:
- This public API is available in Java.
-
taskStartId
Description copied from interface:CaseQuery.IOrderByQueryColumns
Adds an order by statement for the column
TaskStartId
in 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:
taskStartId
in interfaceCaseQuery.IOrderByQueryColumns
- Returns:
- query for further composition
- See Also:
- API:
- This public API is available in Java.
-
activatorId
Description copied from interface:CaseQuery.IOrderByQueryColumns
Adds an order by statement for the column
ActivatorId
in 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:
activatorId
in interfaceCaseQuery.IOrderByQueryColumns
- Returns:
- query for further composition
- See Also:
- API:
- This public API is available in Java.
-
creatorId
Description copied from interface:CaseQuery.IOrderByQueryColumns
Adds an order by statement for the column
CreatorId
in 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:
creatorId
in interfaceCaseQuery.IOrderByQueryColumns
- Returns:
- query for further composition
- See Also:
- API:
- This public API is available in Java.
-
creatorUserName
Description copied from interface:CaseQuery.IOrderByQueryColumns
Adds an order by statement for the column
CreatorUserName
in the default direction ascending.
To change the order to descending usecreatorUserName().descending()
Example:
CaseQuery.businessCases().orderBy().creatorUserName()
SQL part:
ORDER BY CreatorUserName ASC
This is a virtual column. It contains the same value as the column
Name
of the referencedCreator
.- Specified by:
creatorUserName
in interfaceCaseQuery.IOrderByQueryColumns
- Returns:
- query for further composition
- See Also:
- API:
- This public API is available in Java.
-
creatorUserDisplayName
Description copied from interface:CaseQuery.IOrderByQueryColumns
Adds an order by statement for the column
CreatorUserDisplayName
in the default direction ascending.
To change the order to descending usecreatorUserDisplayName().descending()
Example:
CaseQuery.businessCases().orderBy().creatorUserDisplayName()
SQL part:
ORDER BY CreatorUserDisplayName ASC
This is a virtual column. It contains the same value as the column
DisplayName
of the referencedCreator
.- Specified by:
creatorUserDisplayName
in interfaceCaseQuery.IOrderByQueryColumns
- Returns:
- query for further composition
- See Also:
- API:
- This public API is available in Java.
-
creatorTaskId
Description copied from interface:CaseQuery.IOrderByQueryColumns
Adds an order by statement for the column
CreatorTaskId
in 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:
creatorTaskId
in interfaceCaseQuery.IOrderByQueryColumns
- Returns:
- query for further composition
- See Also:
- API:
- This public API is available in Java.
-
name
Description copied from interface:CaseQuery.IOrderByQueryColumns
Adds an order by statement for the column
Name
in the default direction ascending.
To change the order to descending usename().descending()
Example:
CaseQuery.businessCases().orderBy().name()
SQL part:
ORDER BY Name ASC
This is a virtual column. It contains the same value as the column
Name
of the referencedCaseLocalized
.- Specified by:
name
in interfaceCaseQuery.IOrderByQueryColumns
- Returns:
- query for further composition
- See Also:
- API:
- This public API is available in Java.
-
description
Deprecated.Description copied from interface:CaseQuery.IOrderByQueryColumns
Adds an order by statement for the column
Description
in the default direction ascending.
To change the order to descending usedescription().descending()
Example:
CaseQuery.businessCases().orderBy().description()
SQL part:
ORDER BY Description ASC
This is a virtual column. It contains the same value as the column
Description
of the referencedCaseLocalized
.- Specified by:
description
in interfaceCaseQuery.IOrderByQueryColumns
- Returns:
- query for further composition
- See Also:
- API:
- This public API is available in Java.
-
startTimestamp
Description copied from interface:CaseQuery.IOrderByQueryColumns
Adds an order by statement for the column
StartTimestamp
in 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:
startTimestamp
in interfaceCaseQuery.IOrderByQueryColumns
- Returns:
- query for further composition
- See Also:
- API:
- This public API is available in Java.
-
endTimestamp
Description copied from interface:CaseQuery.IOrderByQueryColumns
Adds an order by statement for the column
EndTimestamp
in 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:
endTimestamp
in interfaceCaseQuery.IOrderByQueryColumns
- Returns:
- query for further composition
- See Also:
- API:
- This public API is available in Java.
-
businessCalendar
Description copied from interface:CaseQuery.IOrderByQueryColumns
Adds an order by statement for the column
BusinessCalendar
in 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:
businessCalendar
in interfaceCaseQuery.IOrderByQueryColumns
- Returns:
- query for further composition
- See Also:
- API:
- This public API is available in Java.
-
workingTime
Description copied from interface:CaseQuery.IOrderByQueryColumns
Adds an order by statement for the column
WorkingTime
in 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:
workingTime
in interfaceCaseQuery.IOrderByQueryColumns
- Returns:
- query for further composition
- See Also:
- API:
- This public API is available in Java.
-
businessRuntime
Description copied from interface:CaseQuery.IOrderByQueryColumns
Adds an order by statement for the column
BusinessRuntime
in 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:
businessRuntime
in interfaceCaseQuery.IOrderByQueryColumns
- Returns:
- query for further composition
- See Also:
- API:
- This public API is available in Java.
-
state
Description copied from interface:CaseQuery.IOrderByQueryColumns
Adds an order by statement for the column
State
in 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:
state
in interfaceCaseQuery.IOrderByQueryColumns
- Returns:
- query for further composition
- See Also:
- API:
- This public API is available in Java.
-
businessState
Description copied from interface:CaseQuery.IOrderByQueryColumns
Adds an order by statement for the column
BusinessState
in 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:
businessState
in interfaceCaseQuery.IOrderByQueryColumns
- Returns:
- query for further composition
- See Also:
- API:
- This public API is available in Java.
-
priority
Description copied from interface:CaseQuery.IOrderByQueryColumns
Adds an order by statement for the column
Priority
in 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:
priority
in interfaceCaseQuery.IOrderByQueryColumns
- Returns:
- query for further composition
- See Also:
- API:
- This public API is available in Java.
-
stage
Description copied from interface:CaseQuery.IOrderByQueryColumns
Adds an order by statement for the column
Stage
in 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:
stage
in interfaceCaseQuery.IOrderByQueryColumns
- Returns:
- query for further composition
- See Also:
- API:
- This public API is available in Java.
-
ownerId
Description copied from interface:CaseQuery.IOrderByQueryColumns
Adds an order by statement for the column
OwnerId
in the default direction ascending.
To change the order to descending useownerId().descending()
Example:
CaseQuery.businessCases().orderBy().ownerId()
SQL part:
ORDER BY OwnerId ASC
- Specified by:
ownerId
in interfaceCaseQuery.IOrderByQueryColumns
- Returns:
- query for further composition
- See Also:
- API:
- This public API is available in Java.
-
ownerName
Description copied from interface:CaseQuery.IOrderByQueryColumns
Adds an order by statement for the column
OwnerName
in the default direction ascending.
To change the order to descending useownerName().descending()
Example:
CaseQuery.businessCases().orderBy().ownerName()
SQL part:
ORDER BY OwnerName ASC
This is a virtual column. It contains the same value as the column
MemberName
of the referencedOwner
.- Specified by:
ownerName
in interfaceCaseQuery.IOrderByQueryColumns
- Returns:
- query for further composition
- See Also:
- API:
- This public API is available in Java.
-
ownerDisplayName
Description copied from interface:CaseQuery.IOrderByQueryColumns
Adds an order by statement for the column
OwnerDisplayName
in the default direction ascending.
To change the order to descending useownerDisplayName().descending()
Example:
CaseQuery.businessCases().orderBy().ownerDisplayName()
SQL part:
ORDER BY OwnerDisplayName ASC
This is a virtual column. It contains the same value as the column
DisplayName
of the referencedOwner
.- Specified by:
ownerDisplayName
in interfaceCaseQuery.IOrderByQueryColumns
- Returns:
- query for further composition
- See Also:
- API:
- This public API is available in Java.
-
category
Description copied from interface:CaseQuery.IOrderByQueryColumns
Adds an order by statement for the column
Category
in 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:
category
in interfaceCaseQuery.IOrderByQueryColumns
- Returns:
- query for further composition
- See Also:
- API:
- This public API is available in Java.
-
languageId
Description copied from interface:CaseQuery.IOrderByQueryColumns
Adds an order by statement for the column
LanguageId
in the default direction ascending.
To change the order to descending uselanguageId().descending()
Example:
CaseQuery.businessCases().orderBy().languageId()
SQL part:
ORDER BY LanguageId ASC
This is a virtual column. It contains the same value as the column
LanguageId
of the referencedCaseLocalized
.- Specified by:
languageId
in interfaceCaseQuery.IOrderByQueryColumns
- Returns:
- query for further composition
- See Also:
- API:
- This public API is available in Java.
-
customField
Description copied from interface:CaseQuery.IOrderByQueryColumns
Adds 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:
customField
in interfaceCaseQuery.IOrderByQueryColumns
- Returns:
- query for further composition
- See Also:
- API:
- This public API is available in Java.
-
businessCalendarId
Deprecated.Description copied from interface:CaseQuery.IOrderByQueryColumns
This method is deprecated. Instead of adding an order by statement for the column
BusinessCalendarId
it adds one for the columnBusinessCalendar
in 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:
businessCalendarId
in 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.IOrderByQueryColumns
Orders by primary key because column
DisplayNameTemplate
was removed without any replacement.- Specified by:
displayNameTemplate
in 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.IOrderByQueryColumns
Orders by primary key because column
DisplayDescriptionTemplate
was removed without any replacement.- Specified by:
displayDescriptionTemplate
in interfaceCaseQuery.IOrderByQueryColumns
- Returns:
- query for further composition
- See Also:
- API:
- This public API is available in Java.
-