Package ch.ivyteam.ivy.workflow.query

Class CaseQuery.OrderByColumnQuery

java.lang.Object

ch.ivyteam.ivy.persistence.query.Query<ICase>

ch.ivyteam.ivy.workflow.query.CaseQuery

ch.ivyteam.ivy.workflow.query.CaseQuery.OrderByQuery

ch.ivyteam.ivy.workflow.query.CaseQuery.OrderByColumnQuery

All Implemented Interfaces:

CaseQuery.IOrderByQueryColumns

Enclosing class:

CaseQuery

public static class CaseQuery.OrderByColumnQuery
extends CaseQuery.OrderByQuery

Provides methods to define the direction of the sorting either ascending or descending.

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.OrderByQuery	ascending()	Sorts the column in ascending direction.
CaseQuery.OrderByQuery	ascendingNullFirst()	Sorts the column in ascending direction, with NULL values at the beginning of the list.
CaseQuery.OrderByQuery	ascendingNullLast()	Sorts the column in ascending direction, with NULL values at the end of the list.
CaseQuery.OrderByQuery	descending()	Sorts the column in descending direction.
CaseQuery.OrderByQuery	descendingNullFirst()	Sorts the column in descending direction, with NULL values at the beginning of the list.
CaseQuery.OrderByQuery	descendingNullLast()	Sorts the column in descending direction, with NULL values at the end of the list.

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

activatorId, applicationId, businessCalendar, businessCaseId, businessRuntime, caseId, category, creatorId, creatorTaskId, creatorUserDisplayName, creatorUserName, customField, description, displayDescriptionTemplate, displayNameTemplate, endTimestamp, environmentId, name, ownerDisplayName, ownerId, ownerName, priority, processModelId, stage, startTimestamp, state, taskStartId, workingTime

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

aggregate, businessCases, create, executor, groupBy, orderBy, subCases, where

Method Detail

ascending

public CaseQuery.OrderByQuery ascending()

Sorts the column in ascending direction.

Example:

CaseQuery.businessCases().orderBy().name().ascending()

SQL part: ORDER BY [column] ASC

Returns:

query for further composition

API:

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

ascendingNullFirst

public CaseQuery.OrderByQuery ascendingNullFirst()

Sorts the column in ascending direction, with NULL values at the beginning of the list.

Example:

CaseQuery.businessCases().orderBy().name().ascendingNullFirst()

SQL part: ORDER BY (CASE WHEN [column] IS NULL THEN 0 ELSE 1 END), [column] ASC

Returns:

query for further composition

API:

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

ascendingNullLast

public CaseQuery.OrderByQuery ascendingNullLast()

Sorts the column in ascending direction, with NULL values at the end of the list.

Example:

CaseQuery.businessCases().orderBy().name().ascendingNullLast()

SQL part: ORDER BY (CASE WHEN [column] IS NULL THEN 1 ELSE 0 END), [column] ASC

Returns:

query for further composition

API:

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

descending

public CaseQuery.OrderByQuery descending()

Sorts the column in descending direction.

Example:

CaseQuery.businessCases().orderBy().name().descending()

SQL part: ORDER BY [column] DESC

Returns:

query for further composition

API:

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

descendingNullFirst

public CaseQuery.OrderByQuery descendingNullFirst()

Sorts the column in descending direction, with NULL values at the beginning of the list.

Example:

CaseQuery.businessCases().orderBy().name().descendingNullFirst()

SQL part: ORDER BY (CASE WHEN [column] IS NULL THEN 0 ELSE 1 END), [column] DESC

Returns:

query for further composition

API:

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

descendingNullLast

public CaseQuery.OrderByQuery descendingNullLast()

Sorts the column in descending direction, with NULL values at the end of the list.

Example:

CaseQuery.businessCases().orderBy().name().descendingNullLast()

SQL part: ORDER BY (CASE WHEN [column] IS NULL THEN 1 ELSE 0 END), [column] DESC

Returns:

query for further composition

API:

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