Interface CaseQuery.IOrderByQueryColumns
-
- All Known Implementing Classes:
CaseQuery.OrderByColumnQuery
,CaseQuery.OrderByQuery
- Enclosing class:
- CaseQuery
public static interface CaseQuery.IOrderByQueryColumns
Provides methods to order the result by columns ofICase
.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.
-
-
Method Summary
All Methods Instance Methods Abstract Methods Deprecated Methods Modifier and Type Method Description CaseQuery.OrderByColumnQuery
activatorId()
Adds an order by statement for the columnActivatorId
in the default direction ascending.
To change the order to descending useactivatorId().descending()
CaseQuery.OrderByColumnQuery
applicationId()
Adds an order by statement for the columnApplicationId
in the default direction ascending.
To change the order to descending useapplicationId().descending()
CaseQuery.OrderByColumnQuery
businessCalendar()
Adds an order by statement for the columnBusinessCalendar
in the default direction ascending.
To change the order to descending usebusinessCalendar().descending()
CaseQuery.OrderByColumnQuery
businessCaseId()
Adds an order by statement for the columnBusinessCaseId
in the default direction ascending.
To change the order to descending usebusinessCaseId().descending()
CaseQuery.OrderByColumnQuery
businessRuntime()
Adds an order by statement for the columnBusinessRuntime
in the default direction ascending.
To change the order to descending usebusinessRuntime().descending()
CaseQuery.OrderByColumnQuery
caseId()
Adds an order by statement for the columnCaseId
in the default direction ascending.
To change the order to descending usecaseId().descending()
CaseQuery.OrderByColumnQuery
category()
Adds an order by statement for the columnCategory
in the default direction ascending.
To change the order to descending usecategory().descending()
CaseQuery.OrderByColumnQuery
creatorId()
Adds an order by statement for the columnCreatorId
in the default direction ascending.
To change the order to descending usecreatorId().descending()
CaseQuery.OrderByColumnQuery
creatorTaskId()
Adds an order by statement for the columnCreatorTaskId
in the default direction ascending.
To change the order to descending usecreatorTaskId().descending()
CaseQuery.OrderByColumnQuery
creatorUserDisplayName()
Adds an order by statement for the columnCreatorUserDisplayName
in the default direction ascending.
To change the order to descending usecreatorUserDisplayName().descending()
CaseQuery.OrderByColumnQuery
creatorUserName()
Adds an order by statement for the columnCreatorUserName
in the default direction ascending.
To change the order to descending usecreatorUserName().descending()
CaseQuery.ICustomFieldOrderBy
customField()
Adds an order by statement for a custom field in the default direction ascending.
To change the order to descending usecustomField().descending()
CaseQuery.OrderByColumnQuery
description()
Deprecated.ordering by CLOB fields is not possible.CaseQuery.OrderByColumnQuery
displayDescriptionTemplate()
Deprecated.ordering by CLOB fields is not possible.CaseQuery.OrderByColumnQuery
displayNameTemplate()
Adds an order by statement for the columnDisplayNameTemplate
in the default direction ascending.
To change the order to descending usedisplayNameTemplate().descending()
CaseQuery.OrderByColumnQuery
endTimestamp()
Adds an order by statement for the columnEndTimestamp
in the default direction ascending.
To change the order to descending useendTimestamp().descending()
CaseQuery.OrderByColumnQuery
environment()
Adds an order by statement for the columnEnvironment
in the default direction ascending.
To change the order to descending useenvironment().descending()
CaseQuery.OrderByColumnQuery
name()
Adds an order by statement for the columnName
in the default direction ascending.
To change the order to descending usename().descending()
CaseQuery.OrderByColumnQuery
ownerDisplayName()
Adds an order by statement for the columnOwnerDisplayName
in the default direction ascending.
To change the order to descending useownerDisplayName().descending()
CaseQuery.OrderByColumnQuery
ownerId()
Adds an order by statement for the columnOwnerId
in the default direction ascending.
To change the order to descending useownerId().descending()
CaseQuery.OrderByColumnQuery
ownerName()
Adds an order by statement for the columnOwnerName
in the default direction ascending.
To change the order to descending useownerName().descending()
CaseQuery.OrderByColumnQuery
priority()
Adds an order by statement for the columnPriority
in the default direction ascending.
To change the order to descending usepriority().descending()
CaseQuery.OrderByColumnQuery
processModelId()
Adds an order by statement for the columnProcessModelId
in the default direction ascending.
To change the order to descending useprocessModelId().descending()
CaseQuery.OrderByColumnQuery
stage()
Adds an order by statement for the columnStage
in the default direction ascending.
To change the order to descending usestage().descending()
CaseQuery.OrderByColumnQuery
startTimestamp()
Adds an order by statement for the columnStartTimestamp
in the default direction ascending.
To change the order to descending usestartTimestamp().descending()
CaseQuery.OrderByColumnQuery
state()
Adds an order by statement for the columnState
in the default direction ascending.
To change the order to descending usestate().descending()
CaseQuery.OrderByColumnQuery
taskStartId()
Adds an order by statement for the columnTaskStartId
in the default direction ascending.
To change the order to descending usetaskStartId().descending()
CaseQuery.OrderByColumnQuery
workingTime()
Adds an order by statement for the columnWorkingTime
in the default direction ascending.
To change the order to descending useworkingTime().descending()
-
-
-
Method Detail
-
caseId
CaseQuery.OrderByColumnQuery caseId()
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
- Returns:
- query for further composition
- See Also:
CaseQuery.OrderByColumnQuery.descending()
,CaseQuery.OrderByColumnQuery.ascending()
- API:
- This public API is available in IvyScript and Java. It has the visibility EXPERT.
-
businessCaseId
CaseQuery.OrderByColumnQuery businessCaseId()
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
- Returns:
- query for further composition
- See Also:
CaseQuery.OrderByColumnQuery.descending()
,CaseQuery.OrderByColumnQuery.ascending()
- API:
- This public API is available in IvyScript and Java. It has the visibility EXPERT.
-
applicationId
CaseQuery.OrderByColumnQuery applicationId()
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
- Returns:
- query for further composition
- See Also:
CaseQuery.OrderByColumnQuery.descending()
,CaseQuery.OrderByColumnQuery.ascending()
- API:
- This public API is available in IvyScript and Java. It has the visibility EXPERT.
-
processModelId
CaseQuery.OrderByColumnQuery processModelId()
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
- Returns:
- query for further composition
- See Also:
CaseQuery.OrderByColumnQuery.descending()
,CaseQuery.OrderByColumnQuery.ascending()
- API:
- This public API is available in IvyScript and Java. It has the visibility EXPERT.
-
taskStartId
CaseQuery.OrderByColumnQuery taskStartId()
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
- Returns:
- query for further composition
- See Also:
CaseQuery.OrderByColumnQuery.descending()
,CaseQuery.OrderByColumnQuery.ascending()
- API:
- This public API is available in IvyScript and Java. It has the visibility EXPERT.
-
activatorId
CaseQuery.OrderByColumnQuery activatorId()
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
- Returns:
- query for further composition
- See Also:
CaseQuery.OrderByColumnQuery.descending()
,CaseQuery.OrderByColumnQuery.ascending()
- API:
- This public API is available in IvyScript and Java. It has the visibility EXPERT.
-
creatorId
CaseQuery.OrderByColumnQuery creatorId()
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
- Returns:
- query for further composition
- See Also:
CaseQuery.OrderByColumnQuery.descending()
,CaseQuery.OrderByColumnQuery.ascending()
- API:
- This public API is available in IvyScript and Java. It has the visibility EXPERT.
-
creatorUserName
CaseQuery.OrderByColumnQuery creatorUserName()
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
.- Returns:
- query for further composition
- See Also:
CaseQuery.OrderByColumnQuery.descending()
,CaseQuery.OrderByColumnQuery.ascending()
- API:
- This public API is available in IvyScript and Java. It has the visibility EXPERT.
-
creatorUserDisplayName
CaseQuery.OrderByColumnQuery creatorUserDisplayName()
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
.- Returns:
- query for further composition
- See Also:
CaseQuery.OrderByColumnQuery.descending()
,CaseQuery.OrderByColumnQuery.ascending()
- API:
- This public API is available in IvyScript and Java. It has the visibility EXPERT.
-
creatorTaskId
CaseQuery.OrderByColumnQuery creatorTaskId()
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
- Returns:
- query for further composition
- See Also:
CaseQuery.OrderByColumnQuery.descending()
,CaseQuery.OrderByColumnQuery.ascending()
- API:
- This public API is available in IvyScript and Java. It has the visibility EXPERT.
-
environment
CaseQuery.OrderByColumnQuery environment()
Adds an order by statement for the column
Environment
in the default direction ascending.
To change the order to descending useenvironment().descending()
Example:
CaseQuery.businessCases().orderBy().environment()
SQL part:
ORDER BY Environment ASC
- Returns:
- query for further composition
- See Also:
CaseQuery.OrderByColumnQuery.descending()
,CaseQuery.OrderByColumnQuery.ascending()
- API:
- This public API is available in IvyScript and Java. It has the visibility EXPERT.
-
displayNameTemplate
CaseQuery.OrderByColumnQuery displayNameTemplate()
Adds an order by statement for the column
DisplayNameTemplate
in the default direction ascending.
To change the order to descending usedisplayNameTemplate().descending()
Example:
CaseQuery.businessCases().orderBy().displayNameTemplate()
SQL part:
ORDER BY DisplayNameTemplate ASC
- Returns:
- query for further composition
- See Also:
CaseQuery.OrderByColumnQuery.descending()
,CaseQuery.OrderByColumnQuery.ascending()
- API:
- This public API is available in IvyScript and Java. It has the visibility EXPERT.
-
name
CaseQuery.OrderByColumnQuery name()
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
- Returns:
- query for further composition
- See Also:
CaseQuery.OrderByColumnQuery.descending()
,CaseQuery.OrderByColumnQuery.ascending()
- API:
- This public API is available in IvyScript and Java. It has the visibility EXPERT.
-
displayDescriptionTemplate
@Deprecated CaseQuery.OrderByColumnQuery displayDescriptionTemplate()
Deprecated.ordering by CLOB fields is not possible.Adds an order by statement for the column
DisplayDescriptionTemplate
in the default direction ascending.
To change the order to descending usedisplayDescriptionTemplate().descending()
Example:
CaseQuery.businessCases().orderBy().displayDescriptionTemplate()
SQL part:
ORDER BY DisplayDescriptionTemplate ASC
- Returns:
- query for further composition
- See Also:
CaseQuery.OrderByColumnQuery.descending()
,CaseQuery.OrderByColumnQuery.ascending()
- API:
- This public API is available in IvyScript and Java. It has the visibility EXPERT.
-
description
@Deprecated CaseQuery.OrderByColumnQuery description()
Deprecated.ordering by CLOB fields is not possible.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
- Returns:
- query for further composition
- See Also:
CaseQuery.OrderByColumnQuery.descending()
,CaseQuery.OrderByColumnQuery.ascending()
- API:
- This public API is available in IvyScript and Java. It has the visibility EXPERT.
-
startTimestamp
CaseQuery.OrderByColumnQuery startTimestamp()
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
- Returns:
- query for further composition
- See Also:
CaseQuery.OrderByColumnQuery.descending()
,CaseQuery.OrderByColumnQuery.ascending()
- API:
- This public API is available in IvyScript and Java. It has the visibility EXPERT.
-
endTimestamp
CaseQuery.OrderByColumnQuery endTimestamp()
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
- Returns:
- query for further composition
- See Also:
CaseQuery.OrderByColumnQuery.descending()
,CaseQuery.OrderByColumnQuery.ascending()
- API:
- This public API is available in IvyScript and Java. It has the visibility EXPERT.
-
businessCalendar
CaseQuery.OrderByColumnQuery businessCalendar()
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
- Returns:
- query for further composition
- See Also:
CaseQuery.OrderByColumnQuery.descending()
,CaseQuery.OrderByColumnQuery.ascending()
- API:
- This public API is available in IvyScript and Java. It has the visibility EXPERT.
-
workingTime
CaseQuery.OrderByColumnQuery workingTime()
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
- Returns:
- query for further composition
- See Also:
CaseQuery.OrderByColumnQuery.descending()
,CaseQuery.OrderByColumnQuery.ascending()
- API:
- This public API is available in IvyScript and Java. It has the visibility EXPERT.
-
businessRuntime
CaseQuery.OrderByColumnQuery businessRuntime()
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
- Returns:
- query for further composition
- See Also:
CaseQuery.OrderByColumnQuery.descending()
,CaseQuery.OrderByColumnQuery.ascending()
- API:
- This public API is available in IvyScript and Java. It has the visibility EXPERT.
-
state
CaseQuery.OrderByColumnQuery state()
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
- Returns:
- query for further composition
- See Also:
CaseQuery.OrderByColumnQuery.descending()
,CaseQuery.OrderByColumnQuery.ascending()
- API:
- This public API is available in IvyScript and Java. It has the visibility EXPERT.
-
priority
CaseQuery.OrderByColumnQuery priority()
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
- Returns:
- query for further composition
- See Also:
CaseQuery.OrderByColumnQuery.descending()
,CaseQuery.OrderByColumnQuery.ascending()
- API:
- This public API is available in IvyScript and Java. It has the visibility EXPERT.
-
stage
CaseQuery.OrderByColumnQuery stage()
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
- Returns:
- query for further composition
- See Also:
CaseQuery.OrderByColumnQuery.descending()
,CaseQuery.OrderByColumnQuery.ascending()
- API:
- This public API is available in IvyScript and Java. It has the visibility EXPERT.
-
ownerId
CaseQuery.OrderByColumnQuery ownerId()
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
- Returns:
- query for further composition
- See Also:
CaseQuery.OrderByColumnQuery.descending()
,CaseQuery.OrderByColumnQuery.ascending()
- API:
- This public API is available in IvyScript and Java. It has the visibility EXPERT.
-
ownerName
CaseQuery.OrderByColumnQuery ownerName()
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
.- Returns:
- query for further composition
- See Also:
CaseQuery.OrderByColumnQuery.descending()
,CaseQuery.OrderByColumnQuery.ascending()
- API:
- This public API is available in IvyScript and Java. It has the visibility EXPERT.
-
ownerDisplayName
CaseQuery.OrderByColumnQuery ownerDisplayName()
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
.- Returns:
- query for further composition
- See Also:
CaseQuery.OrderByColumnQuery.descending()
,CaseQuery.OrderByColumnQuery.ascending()
- API:
- This public API is available in IvyScript and Java. It has the visibility EXPERT.
-
category
CaseQuery.OrderByColumnQuery category()
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
- Returns:
- query for further composition
- See Also:
CaseQuery.OrderByColumnQuery.descending()
,CaseQuery.OrderByColumnQuery.ascending()
- API:
- This public API is available in IvyScript and Java. It has the visibility EXPERT.
-
customField
CaseQuery.ICustomFieldOrderBy customField()
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")
- Returns:
- query for further composition
- See Also:
CaseQuery.OrderByColumnQuery.descending()
,CaseQuery.OrderByColumnQuery.ascending()
- API:
- This public API is available in IvyScript and Java. It has the visibility EXPERT.
-
-