Package ch.ivyteam.ivy.workflow.query

Class TaskQuery.OrderByQuery

java.lang.Object

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

ch.ivyteam.ivy.workflow.query.TaskQuery

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

All Implemented Interfaces:

TaskQuery.IOrderByQueryColumns

Direct Known Subclasses:

TaskQuery.OrderByColumnQuery

Enclosing class:

TaskQuery

public class TaskQuery.OrderByQuery
extends TaskQuery
implements TaskQuery.IOrderByQueryColumns

Provides methods to order the result by columns of ITask.

Example:

TaskQuery.create()
  .orderBy()
    .startTimestamp().descending();

Corresponds to SQL:

SELECT * FROM IWA_Task
  ORDER BY
    StartTimestamp DESC

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.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.OrderByColumnQuery, TaskQuery.OrderByQuery

Method Summary

Modifier and Type	Method	Description
TaskQuery.OrderByColumnQuery	businessCalendarId()	Deprecated.
TaskQuery.OrderByColumnQuery	displayDescriptionTemplate()	Deprecated, for removal: This API element is subject to removal in a future version.
TaskQuery.OrderByColumnQuery	displayNameTemplate()	Deprecated, for removal: This API element is subject to removal in a future version.

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

businessCalendarId

@Deprecated
public TaskQuery.OrderByColumnQuery businessCalendarId()

Deprecated.

Description copied from interface: TaskQuery.IOrderByQueryColumns

This method is deprecated. Instead of adding an order by statement for the column BusinessCalendarId it adds one for the column BusinessCalendar in the default direction ascending.
To change the order to descending use businessCalendarId().descending()

Example:

TaskQuery.create().orderBy().businessCalendarId()

SQL part: ORDER BY BusinessCalendar ASC

Specified by:

businessCalendarId in interface TaskQuery.IOrderByQueryColumns

Returns:

query for further composition

See Also:

• TaskQuery.OrderByColumnQuery.descending()
• TaskQuery.OrderByColumnQuery.ascending()

API:

This public API is available in Java.

displayNameTemplate

@Deprecated(since="9.4",
            forRemoval=true)
public TaskQuery.OrderByColumnQuery displayNameTemplate()

Deprecated, for removal: This API element is subject to removal in a future version.

Description copied from interface: TaskQuery.IOrderByQueryColumns

Orders by primary key because column DisplayNameTemplate was removed without any replacement.

Specified by:

displayNameTemplate in interface TaskQuery.IOrderByQueryColumns

Returns:

query for further composition

See Also:

• TaskQuery.OrderByColumnQuery.descending()
• TaskQuery.OrderByColumnQuery.ascending()

API:

This public API is available in Java.

displayDescriptionTemplate

@Deprecated(since="9.1",
            forRemoval=true)
public TaskQuery.OrderByColumnQuery displayDescriptionTemplate()

Deprecated, for removal: This API element is subject to removal in a future version.

Description copied from interface: TaskQuery.IOrderByQueryColumns

Orders by primary key because column DisplayDescriptionTemplate was removed without any replacement.

Specified by:

displayDescriptionTemplate in interface TaskQuery.IOrderByQueryColumns

Returns:

query for further composition

See Also:

• TaskQuery.OrderByColumnQuery.descending()
• TaskQuery.OrderByColumnQuery.ascending()

API:

This public API is available in Java.