Package ch.ivyteam.ivy.workflow.query

Class TaskQuery.EnumValueOrderByColumnQuery<T extends ch.ivyteam.ivy.persistence.IPersistentEnumeration>

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

ch.ivyteam.ivy.workflow.query.TaskQuery.EnumValueOrderByColumnQuery<T>

All Implemented Interfaces:

TaskQuery.IOrderByQueryColumns

Enclosing class:

TaskQuery

public class TaskQuery.EnumValueOrderByColumnQuery<T extends ch.ivyteam.ivy.persistence.IPersistentEnumeration>
extends TaskQuery.OrderByColumnQuery

API:

This is a public API.

Nested Class Summary

Nested classes/interfaces inherited from class ch.ivyteam.ivy.workflow.query.TaskQuery

TaskQuery.AggregationQuery, TaskQuery.EnumValueOrderByColumnQuery<T extends ch.ivyteam.ivy.persistence.IPersistentEnumeration>, TaskQuery.FilterLink, TaskQuery.FilterQuery, TaskQuery.GroupByQuery, TaskQuery.IAggregationQuery, TaskQuery.IBooleanColumnFilterQuery, TaskQuery.IBoolFilterQuery, 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.ITaskBusinessStateFilterQuery, TaskQuery.ITaskStateFilterQuery, TaskQuery.IUUIDColumnFilterQuery, TaskQuery.IWorkflowPriorityFilterQuery, TaskQuery.LongValueOrderByColumnQuery, TaskQuery.OrderByColumnQuery, TaskQuery.OrderByQuery, TaskQuery.StringValueOrderByColumnQuery

Method Summary

Modifier and Type	Method	Description
TaskQuery.OrderByColumnQuery	values(List<T> valueOrder)	Adds an order by statement for the specified column in the order of the given values.
TaskQuery.OrderByColumnQuery	values(T... valueOrder)	Adds an order by statement for the specified column in the order of the given values.

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

ascending, ascendingNullFirst, ascendingNullLast, descending, descendingNullFirst, descendingNullLast

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

businessCalendarId, displayDescriptionTemplate, displayNameTemplate

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

aggregate, asJson, create, executor, fromJson, groupBy, orderBy, toType, where

Methods inherited from class ch.ivyteam.ivy.persistence.query.Query

equals, hashCode

Method Details

values

public TaskQuery.OrderByColumnQuery values(List<T> valueOrder)

Adds an order by statement for the specified column in the order of the given values.

Example:

TaskQuery.create().orderBy().priority().values(List.of(WorkflowPriority.NORMAL, WorkflowPriority.EXCEPTION, WorkflowPriority.LOW, WorkflowPriority.HIGH))

SQL part: ORDER BY CASE WHEN Priority=2 THEN 0 WHEN Priority=0 THEN 1 WHEN Priority=3 THEN 2 WHEN Priority=1 THEN 3 ELSE 4 END ASC

Parameters:

valueOrder - List of values that define the order of the result

Returns:

query for further composition

API:

This public API is available in Java.

values

public TaskQuery.OrderByColumnQuery values(T... valueOrder)

Adds an order by statement for the specified column in the order of the given values.

Example:

TaskQuery.create().orderBy().priority().values(WorkflowPriority.NORMAL, WorkflowPriority.EXCEPTION, WorkflowPriority.LOW, WorkflowPriority.HIGH)

SQL part: ORDER BY CASE WHEN Priority=2 THEN 0 WHEN Priority=0 THEN 1 WHEN Priority=3 THEN 2 WHEN Priority=1 THEN 3 ELSE 4 END ASC

Parameters:

valueOrder - List of values that define the order of the result

Returns:

query for further composition

API:

This public API is available in Java.