java.lang.Object
- ch.ivyteam.ivy.persistence.query.Query<ICase>
- - ch.ivyteam.ivy.workflow.query.CaseQuery
  - - ch.ivyteam.ivy.workflow.query.CaseQuery.OrderByQuery

All Implemented Interfaces:: CaseQuery.IOrderByQueryColumns

Direct Known Subclasses:: CaseQuery.OrderByColumnQuery

Enclosing class:: CaseQuery

public static class CaseQuery.OrderByQuery
extends CaseQuery
implements 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.

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.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 Deprecated Methods
Modifier and Type	Method	Description
`CaseQuery.OrderByColumnQuery`	`activatorId()`	Adds an order by statement for the column `ActivatorId` in the default direction ascending. To change the order to descending use `activatorId().descending()`
`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`	`creatorId()`	Adds an order by statement for the column `CreatorId` in the default direction ascending. To change the order to descending use `creatorId().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`	`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()`	Deprecated.
`CaseQuery.OrderByColumnQuery`	`displayDescriptionTemplate()`	Deprecated.
`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`	`environment()`	Adds an order by statement for the column `Environment` in the default direction ascending. To change the order to descending use `environment().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`	`ownerDisplayName()`	Adds an order by statement for the column `OwnerDisplayName` in the default direction ascending. To change the order to descending use `ownerDisplayName().descending()`
`CaseQuery.OrderByColumnQuery`	`ownerId()`	Adds an order by statement for the column `OwnerId` in the default direction ascending. To change the order to descending use `ownerId().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`	`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()`

Methods inherited from class ch.ivyteam.ivy.workflow.query.CaseQuery
aggregate, businessCases, create, executor, groupBy, orderBy, subCases, where

- Method Detail
  - caseId
```
public CaseQuery.OrderByColumnQuery 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 use caseId().descending()
    
    Example:
    
    CaseQuery.businessCases().orderBy().caseId()
    
    SQL part: ORDER BY CaseId ASC
    Specified by:
    
    caseId in interface CaseQuery.IOrderByQueryColumns
    
    Returns:
    
    query for further composition
    
    See Also:
    
    CaseQuery.IOrderByQueryColumns.caseId()
    
    API:
    
    This public API is available in IvyScript and Java. It has the visibility EXPERT.
  - businessCaseId
```
public CaseQuery.OrderByColumnQuery 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 use businessCaseId().descending()
    
    Example:
    
    CaseQuery.businessCases().orderBy().businessCaseId()
    
    SQL part: ORDER BY BusinessCaseId ASC
    Specified by:
    
    businessCaseId in interface CaseQuery.IOrderByQueryColumns
    
    Returns:
    
    query for further composition
    
    See Also:
    
    CaseQuery.IOrderByQueryColumns.businessCaseId()
    
    API:
    
    This public API is available in IvyScript and Java. It has the visibility EXPERT.
  - applicationId
```
public CaseQuery.OrderByColumnQuery 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 use applicationId().descending()
    
    Example:
    
    CaseQuery.businessCases().orderBy().applicationId()
    
    SQL part: ORDER BY ApplicationId ASC
    Specified by:
    
    applicationId in interface CaseQuery.IOrderByQueryColumns
    
    Returns:
    
    query for further composition
    
    See Also:
    
    CaseQuery.IOrderByQueryColumns.applicationId()
    
    API:
    
    This public API is available in IvyScript and Java. It has the visibility EXPERT.
  - processModelId
```
public CaseQuery.OrderByColumnQuery 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 use processModelId().descending()
    
    Example:
    
    CaseQuery.businessCases().orderBy().processModelId()
    
    SQL part: ORDER BY ProcessModelId ASC
    Specified by:
    
    processModelId in interface CaseQuery.IOrderByQueryColumns
    
    Returns:
    
    query for further composition
    
    See Also:
    
    CaseQuery.IOrderByQueryColumns.processModelId()
    
    API:
    
    This public API is available in IvyScript and Java. It has the visibility EXPERT.
  - taskStartId
```
public CaseQuery.OrderByColumnQuery 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 use taskStartId().descending()
    
    Example:
    
    CaseQuery.businessCases().orderBy().taskStartId()
    
    SQL part: ORDER BY TaskStartId ASC
    Specified by:
    
    taskStartId in interface CaseQuery.IOrderByQueryColumns
    
    Returns:
    
    query for further composition
    
    See Also:
    
    CaseQuery.IOrderByQueryColumns.taskStartId()
    
    API:
    
    This public API is available in IvyScript and Java. It has the visibility EXPERT.
  - activatorId
```
public CaseQuery.OrderByColumnQuery 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 use activatorId().descending()
    
    Example:
    
    CaseQuery.businessCases().orderBy().activatorId()
    
    SQL part: ORDER BY ActivatorId ASC
    Specified by:
    
    activatorId in interface CaseQuery.IOrderByQueryColumns
    
    Returns:
    
    query for further composition
    
    See Also:
    
    CaseQuery.IOrderByQueryColumns.activatorId()
    
    API:
    
    This public API is available in IvyScript and Java. It has the visibility EXPERT.
  - creatorId
```
public CaseQuery.OrderByColumnQuery 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 use creatorId().descending()
    
    Example:
    
    CaseQuery.businessCases().orderBy().creatorId()
    
    SQL part: ORDER BY CreatorId ASC
    Specified by:
    
    creatorId in interface CaseQuery.IOrderByQueryColumns
    
    Returns:
    
    query for further composition
    
    See Also:
    
    CaseQuery.IOrderByQueryColumns.creatorId()
    
    API:
    
    This public API is available in IvyScript and Java. It has the visibility EXPERT.
  - creatorUserName
```
public CaseQuery.OrderByColumnQuery 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 use creatorUserName().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 referenced Creator.
    Specified by:
    
    creatorUserName in interface CaseQuery.IOrderByQueryColumns
    
    Returns:
    
    query for further composition
    
    See Also:
    
    CaseQuery.IOrderByQueryColumns.creatorUserName()
    
    API:
    
    This public API is available in IvyScript and Java. It has the visibility EXPERT.
  - creatorUserDisplayName
```
public CaseQuery.OrderByColumnQuery 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 use creatorUserDisplayName().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 referenced Creator.
    Specified by:
    
    creatorUserDisplayName in interface CaseQuery.IOrderByQueryColumns
    
    Returns:
    
    query for further composition
    
    See Also:
    
    CaseQuery.IOrderByQueryColumns.creatorUserDisplayName()
    
    API:
    
    This public API is available in IvyScript and Java. It has the visibility EXPERT.
  - creatorTaskId
```
public CaseQuery.OrderByColumnQuery 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 use creatorTaskId().descending()
    
    Example:
    
    CaseQuery.businessCases().orderBy().creatorTaskId()
    
    SQL part: ORDER BY CreatorTaskId ASC
    Specified by:
    
    creatorTaskId in interface CaseQuery.IOrderByQueryColumns
    
    Returns:
    
    query for further composition
    
    See Also:
    
    CaseQuery.IOrderByQueryColumns.creatorTaskId()
    
    API:
    
    This public API is available in IvyScript and Java. It has the visibility EXPERT.
  - environment
```
public CaseQuery.OrderByColumnQuery environment()
```
    Description copied from interface: CaseQuery.IOrderByQueryColumns
    Adds an order by statement for the column Environment in the default direction ascending.
    To change the order to descending use environment().descending()
    
    Example:
    
    CaseQuery.businessCases().orderBy().environment()
    
    SQL part: ORDER BY Environment ASC
    Specified by:
    
    environment in interface CaseQuery.IOrderByQueryColumns
    
    Returns:
    
    query for further composition
    
    See Also:
    
    CaseQuery.IOrderByQueryColumns.environment()
    
    API:
    
    This public API is available in IvyScript and Java. It has the visibility EXPERT.
  - displayNameTemplate
```
public CaseQuery.OrderByColumnQuery displayNameTemplate()
```
    Description copied from interface: CaseQuery.IOrderByQueryColumns
    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
    Specified by:
    
    displayNameTemplate in interface CaseQuery.IOrderByQueryColumns
    
    Returns:
    
    query for further composition
    
    See Also:
    
    CaseQuery.IOrderByQueryColumns.displayNameTemplate()
    
    API:
    
    This public API is available in IvyScript and Java. It has the visibility EXPERT.
  - name
```
public CaseQuery.OrderByColumnQuery 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 use name().descending()
    
    Example:
    
    CaseQuery.businessCases().orderBy().name()
    
    SQL part: ORDER BY Name ASC
    Specified by:
    
    name in interface CaseQuery.IOrderByQueryColumns
    
    Returns:
    
    query for further composition
    
    See Also:
    
    CaseQuery.IOrderByQueryColumns.name()
    
    API:
    
    This public API is available in IvyScript and Java. It has the visibility EXPERT.
  - displayDescriptionTemplate
```
@Deprecated
public CaseQuery.OrderByColumnQuery displayDescriptionTemplate()
```
    Deprecated.
    
    Description copied from interface: CaseQuery.IOrderByQueryColumns
    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
    Specified by:
    
    displayDescriptionTemplate in interface CaseQuery.IOrderByQueryColumns
    
    Returns:
    
    query for further composition
    
    See Also:
    
    CaseQuery.IOrderByQueryColumns.displayDescriptionTemplate()
    
    API:
    
    This public API is available in IvyScript and Java. It has the visibility EXPERT.
  - description
```
@Deprecated
public CaseQuery.OrderByColumnQuery 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 use description().descending()
    
    Example:
    
    CaseQuery.businessCases().orderBy().description()
    
    SQL part: ORDER BY Description ASC
    Specified by:
    
    description in interface CaseQuery.IOrderByQueryColumns
    
    Returns:
    
    query for further composition
    
    See Also:
    
    CaseQuery.IOrderByQueryColumns.description()
    
    API:
    
    This public API is available in IvyScript and Java. It has the visibility EXPERT.
  - startTimestamp
```
public CaseQuery.OrderByColumnQuery 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 use startTimestamp().descending()
    
    Example:
    
    CaseQuery.businessCases().orderBy().startTimestamp()
    
    SQL part: ORDER BY StartTimestamp ASC
    Specified by:
    
    startTimestamp in interface CaseQuery.IOrderByQueryColumns
    
    Returns:
    
    query for further composition
    
    See Also:
    
    CaseQuery.IOrderByQueryColumns.startTimestamp()
    
    API:
    
    This public API is available in IvyScript and Java. It has the visibility EXPERT.
  - endTimestamp
```
public CaseQuery.OrderByColumnQuery 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 use endTimestamp().descending()
    
    Example:
    
    CaseQuery.businessCases().orderBy().endTimestamp()
    
    SQL part: ORDER BY EndTimestamp ASC
    Specified by:
    
    endTimestamp in interface CaseQuery.IOrderByQueryColumns
    
    Returns:
    
    query for further composition
    
    See Also:
    
    CaseQuery.IOrderByQueryColumns.endTimestamp()
    
    API:
    
    This public API is available in IvyScript and Java. It has the visibility EXPERT.
  - businessCalendar
```
public CaseQuery.OrderByColumnQuery 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 use businessCalendar().descending()
    
    Example:
    
    CaseQuery.businessCases().orderBy().businessCalendar()
    
    SQL part: ORDER BY BusinessCalendar ASC
    Specified by:
    
    businessCalendar in interface CaseQuery.IOrderByQueryColumns
    
    Returns:
    
    query for further composition
    
    See Also:
    
    CaseQuery.IOrderByQueryColumns.businessCalendar()
    
    API:
    
    This public API is available in IvyScript and Java. It has the visibility EXPERT.
  - workingTime
```
public CaseQuery.OrderByColumnQuery 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 use workingTime().descending()
    
    Example:
    
    CaseQuery.businessCases().orderBy().workingTime()
    
    SQL part: ORDER BY WorkingTime ASC
    Specified by:
    
    workingTime in interface CaseQuery.IOrderByQueryColumns
    
    Returns:
    
    query for further composition
    
    See Also:
    
    CaseQuery.IOrderByQueryColumns.workingTime()
    
    API:
    
    This public API is available in IvyScript and Java. It has the visibility EXPERT.
  - businessRuntime
```
public CaseQuery.OrderByColumnQuery 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 use businessRuntime().descending()
    
    Example:
    
    CaseQuery.businessCases().orderBy().businessRuntime()
    
    SQL part: ORDER BY BusinessRuntime ASC
    Specified by:
    
    businessRuntime in interface CaseQuery.IOrderByQueryColumns
    
    Returns:
    
    query for further composition
    
    See Also:
    
    CaseQuery.IOrderByQueryColumns.businessRuntime()
    
    API:
    
    This public API is available in IvyScript and Java. It has the visibility EXPERT.
  - state
```
public CaseQuery.OrderByColumnQuery 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 use state().descending()
    
    Example:
    
    CaseQuery.businessCases().orderBy().state()
    
    SQL part: ORDER BY State ASC
    Specified by:
    
    state in interface CaseQuery.IOrderByQueryColumns
    
    Returns:
    
    query for further composition
    
    See Also:
    
    CaseQuery.IOrderByQueryColumns.state()
    
    API:
    
    This public API is available in IvyScript and Java. It has the visibility EXPERT.
  - priority
```
public CaseQuery.OrderByColumnQuery 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 use priority().descending()
    
    Example:
    
    CaseQuery.businessCases().orderBy().priority()
    
    SQL part: ORDER BY Priority ASC
    Specified by:
    
    priority in interface CaseQuery.IOrderByQueryColumns
    
    Returns:
    
    query for further composition
    
    See Also:
    
    CaseQuery.IOrderByQueryColumns.priority()
    
    API:
    
    This public API is available in IvyScript and Java. It has the visibility EXPERT.
  - stage
```
public CaseQuery.OrderByColumnQuery 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 use stage().descending()
    
    Example:
    
    CaseQuery.businessCases().orderBy().stage()
    
    SQL part: ORDER BY Stage ASC
    Specified by:
    
    stage in interface CaseQuery.IOrderByQueryColumns
    
    Returns:
    
    query for further composition
    
    See Also:
    
    CaseQuery.IOrderByQueryColumns.stage()
    
    API:
    
    This public API is available in IvyScript and Java. It has the visibility EXPERT.
  - ownerId
```
public CaseQuery.OrderByColumnQuery 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 use ownerId().descending()
    
    Example:
    
    CaseQuery.businessCases().orderBy().ownerId()
    
    SQL part: ORDER BY OwnerId ASC
    Specified by:
    
    ownerId in interface CaseQuery.IOrderByQueryColumns
    
    Returns:
    
    query for further composition
    
    See Also:
    
    CaseQuery.IOrderByQueryColumns.ownerId()
    
    API:
    
    This public API is available in IvyScript and Java. It has the visibility EXPERT.
  - ownerName
```
public CaseQuery.OrderByColumnQuery 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 use ownerName().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 referenced Owner.
    Specified by:
    
    ownerName in interface CaseQuery.IOrderByQueryColumns
    
    Returns:
    
    query for further composition
    
    See Also:
    
    CaseQuery.IOrderByQueryColumns.ownerName()
    
    API:
    
    This public API is available in IvyScript and Java. It has the visibility EXPERT.
  - ownerDisplayName
```
public CaseQuery.OrderByColumnQuery 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 use ownerDisplayName().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 referenced Owner.
    Specified by:
    
    ownerDisplayName in interface CaseQuery.IOrderByQueryColumns
    
    Returns:
    
    query for further composition
    
    See Also:
    
    CaseQuery.IOrderByQueryColumns.ownerDisplayName()
    
    API:
    
    This public API is available in IvyScript and Java. It has the visibility EXPERT.
  - category
```
public CaseQuery.OrderByColumnQuery 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 use category().descending()
    
    Example:
    
    CaseQuery.businessCases().orderBy().category()
    
    SQL part: ORDER BY Category ASC
    Specified by:
    
    category in interface CaseQuery.IOrderByQueryColumns
    
    Returns:
    
    query for further composition
    
    See Also:
    
    CaseQuery.IOrderByQueryColumns.category()
    
    API:
    
    This public API is available in IvyScript and Java. It has the visibility EXPERT.
  - customField
```
public CaseQuery.ICustomFieldOrderBy 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 use customField().descending()
    
    Example:
    
    CaseQuery.businessCases().orderBy().customField().stringField("myStringField")
    Specified by:
    
    customField in interface CaseQuery.IOrderByQueryColumns
    
    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.

Class CaseQuery.OrderByQuery

Nested Class Summary

Nested classes/interfaces inherited from class ch.ivyteam.ivy.workflow.query.CaseQuery

Method Summary

Methods inherited from class ch.ivyteam.ivy.workflow.query.CaseQuery

Method Detail

caseId

businessCaseId

applicationId

processModelId

taskStartId

activatorId

creatorId

creatorUserName

creatorUserDisplayName

creatorTaskId

environment

displayNameTemplate

name

displayDescriptionTemplate

description

startTimestamp

endTimestamp

businessCalendar

workingTime

businessRuntime

state

priority

stage

ownerId

ownerName

ownerDisplayName

category

customField