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.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
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()`

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.
  - creatorUserId
```
public CaseQuery.OrderByColumnQuery creatorUserId()
```
    Description copied from interface: CaseQuery.IOrderByQueryColumns
    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
    Specified by:
    
    creatorUserId in interface CaseQuery.IOrderByQueryColumns
    
    Returns:
    
    query for further composition
    
    See Also:
    
    CaseQuery.IOrderByQueryColumns.creatorUserId()
    
    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
    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
    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.
  - environmentId
```
public CaseQuery.OrderByColumnQuery environmentId()
```
    Description copied from interface: CaseQuery.IOrderByQueryColumns
    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
    Specified by:
    
    environmentId in interface CaseQuery.IOrderByQueryColumns
    
    Returns:
    
    query for further composition
    
    See Also:
    
    CaseQuery.IOrderByQueryColumns.environmentId()
    
    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
```
public CaseQuery.OrderByColumnQuery displayDescriptionTemplate()
```
    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
```
public CaseQuery.OrderByColumnQuery description()
```
    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.
  - ownerRoleId
```
public CaseQuery.OrderByColumnQuery ownerRoleId()
```
    Description copied from interface: CaseQuery.IOrderByQueryColumns
    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
    Specified by:
    
    ownerRoleId in interface CaseQuery.IOrderByQueryColumns
    
    Returns:
    
    query for further composition
    
    See Also:
    
    CaseQuery.IOrderByQueryColumns.ownerRoleId()
    
    API:
    
    This public API is available in IvyScript and Java. It has the visibility EXPERT.
  - ownerUserId
```
public CaseQuery.OrderByColumnQuery ownerUserId()
```
    Description copied from interface: CaseQuery.IOrderByQueryColumns
    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
    Specified by:
    
    ownerUserId in interface CaseQuery.IOrderByQueryColumns
    
    Returns:
    
    query for further composition
    
    See Also:
    
    CaseQuery.IOrderByQueryColumns.ownerUserId()
    
    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
    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.
  - 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

creatorUserId

creatorUserName

creatorUserDisplayName

creatorTaskId

environmentId

displayNameTemplate

name

displayDescriptionTemplate

description

startTimestamp

endTimestamp

businessCalendar

workingTime

businessRuntime

state

priority

stage

ownerRoleId

ownerUserId

ownerName

category

customField