Package ch.ivyteam.ivy.workflow.query

Class SignalEventQuery.OrderByColumnQuery

java.lang.Object

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

ch.ivyteam.ivy.workflow.query.SignalEventQuery

ch.ivyteam.ivy.workflow.query.SignalEventQuery.OrderByQuery

ch.ivyteam.ivy.workflow.query.SignalEventQuery.OrderByColumnQuery

All Implemented Interfaces:

SignalEventQuery.IOrderByQueryColumns

Enclosing class:

SignalEventQuery

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

SignalEventQuery.AggregationQuery, SignalEventQuery.FilterLink, SignalEventQuery.FilterQuery, SignalEventQuery.GroupByQuery, SignalEventQuery.IAggregationQuery, SignalEventQuery.IBoolFilterQuery, SignalEventQuery.IColumnFilterQuery, SignalEventQuery.IDateColumnFilterQuery, SignalEventQuery.IFilterableColumns, SignalEventQuery.IFilterLink, SignalEventQuery.IFilterQuery, SignalEventQuery.IGroupByQueryColumns, SignalEventQuery.IIntegerColumnFilterQuery, SignalEventQuery.INumberColumnFilterQuery, SignalEventQuery.IOrderByQueryColumns, SignalEventQuery.IPatternColumnFilterQuery, SignalEventQuery.IStringColumnFilterQuery, SignalEventQuery.OrderByColumnQuery, SignalEventQuery.OrderByQuery

Method Summary

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

applicationId, sentByProcessElementPid, sentByTaskId, sentByUserId, sentByUserName, sentTimestamp, signalCode, signalEventId

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

aggregate, create, executor, groupBy, orderBy, where

Method Detail

ascending

public SignalEventQuery.OrderByQuery ascending()

Sorts the column in ascending direction.

Example:

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

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

Example:

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

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

Example:

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

Sorts the column in descending direction.

Example:

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

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

Example:

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

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

Example:

SignalEventQuery.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.