Package ch.ivyteam.ivy.workflow.query

Class CaseQuery.OrderByQuery

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

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

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.OrderByColumnQuery.descending()
• CaseQuery.OrderByColumnQuery.ascending()

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.OrderByColumnQuery.descending()
• CaseQuery.OrderByColumnQuery.ascending()

API:

This public API is available in IvyScript and Java. It has the visibility EXPERT.

securitySystemId

public CaseQuery.OrderByColumnQuery securitySystemId()

Description copied from interface: CaseQuery.IOrderByQueryColumns

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

Specified by:

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

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.OrderByColumnQuery.descending()
• CaseQuery.OrderByColumnQuery.ascending()

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.OrderByColumnQuery.descending()
• CaseQuery.OrderByColumnQuery.ascending()

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.OrderByColumnQuery.descending()
• CaseQuery.OrderByColumnQuery.ascending()

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.OrderByColumnQuery.descending()
• CaseQuery.OrderByColumnQuery.ascending()

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.OrderByColumnQuery.descending()
• CaseQuery.OrderByColumnQuery.ascending()

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.OrderByColumnQuery.descending()
• CaseQuery.OrderByColumnQuery.ascending()

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.OrderByColumnQuery.descending()
• CaseQuery.OrderByColumnQuery.ascending()

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.OrderByColumnQuery.descending()
• CaseQuery.OrderByColumnQuery.ascending()

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.OrderByColumnQuery.descending()
• CaseQuery.OrderByColumnQuery.ascending()

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

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

Specified by:

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

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

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

Specified by:

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

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.OrderByColumnQuery.descending()
• CaseQuery.OrderByColumnQuery.ascending()

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.OrderByColumnQuery.descending()
• CaseQuery.OrderByColumnQuery.ascending()

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.OrderByColumnQuery.descending()
• CaseQuery.OrderByColumnQuery.ascending()

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.OrderByColumnQuery.descending()
• CaseQuery.OrderByColumnQuery.ascending()

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.OrderByColumnQuery.descending()
• CaseQuery.OrderByColumnQuery.ascending()

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.OrderByColumnQuery.descending()
• CaseQuery.OrderByColumnQuery.ascending()

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.OrderByColumnQuery.descending()
• CaseQuery.OrderByColumnQuery.ascending()

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.OrderByColumnQuery.descending()
• CaseQuery.OrderByColumnQuery.ascending()

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.OrderByColumnQuery.descending()
• CaseQuery.OrderByColumnQuery.ascending()

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.OrderByColumnQuery.descending()
• CaseQuery.OrderByColumnQuery.ascending()

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.OrderByColumnQuery.descending()
• CaseQuery.OrderByColumnQuery.ascending()

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.OrderByColumnQuery.descending()
• CaseQuery.OrderByColumnQuery.ascending()

API:

This public API is available in IvyScript and Java. It has the visibility EXPERT.

languageId

public CaseQuery.OrderByColumnQuery languageId()

Description copied from interface: CaseQuery.IOrderByQueryColumns

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.

Specified by:

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

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.