Package ch.ivyteam.ivy.workflow.query

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 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

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	businessCalendarId()	Deprecated. use businessCalendar() instead
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	businessCorrespondentId()	Deprecated. use customField().numberField("BusinessCorrespondentId") instead
CaseQuery.OrderByColumnQuery	businessCreatorUser()	Deprecated. use customField().stringField("BusinessCreatorUser") instead
CaseQuery.OrderByColumnQuery	businessMainContactDocDbCode()	Deprecated. use customField().stringField("BusinessMainContactDocumentDbCode") instead
CaseQuery.OrderByColumnQuery	businessMainContactFolderId()	Deprecated. use customField().stringField("BusinessMainContactFolderId") instead
CaseQuery.OrderByColumnQuery	businessMainContactId()	Deprecated. use customField().numberField("BusinessMainContactId") instead
CaseQuery.OrderByColumnQuery	businessMainContactName()	Deprecated. use customField().stringField("BusinessMainContactName") instead
CaseQuery.OrderByColumnQuery	businessMainContactType()	Deprecated. use customField().stringField("BusinessMainContactType") instead
CaseQuery.OrderByColumnQuery	businessMilestoneTimestamp()	Deprecated. use customField().timestampField("BusinessMilestoneTimestamp") instead
CaseQuery.OrderByColumnQuery	businessObjectCode()	Deprecated. use customField().stringField("BusinessObjectCode") instead
CaseQuery.OrderByColumnQuery	businessObjectDocDbCode()	Deprecated. use customField().stringField("BusinessObjectDocumentDbCode") instead
CaseQuery.OrderByColumnQuery	businessObjectFolderId()	Deprecated. use customField().stringField("BusinessObjectFolderId") instead
CaseQuery.OrderByColumnQuery	businessObjectName()	Deprecated. use customField().stringField("BusinessObjectName") instead
CaseQuery.OrderByColumnQuery	businessPriority()	Deprecated. use customField().stringField("BusinessPriority") instead
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	businessStartTimestamp()	Deprecated. use customField().timestampField("BusinessStartTimestamp") instead
CaseQuery.OrderByColumnQuery	businessState()	Adds an order by statement for the column BusinessState in the default direction ascending. To change the order to descending use businessState().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	creatorUserId()	Deprecated, for removal: This API element is subject to removal in a future version. use creatorId() instead
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.OrderByColumnQuery	customDecimalField1()	Deprecated. use customField().numberField("CustomDecimalField1") instead
CaseQuery.OrderByColumnQuery	customDecimalField2()	Deprecated. use customField().numberField("CustomDecimalField2") instead
CaseQuery.OrderByColumnQuery	customDecimalField3()	Deprecated. use customField().numberField("CustomDecimalField3") instead
CaseQuery.OrderByColumnQuery	customDecimalField4()	Deprecated. use customField().numberField("CustomDecimalField4") instead
CaseQuery.OrderByColumnQuery	customDecimalField5()	Deprecated. use customField().numberField("CustomDecimalField5") instead
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	customTimestampField1()	Deprecated. use customField().timestampField("CustomTimestampField1") instead
CaseQuery.OrderByColumnQuery	customTimestampField2()	Deprecated. use customField().timestampField("CustomTimestampField2") instead
CaseQuery.OrderByColumnQuery	customTimestampField3()	Deprecated. use customField().timestampField("CustomTimestampField3") instead
CaseQuery.OrderByColumnQuery	customTimestampField4()	Deprecated. use customField().timestampField("CustomTimestampField4") instead
CaseQuery.OrderByColumnQuery	customTimestampField5()	Deprecated. use customField().timestampField("CustomTimestampField5") instead
CaseQuery.OrderByColumnQuery	customVarCharField1()	Deprecated. use customField().stringField("CustomVarCharField1") instead
CaseQuery.OrderByColumnQuery	customVarCharField2()	Deprecated. use customField().stringField("CustomVarCharField2") instead
CaseQuery.OrderByColumnQuery	customVarCharField3()	Deprecated. use customField().stringField("CustomVarCharField3") instead
CaseQuery.OrderByColumnQuery	customVarCharField4()	Deprecated. use customField().stringField("CustomVarCharField4") instead
CaseQuery.OrderByColumnQuery	customVarCharField5()	Deprecated. use customField().stringField("CustomVarCharField5") instead
CaseQuery.OrderByColumnQuery	description()	Deprecated. ordering by CLOB fields is not possible.
CaseQuery.OrderByColumnQuery	displayDescriptionTemplate()	Deprecated, for removal: This API element is subject to removal in a future version. the removed DisplayDescriptionTemplate column was never used in production.
CaseQuery.OrderByColumnQuery	displayNameTemplate()	Deprecated, for removal: This API element is subject to removal in a future version. the removed DisplayNameTemplate column was never used in production.
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	languageId()	Adds an order by statement for the column LanguageId in the default direction ascending. To change the order to descending use languageId().descending()
CaseQuery.OrderByColumnQuery	modifiedTimestamp()	Adds an order by statement for the column ModifiedTimestamp in the default direction ascending. To change the order to descending use modifiedTimestamp().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	ownerRoleId()	Deprecated, for removal: This API element is subject to removal in a future version. use ownerId() instead
CaseQuery.OrderByColumnQuery	ownerUserId()	Deprecated, for removal: This API element is subject to removal in a future version. use ownerId() instead
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	processCategoryCode()	Deprecated. use customField().stringField("ProcessCategoryCode") instead
CaseQuery.OrderByColumnQuery	processCategoryName()	Deprecated. use customField().stringField("ProcessCategoryName") instead
CaseQuery.OrderByColumnQuery	processCode()	Deprecated. use customField().stringField("ProcessCode") instead
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	processName()	Deprecated. use customField().stringField("ProcessName") instead
CaseQuery.OrderByColumnQuery	securitySystemId()	Adds an order by statement for the column SecuritySystemId in the default direction ascending. To change the order to descending use securitySystemId().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	subTypeCode()	Deprecated. use customField().stringField("SubTypeCode") instead
CaseQuery.OrderByColumnQuery	subTypeName()	Deprecated. use customField().stringField("SubTypeName") instead
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	typeCode()	Deprecated. use customField().stringField("TypeCode") instead
CaseQuery.OrderByColumnQuery	typeName()	Deprecated. use customField().stringField("TypeName") instead
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 Details

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 Java.

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 Java.

securitySystemId

CaseQuery.OrderByColumnQuery securitySystemId()

Adds an order by statement for the column SecuritySystemId in the default direction ascending.
To change the order to descending use securitySystemId().descending()

Example:

CaseQuery.businessCases().orderBy().securitySystemId()

SQL part: ORDER BY SecuritySystemId ASC

Returns:

query for further composition

See Also:

• CaseQuery.OrderByColumnQuery.descending()
• CaseQuery.OrderByColumnQuery.ascending()

API:

This public API is available in Java.

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 Java.

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 Java.

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 Java.

activatorId

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

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 Java.

creatorId

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

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 Java.

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

This is a virtual column. It contains the same value as the column Name of the referenced Creator.

Returns:

query for further composition

See Also:

• CaseQuery.OrderByColumnQuery.descending()
• CaseQuery.OrderByColumnQuery.ascending()

API:

This public API is available in Java.

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

This is a virtual column. It contains the same value as the column DisplayName of the referenced Creator.

Returns:

query for further composition

See Also:

• CaseQuery.OrderByColumnQuery.descending()
• CaseQuery.OrderByColumnQuery.ascending()

API:

This public API is available in Java.

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 Java.

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

This is a virtual column. It contains the same value as the column Name of the referenced CaseLocalized.

Returns:

query for further composition

See Also:

• CaseQuery.OrderByColumnQuery.descending()
• CaseQuery.OrderByColumnQuery.ascending()

API:

This public API is available in Java.

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 use description().descending()

Example:

CaseQuery.businessCases().orderBy().description()

SQL part: ORDER BY Description ASC

This is a virtual column. It contains the same value as the column Description of the referenced CaseLocalized.

Returns:

query for further composition

See Also:

• CaseQuery.OrderByColumnQuery.descending()
• CaseQuery.OrderByColumnQuery.ascending()

API:

This public API is available in Java.

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 Java.

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 Java.

modifiedTimestamp

CaseQuery.OrderByColumnQuery modifiedTimestamp()

Adds an order by statement for the column ModifiedTimestamp in the default direction ascending.
To change the order to descending use modifiedTimestamp().descending()

Example:

CaseQuery.create().orderBy().modifiedTimestamp()

SQL part: ORDER BY ModifiedTimestamp ASC

Returns:

query for further composition

See Also:

• CaseQuery.OrderByColumnQuery.descending()
• CaseQuery.OrderByColumnQuery.ascending()

API:

This public API is available in Java.

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 Java.

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 Java.

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 Java.

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 Java.

businessState

CaseQuery.OrderByColumnQuery businessState()

Adds an order by statement for the column BusinessState in the default direction ascending.
To change the order to descending use businessState().descending()

Example:

CaseQuery.businessCases().orderBy().businessState()

SQL part: ORDER BY BusinessState ASC

Returns:

query for further composition

See Also:

• CaseQuery.OrderByColumnQuery.descending()
• CaseQuery.OrderByColumnQuery.ascending()

API:

This public API is available in Java.

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 Java.

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 Java.

ownerId

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

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 Java.

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

This is a virtual column. It contains the same value as the column MemberName of the referenced Owner.

Returns:

query for further composition

See Also:

• CaseQuery.OrderByColumnQuery.descending()
• CaseQuery.OrderByColumnQuery.ascending()

API:

This public API is available in Java.

ownerDisplayName

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

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.

Returns:

query for further composition

See Also:

• CaseQuery.OrderByColumnQuery.descending()
• CaseQuery.OrderByColumnQuery.ascending()

API:

This public API is available in Java.

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 Java.

languageId

CaseQuery.OrderByColumnQuery languageId()

Adds an order by statement for the column LanguageId in the default direction ascending.
To change the order to descending use languageId().descending()

Example:

CaseQuery.businessCases().orderBy().languageId()

SQL part: ORDER BY LanguageId ASC

This is a virtual column. It contains the same value as the column LanguageId of the referenced CaseLocalized.

Returns:

query for further composition

See Also:

• CaseQuery.OrderByColumnQuery.descending()
• CaseQuery.OrderByColumnQuery.ascending()

API:

This public API is available in Java.

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 Java.

customVarCharField1

@Deprecated
CaseQuery.OrderByColumnQuery customVarCharField1()

Deprecated.

use customField().stringField("CustomVarCharField1") instead

Adds an order by statement for the custom field "CustomVarCharField1" in the default direction ascending.
To change the order to descending use customVarCharField1().descending()

Example:

CaseQuery.businessCases().orderBy().customVarCharField1()

Returns:

query for further composition

See Also:

• CaseQuery.OrderByColumnQuery.descending()
• CaseQuery.OrderByColumnQuery.ascending()

API:

This public API is available in Java.

customVarCharField2

@Deprecated
CaseQuery.OrderByColumnQuery customVarCharField2()

Deprecated.

use customField().stringField("CustomVarCharField2") instead

Adds an order by statement for the custom field "CustomVarCharField2" in the default direction ascending.
To change the order to descending use customVarCharField2().descending()

Example:

CaseQuery.businessCases().orderBy().customVarCharField2()

Returns:

query for further composition

See Also:

• CaseQuery.OrderByColumnQuery.descending()
• CaseQuery.OrderByColumnQuery.ascending()

API:

This public API is available in Java.

customVarCharField3

@Deprecated
CaseQuery.OrderByColumnQuery customVarCharField3()

Deprecated.

use customField().stringField("CustomVarCharField3") instead

Adds an order by statement for the custom field "CustomVarCharField3" in the default direction ascending.
To change the order to descending use customVarCharField3().descending()

Example:

CaseQuery.businessCases().orderBy().customVarCharField3()

Returns:

query for further composition

See Also:

• CaseQuery.OrderByColumnQuery.descending()
• CaseQuery.OrderByColumnQuery.ascending()

API:

This public API is available in Java.

customVarCharField4

@Deprecated
CaseQuery.OrderByColumnQuery customVarCharField4()

Deprecated.

use customField().stringField("CustomVarCharField4") instead

Adds an order by statement for the custom field "CustomVarCharField4" in the default direction ascending.
To change the order to descending use customVarCharField4().descending()

Example:

CaseQuery.businessCases().orderBy().customVarCharField4()

Returns:

query for further composition

See Also:

• CaseQuery.OrderByColumnQuery.descending()
• CaseQuery.OrderByColumnQuery.ascending()

API:

This public API is available in Java.

customVarCharField5

@Deprecated
CaseQuery.OrderByColumnQuery customVarCharField5()

Deprecated.

use customField().stringField("CustomVarCharField5") instead

Adds an order by statement for the custom field "CustomVarCharField5" in the default direction ascending.
To change the order to descending use customVarCharField5().descending()

Example:

CaseQuery.businessCases().orderBy().customVarCharField5()

Returns:

query for further composition

See Also:

• CaseQuery.OrderByColumnQuery.descending()
• CaseQuery.OrderByColumnQuery.ascending()

API:

This public API is available in Java.

customDecimalField1

@Deprecated
CaseQuery.OrderByColumnQuery customDecimalField1()

Deprecated.

use customField().numberField("CustomDecimalField1") instead

Adds an order by statement for the custom field "CustomDecimalField1" in the default direction ascending.
To change the order to descending use customDecimalField1().descending()

Example:

CaseQuery.businessCases().orderBy().customDecimalField1()

Returns:

query for further composition

See Also:

• CaseQuery.OrderByColumnQuery.descending()
• CaseQuery.OrderByColumnQuery.ascending()

API:

This public API is available in Java.

customDecimalField2

@Deprecated
CaseQuery.OrderByColumnQuery customDecimalField2()

Deprecated.

use customField().numberField("CustomDecimalField2") instead

Adds an order by statement for the custom field "CustomDecimalField2" in the default direction ascending.
To change the order to descending use customDecimalField2().descending()

Example:

CaseQuery.businessCases().orderBy().customDecimalField2()

Returns:

query for further composition

See Also:

• CaseQuery.OrderByColumnQuery.descending()
• CaseQuery.OrderByColumnQuery.ascending()

API:

This public API is available in Java.

customDecimalField3

@Deprecated
CaseQuery.OrderByColumnQuery customDecimalField3()

Deprecated.

use customField().numberField("CustomDecimalField3") instead

Adds an order by statement for the custom field "CustomDecimalField3" in the default direction ascending.
To change the order to descending use customDecimalField3().descending()

Example:

CaseQuery.businessCases().orderBy().customDecimalField3()

Returns:

query for further composition

See Also:

• CaseQuery.OrderByColumnQuery.descending()
• CaseQuery.OrderByColumnQuery.ascending()

API:

This public API is available in Java.

customDecimalField4

@Deprecated
CaseQuery.OrderByColumnQuery customDecimalField4()

Deprecated.

use customField().numberField("CustomDecimalField4") instead

Adds an order by statement for the custom field "CustomDecimalField4" in the default direction ascending.
To change the order to descending use customDecimalField4().descending()

Example:

CaseQuery.businessCases().orderBy().customDecimalField4()

Returns:

query for further composition

See Also:

• CaseQuery.OrderByColumnQuery.descending()
• CaseQuery.OrderByColumnQuery.ascending()

API:

This public API is available in Java.

customDecimalField5

@Deprecated
CaseQuery.OrderByColumnQuery customDecimalField5()

Deprecated.

use customField().numberField("CustomDecimalField5") instead

Adds an order by statement for the custom field "CustomDecimalField5" in the default direction ascending.
To change the order to descending use customDecimalField5().descending()

Example:

CaseQuery.businessCases().orderBy().customDecimalField5()

Returns:

query for further composition

See Also:

• CaseQuery.OrderByColumnQuery.descending()
• CaseQuery.OrderByColumnQuery.ascending()

API:

This public API is available in Java.

customTimestampField1

@Deprecated
CaseQuery.OrderByColumnQuery customTimestampField1()

Deprecated.

use customField().timestampField("CustomTimestampField1") instead

Adds an order by statement for the custom field "CustomTimestampField1" in the default direction ascending.
To change the order to descending use customTimestampField1().descending()

Example:

CaseQuery.businessCases().orderBy().customTimestampField1()

Returns:

query for further composition

See Also:

• CaseQuery.OrderByColumnQuery.descending()
• CaseQuery.OrderByColumnQuery.ascending()

API:

This public API is available in Java.

customTimestampField2

@Deprecated
CaseQuery.OrderByColumnQuery customTimestampField2()

Deprecated.

use customField().timestampField("CustomTimestampField2") instead

Adds an order by statement for the custom field "CustomTimestampField2" in the default direction ascending.
To change the order to descending use customTimestampField2().descending()

Example:

CaseQuery.businessCases().orderBy().customTimestampField2()

Returns:

query for further composition

See Also:

• CaseQuery.OrderByColumnQuery.descending()
• CaseQuery.OrderByColumnQuery.ascending()

API:

This public API is available in Java.

customTimestampField3

@Deprecated
CaseQuery.OrderByColumnQuery customTimestampField3()

Deprecated.

use customField().timestampField("CustomTimestampField3") instead

Adds an order by statement for the custom field "CustomTimestampField3" in the default direction ascending.
To change the order to descending use customTimestampField3().descending()

Example:

CaseQuery.businessCases().orderBy().customTimestampField3()

Returns:

query for further composition

See Also:

• CaseQuery.OrderByColumnQuery.descending()
• CaseQuery.OrderByColumnQuery.ascending()

API:

This public API is available in Java.

customTimestampField4

@Deprecated
CaseQuery.OrderByColumnQuery customTimestampField4()

Deprecated.

use customField().timestampField("CustomTimestampField4") instead

Adds an order by statement for the custom field "CustomTimestampField4" in the default direction ascending.
To change the order to descending use customTimestampField4().descending()

Example:

CaseQuery.businessCases().orderBy().customTimestampField4()

Returns:

query for further composition

See Also:

• CaseQuery.OrderByColumnQuery.descending()
• CaseQuery.OrderByColumnQuery.ascending()

API:

This public API is available in Java.

customTimestampField5

@Deprecated
CaseQuery.OrderByColumnQuery customTimestampField5()

Deprecated.

use customField().timestampField("CustomTimestampField5") instead

Adds an order by statement for the custom field "CustomTimestampField5" in the default direction ascending.
To change the order to descending use customTimestampField5().descending()

Example:

CaseQuery.businessCases().orderBy().customTimestampField5()

Returns:

query for further composition

See Also:

• CaseQuery.OrderByColumnQuery.descending()
• CaseQuery.OrderByColumnQuery.ascending()

API:

This public API is available in Java.

businessMilestoneTimestamp

@Deprecated
CaseQuery.OrderByColumnQuery businessMilestoneTimestamp()

Deprecated.

use customField().timestampField("BusinessMilestoneTimestamp") instead

Adds an order by statement for the custom field "BusinessMilestoneTimestamp" in the default direction ascending.
To change the order to descending use businessMilestoneTimestamp().descending()

Example:

CaseQuery.businessCases().orderBy().businessMilestoneTimestamp()

Returns:

query for further composition

See Also:

• CaseQuery.OrderByColumnQuery.descending()
• CaseQuery.OrderByColumnQuery.ascending()

API:

This public API is available in Java.

businessCreatorUser

@Deprecated
CaseQuery.OrderByColumnQuery businessCreatorUser()

Deprecated.

use customField().stringField("BusinessCreatorUser") instead

Adds an order by statement for the custom field "BusinessCreatorUser" in the default direction ascending.
To change the order to descending use businessCreatorUser().descending()

Example:

CaseQuery.businessCases().orderBy().businessCreatorUser()

Returns:

query for further composition

See Also:

• CaseQuery.OrderByColumnQuery.descending()
• CaseQuery.OrderByColumnQuery.ascending()

API:

This public API is available in Java.

businessMainContactId

@Deprecated
CaseQuery.OrderByColumnQuery businessMainContactId()

Deprecated.

use customField().numberField("BusinessMainContactId") instead

Adds an order by statement for the custom field "BusinessMainContactId" in the default direction ascending.
To change the order to descending use businessMainContactId().descending()

Example:

CaseQuery.businessCases().orderBy().businessMainContactId()

Returns:

query for further composition

See Also:

• CaseQuery.OrderByColumnQuery.descending()
• CaseQuery.OrderByColumnQuery.ascending()

API:

This public API is available in Java.

businessMainContactName

@Deprecated
CaseQuery.OrderByColumnQuery businessMainContactName()

Deprecated.

use customField().stringField("BusinessMainContactName") instead

Adds an order by statement for the custom field "BusinessMainContactName" in the default direction ascending.
To change the order to descending use businessMainContactName().descending()

Example:

CaseQuery.businessCases().orderBy().businessMainContactName()

Returns:

query for further composition

See Also:

• CaseQuery.OrderByColumnQuery.descending()
• CaseQuery.OrderByColumnQuery.ascending()

API:

This public API is available in Java.

businessObjectCode

@Deprecated
CaseQuery.OrderByColumnQuery businessObjectCode()

Deprecated.

use customField().stringField("BusinessObjectCode") instead

Adds an order by statement for the custom field "BusinessObjectCode" in the default direction ascending.
To change the order to descending use businessObjectCode().descending()

Example:

CaseQuery.businessCases().orderBy().businessObjectCode()

Returns:

query for further composition

See Also:

• CaseQuery.OrderByColumnQuery.descending()
• CaseQuery.OrderByColumnQuery.ascending()

API:

This public API is available in Java.

businessObjectName

@Deprecated
CaseQuery.OrderByColumnQuery businessObjectName()

Deprecated.

use customField().stringField("BusinessObjectName") instead

Adds an order by statement for the custom field "BusinessObjectName" in the default direction ascending.
To change the order to descending use businessObjectName().descending()

Example:

CaseQuery.businessCases().orderBy().businessObjectName()

Returns:

query for further composition

See Also:

• CaseQuery.OrderByColumnQuery.descending()
• CaseQuery.OrderByColumnQuery.ascending()

API:

This public API is available in Java.

businessStartTimestamp

@Deprecated
CaseQuery.OrderByColumnQuery businessStartTimestamp()

Deprecated.

use customField().timestampField("BusinessStartTimestamp") instead

Adds an order by statement for the custom field "BusinessStartTimestamp" in the default direction ascending.
To change the order to descending use businessStartTimestamp().descending()

Example:

CaseQuery.businessCases().orderBy().businessStartTimestamp()

Returns:

query for further composition

See Also:

• CaseQuery.OrderByColumnQuery.descending()
• CaseQuery.OrderByColumnQuery.ascending()

API:

This public API is available in Java.

businessObjectFolderId

@Deprecated
CaseQuery.OrderByColumnQuery businessObjectFolderId()

Deprecated.

use customField().stringField("BusinessObjectFolderId") instead

Adds an order by statement for the custom field "BusinessObjectFolderId" in the default direction ascending.
To change the order to descending use businessObjectFolderId().descending()

Example:

CaseQuery.businessCases().orderBy().businessObjectFolderId()

Returns:

query for further composition

See Also:

• CaseQuery.OrderByColumnQuery.descending()
• CaseQuery.OrderByColumnQuery.ascending()

API:

This public API is available in Java.

businessObjectDocDbCode

@Deprecated
CaseQuery.OrderByColumnQuery businessObjectDocDbCode()

Deprecated.

use customField().stringField("BusinessObjectDocumentDbCode") instead

Adds an order by statement for the custom field "BusinessObjectDocumentDbCode" in the default direction ascending.
To change the order to descending use businessObjectDocDbCode().descending()

Example:

CaseQuery.businessCases().orderBy().businessObjectDocDbCode()

Returns:

query for further composition

See Also:

• CaseQuery.OrderByColumnQuery.descending()
• CaseQuery.OrderByColumnQuery.ascending()

API:

This public API is available in Java.

businessMainContactDocDbCode

@Deprecated
CaseQuery.OrderByColumnQuery businessMainContactDocDbCode()

Deprecated.

use customField().stringField("BusinessMainContactDocumentDbCode") instead

Adds an order by statement for the custom field "BusinessMainContactDocumentDbCode" in the default direction ascending.
To change the order to descending use businessMainContactDocDbCode().descending()

Example:

CaseQuery.businessCases().orderBy().businessMainContactDocDbCode()

Returns:

query for further composition

See Also:

• CaseQuery.OrderByColumnQuery.descending()
• CaseQuery.OrderByColumnQuery.ascending()

API:

This public API is available in Java.

businessMainContactFolderId

@Deprecated
CaseQuery.OrderByColumnQuery businessMainContactFolderId()

Deprecated.

use customField().stringField("BusinessMainContactFolderId") instead

Adds an order by statement for the custom field "BusinessMainContactFolderId" in the default direction ascending.
To change the order to descending use businessMainContactFolderId().descending()

Example:

CaseQuery.businessCases().orderBy().businessMainContactFolderId()

Returns:

query for further composition

See Also:

• CaseQuery.OrderByColumnQuery.descending()
• CaseQuery.OrderByColumnQuery.ascending()

API:

This public API is available in Java.

businessPriority

@Deprecated
CaseQuery.OrderByColumnQuery businessPriority()

Deprecated.

use customField().stringField("BusinessPriority") instead

Adds an order by statement for the custom field "BusinessPriority" in the default direction ascending.
To change the order to descending use businessPriority().descending()

Example:

CaseQuery.businessCases().orderBy().businessPriority()

Returns:

query for further composition

See Also:

• CaseQuery.OrderByColumnQuery.descending()
• CaseQuery.OrderByColumnQuery.ascending()

API:

This public API is available in Java.

businessMainContactType

@Deprecated
CaseQuery.OrderByColumnQuery businessMainContactType()

Deprecated.

use customField().stringField("BusinessMainContactType") instead

Adds an order by statement for the custom field "BusinessMainContactType" in the default direction ascending.
To change the order to descending use businessMainContactType().descending()

Example:

CaseQuery.businessCases().orderBy().businessMainContactType()

Returns:

query for further composition

See Also:

• CaseQuery.OrderByColumnQuery.descending()
• CaseQuery.OrderByColumnQuery.ascending()

API:

This public API is available in Java.

businessCorrespondentId

@Deprecated
CaseQuery.OrderByColumnQuery businessCorrespondentId()

Deprecated.

use customField().numberField("BusinessCorrespondentId") instead

Adds an order by statement for the custom field "BusinessCorrespondentId" in the default direction ascending.
To change the order to descending use businessCorrespondentId().descending()

Example:

CaseQuery.businessCases().orderBy().businessCorrespondentId()

Returns:

query for further composition

See Also:

• CaseQuery.OrderByColumnQuery.descending()
• CaseQuery.OrderByColumnQuery.ascending()

API:

This public API is available in Java.

processCode

@Deprecated
CaseQuery.OrderByColumnQuery processCode()

Deprecated.

use customField().stringField("ProcessCode") instead

Adds an order by statement for the custom field "ProcessCode" in the default direction ascending.
To change the order to descending use processCode().descending()

Example:

CaseQuery.businessCases().orderBy().processCode()

Returns:

query for further composition

See Also:

• CaseQuery.OrderByColumnQuery.descending()
• CaseQuery.OrderByColumnQuery.ascending()

API:

This public API is available in Java.

processName

@Deprecated
CaseQuery.OrderByColumnQuery processName()

Deprecated.

use customField().stringField("ProcessName") instead

Adds an order by statement for the custom field "ProcessName" in the default direction ascending.
To change the order to descending use processName().descending()

Example:

CaseQuery.businessCases().orderBy().processName()

Returns:

query for further composition

See Also:

• CaseQuery.OrderByColumnQuery.descending()
• CaseQuery.OrderByColumnQuery.ascending()

API:

This public API is available in Java.

processCategoryCode

@Deprecated
CaseQuery.OrderByColumnQuery processCategoryCode()

Deprecated.

use customField().stringField("ProcessCategoryCode") instead

Adds an order by statement for the custom field "ProcessCategoryCode" in the default direction ascending.
To change the order to descending use processCategoryCode().descending()

Example:

CaseQuery.businessCases().orderBy().processCategoryCode()

Returns:

query for further composition

See Also:

• CaseQuery.OrderByColumnQuery.descending()
• CaseQuery.OrderByColumnQuery.ascending()

API:

This public API is available in Java.

processCategoryName

@Deprecated
CaseQuery.OrderByColumnQuery processCategoryName()

Deprecated.

use customField().stringField("ProcessCategoryName") instead

Adds an order by statement for the custom field "ProcessCategoryName" in the default direction ascending.
To change the order to descending use processCategoryName().descending()

Example:

CaseQuery.businessCases().orderBy().processCategoryName()

Returns:

query for further composition

See Also:

• CaseQuery.OrderByColumnQuery.descending()
• CaseQuery.OrderByColumnQuery.ascending()

API:

This public API is available in Java.

typeCode

@Deprecated
CaseQuery.OrderByColumnQuery typeCode()

Deprecated.

use customField().stringField("TypeCode") instead

Adds an order by statement for the custom field "TypeCode" in the default direction ascending.
To change the order to descending use typeCode().descending()

Example:

CaseQuery.businessCases().orderBy().typeCode()

Returns:

query for further composition

See Also:

• CaseQuery.OrderByColumnQuery.descending()
• CaseQuery.OrderByColumnQuery.ascending()

API:

This public API is available in Java.

typeName

@Deprecated
CaseQuery.OrderByColumnQuery typeName()

Deprecated.

use customField().stringField("TypeName") instead

Adds an order by statement for the custom field "TypeName" in the default direction ascending.
To change the order to descending use typeName().descending()

Example:

CaseQuery.businessCases().orderBy().typeName()

Returns:

query for further composition

See Also:

• CaseQuery.OrderByColumnQuery.descending()
• CaseQuery.OrderByColumnQuery.ascending()

API:

This public API is available in Java.

subTypeCode

@Deprecated
CaseQuery.OrderByColumnQuery subTypeCode()

Deprecated.

use customField().stringField("SubTypeCode") instead

Adds an order by statement for the custom field "SubTypeCode" in the default direction ascending.
To change the order to descending use subTypeCode().descending()

Example:

CaseQuery.businessCases().orderBy().subTypeCode()

Returns:

query for further composition

See Also:

• CaseQuery.OrderByColumnQuery.descending()
• CaseQuery.OrderByColumnQuery.ascending()

API:

This public API is available in Java.

subTypeName

@Deprecated
CaseQuery.OrderByColumnQuery subTypeName()

Deprecated.

use customField().stringField("SubTypeName") instead

Adds an order by statement for the custom field "SubTypeName" in the default direction ascending.
To change the order to descending use subTypeName().descending()

Example:

CaseQuery.businessCases().orderBy().subTypeName()

Returns:

query for further composition

See Also:

• CaseQuery.OrderByColumnQuery.descending()
• CaseQuery.OrderByColumnQuery.ascending()

API:

This public API is available in Java.

creatorUserId

@Deprecated(since="9.1",
            forRemoval=true)
CaseQuery.OrderByColumnQuery creatorUserId()

Deprecated, for removal: This API element is subject to removal in a future version.

use creatorId() instead

Adds an order by statement for the legacy 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

API:

This public API is available in Java.

ownerRoleId

@Deprecated(since="9.1",
            forRemoval=true)
CaseQuery.OrderByColumnQuery ownerRoleId()

Deprecated, for removal: This API element is subject to removal in a future version.

use ownerId() instead

Adds an order by statement for the legacy 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

API:

This public API is available in Java.

ownerUserId

@Deprecated(since="9.1",
            forRemoval=true)
CaseQuery.OrderByColumnQuery ownerUserId()

Deprecated, for removal: This API element is subject to removal in a future version.

use ownerId() instead

Adds an order by statement for the legacy 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

API:

This public API is available in Java.

businessCalendarId

@Deprecated
CaseQuery.OrderByColumnQuery businessCalendarId()

Deprecated.

use businessCalendar() instead

This method is deprecated. Instead of adding an order by statement for the column BusinessCalendarId it adds one for the column BusinessCalendar in the default direction ascending.
To change the order to descending use businessCalendarId().descending()

Example:

TaskQuery.create().orderBy().businessCalendarId()

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 Java.

displayNameTemplate

@Deprecated(since="9.4",
            forRemoval=true)
CaseQuery.OrderByColumnQuery displayNameTemplate()

Deprecated, for removal: This API element is subject to removal in a future version.

the removed DisplayNameTemplate column was never used in production.

Orders by primary key because column DisplayNameTemplate was removed without any replacement.

Returns:

query for further composition

See Also:

• CaseQuery.OrderByColumnQuery.descending()
• CaseQuery.OrderByColumnQuery.ascending()

API:

This public API is available in Java.

displayDescriptionTemplate

@Deprecated(since="9.1",
            forRemoval=true)
CaseQuery.OrderByColumnQuery displayDescriptionTemplate()

Deprecated, for removal: This API element is subject to removal in a future version.

the removed DisplayDescriptionTemplate column was never used in production.

Orders by primary key because column DisplayDescriptionTemplate was removed without any replacement.

Returns:

query for further composition

See Also:

• CaseQuery.OrderByColumnQuery.descending()
• CaseQuery.OrderByColumnQuery.ascending()

API:

This public API is available in Java.