Class SignalEventQuery.OrderByColumnQuery
- All Implemented Interfaces:
SignalEventQuery.IOrderByQueryColumns
- Enclosing class:
- SignalEventQuery
- 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 TypeMethodDescriptionSorts the column in ascending direction.Sorts the column in ascending direction, withNULL
values at the beginning of the list.Sorts the column in ascending direction, withNULL
values at the end of the list.Sorts the column in descending direction.Sorts the column in descending direction, withNULL
values at the beginning of the list.Sorts the column in descending direction, withNULL
values at the end of the list.Methods inherited from class ch.ivyteam.ivy.workflow.query.SignalEventQuery.OrderByQuery
applicationId, securitySystemId, sentById, sentByProcessElementPid, sentByTaskId, sentByUserId, sentByUserName, sentTimestamp, signalCode, signalEventId
-
Method Details
-
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 Java.
-
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 Java.
-
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 Java.
-
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 Java.
-
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 Java.
-
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 Java.
-