Package ch.ivyteam.ivy.workflow.query

Class TaskQuery.OrderByColumnQuery

java.lang.Object

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

ch.ivyteam.ivy.workflow.query.TaskQuery

ch.ivyteam.ivy.workflow.query.TaskQuery.OrderByQuery

ch.ivyteam.ivy.workflow.query.TaskQuery.OrderByColumnQuery

All Implemented Interfaces:

TaskQuery.IOrderByQueryColumns

Enclosing class:

TaskQuery

public static class TaskQuery.OrderByColumnQuery
extends TaskQuery.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.TaskQuery

TaskQuery.AggregationQuery, TaskQuery.FilterLink, TaskQuery.FilterQuery, TaskQuery.GroupByQuery, TaskQuery.IAggregationQuery, TaskQuery.IBooleanColumnFilterQuery, TaskQuery.IClobColumnFilterQuery, TaskQuery.IColumnFilterQuery, TaskQuery.ICustomFieldAggregationQuery, TaskQuery.ICustomFieldFilterQuery, TaskQuery.ICustomFieldGroupBy, TaskQuery.ICustomFieldOrderBy, TaskQuery.IDateColumnFilterQuery, TaskQuery.IFilterableColumns, TaskQuery.IFilterLink, TaskQuery.IFilterQuery, TaskQuery.IGroupByQueryColumns, TaskQuery.IIntegerColumnFilterQuery, TaskQuery.INumberColumnFilterQuery, TaskQuery.IOrderByQueryColumns, TaskQuery.IPatternColumnFilterQuery, TaskQuery.IStringColumnFilterQuery, TaskQuery.ITaskStateFilterQuery, TaskQuery.IWorkflowPriorityFilterQuery, TaskQuery.OrderByColumnQuery, TaskQuery.OrderByQuery

Method Summary

Modifier and Type	Method	Description
TaskQuery.OrderByQuery	ascending()	Sorts the column in ascending direction.
TaskQuery.OrderByQuery	ascendingNullFirst()	Sorts the column in ascending direction, with NULL values at the beginning of the list.
TaskQuery.OrderByQuery	ascendingNullLast()	Sorts the column in ascending direction, with NULL values at the end of the list.
TaskQuery.OrderByQuery	descending()	Sorts the column in descending direction.
TaskQuery.OrderByQuery	descendingNullFirst()	Sorts the column in descending direction, with NULL values at the beginning of the list.
TaskQuery.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.TaskQuery.OrderByQuery

activatorDisplayName, activatorName, activatorRoleId, activatorUserId, applicationId, businessCalendar, businessCaseId, businessRuntime, caseId, category, customField, delayTimestamp, description, displayDescriptionTemplate, displayNameTemplate, endTaskSwitchEventId, endTimestamp, expiredCreatorTaskId, expiryActivatorDisplayName, expiryActivatorName, expiryActivatorRoleId, expiryActivatorUserId, expiryPriority, expiryTaskStartElementPid, expiryTimestamp, failedTimeoutTimestamp, isExpired, isOffline, isUpdatedOnStart, name, numberOfFailures, numberOfResumes, originalActivatorDisplayName, originalActivatorName, originalActivatorRoleId, originalActivatorUserId, originalPriority, priority, processModelId, requestPath, startTaskSwitchEventId, startTimestamp, state, taskEndId, taskId, taskStartId, timeoutedCreatorIntrmdtEventId, workerSessionId, workerUserDisplayName, workerUserId, workerUserName, workingTime

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

aggregate, create, executor, groupBy, orderBy, where

Method Detail

ascending

public TaskQuery.OrderByQuery ascending()

Sorts the column in ascending direction.

Example:

TaskQuery.create().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 TaskQuery.OrderByQuery ascendingNullFirst()

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

Example:

TaskQuery.create().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 TaskQuery.OrderByQuery ascendingNullLast()

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

Example:

TaskQuery.create().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 TaskQuery.OrderByQuery descending()

Sorts the column in descending direction.

Example:

TaskQuery.create().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 TaskQuery.OrderByQuery descendingNullFirst()

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

Example:

TaskQuery.create().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 TaskQuery.OrderByQuery descendingNullLast()

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

Example:

TaskQuery.create().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.