All Known Implementing Classes:: CaseQuery.OrderByColumnQuery, CaseQuery.OrderByQuery

Enclosing class:: CaseQuery

public static interface CaseQuery.IOrderByQueryColumns

Provides methods to order the result by columns of ICase.

Example:

CaseQuery.businessCases()
  .orderBy()
    .ownerUserId()
    .startTimestamp().descending();

Corresponds to SQL:

SELECT * FROM IWA_Case
  ORDER BY 
    OwnerUserId ASC, 
        StartTimestamp DESC

API:: This is a public API.

Method Summary

All Methods Instance Methods Abstract Methods
Modifier and Type	Method	Description
`CaseQuery.OrderByColumnQuery`	`applicationId()`	Adds an order by statement for the column `ApplicationId` in the default direction ascending. To change the order to descending use `applicationId().descending()`
`CaseQuery.OrderByColumnQuery`	`businessCalendar()`	Adds an order by statement for the column `BusinessCalendar` in the default direction ascending. To change the order to descending use `businessCalendar().descending()`
`CaseQuery.OrderByColumnQuery`	`businessCaseId()`	Adds an order by statement for the column `BusinessCaseId` in the default direction ascending. To change the order to descending use `businessCaseId().descending()`
`CaseQuery.OrderByColumnQuery`	`businessRuntime()`	Adds an order by statement for the column `BusinessRuntime` in the default direction ascending. To change the order to descending use `businessRuntime().descending()`
`CaseQuery.OrderByColumnQuery`	`caseId()`	Adds an order by statement for the column `CaseId` in the default direction ascending. To change the order to descending use `caseId().descending()`
`CaseQuery.OrderByColumnQuery`	`category()`	Adds an order by statement for the column `Category` in the default direction ascending. To change the order to descending use `category().descending()`
`CaseQuery.OrderByColumnQuery`	`creatorTaskId()`	Adds an order by statement for the column `CreatorTaskId` in the default direction ascending. To change the order to descending use `creatorTaskId().descending()`
`CaseQuery.OrderByColumnQuery`	`creatorUserDisplayName()`	Adds an order by statement for the column `CreatorUserDisplayName` in the default direction ascending. To change the order to descending use `creatorUserDisplayName().descending()`
`CaseQuery.OrderByColumnQuery`	`creatorUserId()`	Adds an order by statement for the column `CreatorUserId` in the default direction ascending. To change the order to descending use `creatorUserId().descending()`
`CaseQuery.OrderByColumnQuery`	`creatorUserName()`	Adds an order by statement for the column `CreatorUserName` in the default direction ascending. To change the order to descending use `creatorUserName().descending()`
`CaseQuery.ICustomFieldOrderBy`	`customField()`	Adds an order by statement for a custom field in the default direction ascending. To change the order to descending use `customField().descending()`
`CaseQuery.OrderByColumnQuery`	`description()`	Adds an order by statement for the column `Description` in the default direction ascending. To change the order to descending use `description().descending()`
`CaseQuery.OrderByColumnQuery`	`displayDescriptionTemplate()`	Adds an order by statement for the column `DisplayDescriptionTemplate` in the default direction ascending. To change the order to descending use `displayDescriptionTemplate().descending()`
`CaseQuery.OrderByColumnQuery`	`displayNameTemplate()`	Adds an order by statement for the column `DisplayNameTemplate` in the default direction ascending. To change the order to descending use `displayNameTemplate().descending()`
`CaseQuery.OrderByColumnQuery`	`endTimestamp()`	Adds an order by statement for the column `EndTimestamp` in the default direction ascending. To change the order to descending use `endTimestamp().descending()`
`CaseQuery.OrderByColumnQuery`	`environmentId()`	Adds an order by statement for the column `EnvironmentId` in the default direction ascending. To change the order to descending use `environmentId().descending()`
`CaseQuery.OrderByColumnQuery`	`name()`	Adds an order by statement for the column `Name` in the default direction ascending. To change the order to descending use `name().descending()`
`CaseQuery.OrderByColumnQuery`	`ownerName()`	Adds an order by statement for the column `OwnerName` in the default direction ascending. To change the order to descending use `ownerName().descending()`
`CaseQuery.OrderByColumnQuery`	`ownerRoleId()`	Adds an order by statement for the column `OwnerRoleId` in the default direction ascending. To change the order to descending use `ownerRoleId().descending()`
`CaseQuery.OrderByColumnQuery`	`ownerUserId()`	Adds an order by statement for the column `OwnerUserId` in the default direction ascending. To change the order to descending use `ownerUserId().descending()`
`CaseQuery.OrderByColumnQuery`	`priority()`	Adds an order by statement for the column `Priority` in the default direction ascending. To change the order to descending use `priority().descending()`
`CaseQuery.OrderByColumnQuery`	`processModelId()`	Adds an order by statement for the column `ProcessModelId` in the default direction ascending. To change the order to descending use `processModelId().descending()`
`CaseQuery.OrderByColumnQuery`	`stage()`	Adds an order by statement for the column `Stage` in the default direction ascending. To change the order to descending use `stage().descending()`
`CaseQuery.OrderByColumnQuery`	`startTimestamp()`	Adds an order by statement for the column `StartTimestamp` in the default direction ascending. To change the order to descending use `startTimestamp().descending()`
`CaseQuery.OrderByColumnQuery`	`state()`	Adds an order by statement for the column `State` in the default direction ascending. To change the order to descending use `state().descending()`
`CaseQuery.OrderByColumnQuery`	`taskStartId()`	Adds an order by statement for the column `TaskStartId` in the default direction ascending. To change the order to descending use `taskStartId().descending()`
`CaseQuery.OrderByColumnQuery`	`workingTime()`	Adds an order by statement for the column `WorkingTime` in the default direction ascending. To change the order to descending use `workingTime().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 use caseId().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 use businessCaseId().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 use applicationId().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 use processModelId().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 use taskStartId().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.
  - creatorUserId
```
CaseQuery.OrderByColumnQuery creatorUserId()
```
    Adds an order by statement for the column CreatorUserId in the default direction ascending.
    To change the order to descending use creatorUserId().descending()
    
    Example:
    
    CaseQuery.businessCases().orderBy().creatorUserId()
    
    SQL part: ORDER BY CreatorUserId 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 use creatorUserName().descending()
    
    Example:
    
    CaseQuery.businessCases().orderBy().creatorUserName()
    
    SQL part: ORDER BY CreatorUserName 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.
  - creatorUserDisplayName
```
CaseQuery.OrderByColumnQuery creatorUserDisplayName()
```
    Adds an order by statement for the column CreatorUserDisplayName in the default direction ascending.
    To change the order to descending use creatorUserDisplayName().descending()
    
    Example:
    
    CaseQuery.businessCases().orderBy().creatorUserDisplayName()
    
    SQL part: ORDER BY CreatorUserDisplayName 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.
  - creatorTaskId
```
CaseQuery.OrderByColumnQuery creatorTaskId()
```
    Adds an order by statement for the column CreatorTaskId in the default direction ascending.
    To change the order to descending use creatorTaskId().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.
  - environmentId
```
CaseQuery.OrderByColumnQuery environmentId()
```
    Adds an order by statement for the column EnvironmentId in the default direction ascending.
    To change the order to descending use environmentId().descending()
    
    Example:
    
    CaseQuery.businessCases().orderBy().environmentId()
    
    SQL part: ORDER BY EnvironmentId 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 use displayNameTemplate().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 use name().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
```
CaseQuery.OrderByColumnQuery displayDescriptionTemplate()
```
    Adds an order by statement for the column DisplayDescriptionTemplate in the default direction ascending.
    To change the order to descending use displayDescriptionTemplate().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
```
CaseQuery.OrderByColumnQuery description()
```
    Adds an order by statement for the column Description in the default direction ascending.
    To change the order to descending use description().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 use startTimestamp().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 use endTimestamp().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 use businessCalendar().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 use workingTime().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 use businessRuntime().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 use state().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 use priority().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 use stage().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.
  - ownerRoleId
```
CaseQuery.OrderByColumnQuery ownerRoleId()
```
    Adds an order by statement for the column OwnerRoleId in the default direction ascending.
    To change the order to descending use ownerRoleId().descending()
    
    Example:
    
    CaseQuery.businessCases().orderBy().ownerRoleId()
    
    SQL part: ORDER BY OwnerRoleId 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.
  - ownerUserId
```
CaseQuery.OrderByColumnQuery ownerUserId()
```
    Adds an order by statement for the column OwnerUserId in the default direction ascending.
    To change the order to descending use ownerUserId().descending()
    
    Example:
    
    CaseQuery.businessCases().orderBy().ownerUserId()
    
    SQL part: ORDER BY OwnerUserId 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 use ownerName().descending()
    
    Example:
    
    CaseQuery.businessCases().orderBy().ownerName()
    
    SQL part: ORDER BY OwnerName 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.
  - category
```
CaseQuery.OrderByColumnQuery category()
```
    Adds an order by statement for the column Category in the default direction ascending.
    To change the order to descending use category().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 use customField().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.

Interface CaseQuery.IOrderByQueryColumns

Method Summary

Method Detail

caseId

businessCaseId

applicationId

processModelId

taskStartId

creatorUserId

creatorUserName

creatorUserDisplayName

creatorTaskId

environmentId

displayNameTemplate

name

displayDescriptionTemplate

description

startTimestamp

endTimestamp

businessCalendar

workingTime

businessRuntime

state

priority

stage

ownerRoleId

ownerUserId

ownerName

category

customField