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
All Methods Instance Methods Concrete Methods Modifier and Type Method Description TaskQuery.OrderByQuery
ascending()
Sorts the column in ascending direction.TaskQuery.OrderByQuery
ascendingNullFirst()
Sorts the column in ascending direction, withNULL
values at the beginning of the list.TaskQuery.OrderByQuery
ascendingNullLast()
Sorts the column in ascending direction, withNULL
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, withNULL
values at the beginning of the list.TaskQuery.OrderByQuery
descendingNullLast()
Sorts the column in descending direction, withNULL
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
-
-
-
-
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.
-
-