Class StartSignalEventElementQuery.OrderByColumnQuery
- java.lang.Object
-
- ch.ivyteam.ivy.persistence.query.Query<IStartSignalEventElement>
-
- ch.ivyteam.ivy.workflow.query.StartSignalEventElementQuery
-
- ch.ivyteam.ivy.workflow.query.StartSignalEventElementQuery.OrderByQuery
-
- ch.ivyteam.ivy.workflow.query.StartSignalEventElementQuery.OrderByColumnQuery
-
- All Implemented Interfaces:
StartSignalEventElementQuery.IOrderByQueryColumns
- Enclosing class:
- StartSignalEventElementQuery
public static class StartSignalEventElementQuery.OrderByColumnQuery extends StartSignalEventElementQuery.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.StartSignalEventElementQuery
StartSignalEventElementQuery.AggregationQuery, StartSignalEventElementQuery.FilterLink, StartSignalEventElementQuery.FilterQuery, StartSignalEventElementQuery.GroupByQuery, StartSignalEventElementQuery.IAggregationQuery, StartSignalEventElementQuery.IBooleanColumnFilterQuery, StartSignalEventElementQuery.IColumnFilterQuery, StartSignalEventElementQuery.IFilterableColumns, StartSignalEventElementQuery.IFilterLink, StartSignalEventElementQuery.IFilterQuery, StartSignalEventElementQuery.IGroupByQueryColumns, StartSignalEventElementQuery.IIntegerColumnFilterQuery, StartSignalEventElementQuery.INumberColumnFilterQuery, StartSignalEventElementQuery.IOrderByQueryColumns, StartSignalEventElementQuery.IPatternColumnFilterQuery, StartSignalEventElementQuery.IStringColumnFilterQuery, StartSignalEventElementQuery.OrderByColumnQuery, StartSignalEventElementQuery.OrderByQuery
-
-
Method Summary
All Methods Instance Methods Concrete Methods Modifier and Type Method Description StartSignalEventElementQuery.OrderByQuery
ascending()
Sorts the column in ascending direction.StartSignalEventElementQuery.OrderByQuery
ascendingNullFirst()
Sorts the column in ascending direction, withNULL
values at the beginning of the list.StartSignalEventElementQuery.OrderByQuery
ascendingNullLast()
Sorts the column in ascending direction, withNULL
values at the end of the list.StartSignalEventElementQuery.OrderByQuery
descending()
Sorts the column in descending direction.StartSignalEventElementQuery.OrderByQuery
descendingNullFirst()
Sorts the column in descending direction, withNULL
values at the beginning of the list.StartSignalEventElementQuery.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.StartSignalEventElementQuery.OrderByQuery
attachToBusinessCase, signalCodePattern, taskStartId
-
-
-
-
Method Detail
-
ascending
public StartSignalEventElementQuery.OrderByQuery ascending()
Sorts the column in ascending direction.
Example:
StartSignalEventElementQuery.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 StartSignalEventElementQuery.OrderByQuery ascendingNullFirst()
Sorts the column in ascending direction, with
NULL
values at the beginning of the list.Example:
StartSignalEventElementQuery.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 StartSignalEventElementQuery.OrderByQuery ascendingNullLast()
Sorts the column in ascending direction, with
NULL
values at the end of the list.Example:
StartSignalEventElementQuery.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 StartSignalEventElementQuery.OrderByQuery descending()
Sorts the column in descending direction.
Example:
StartSignalEventElementQuery.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 StartSignalEventElementQuery.OrderByQuery descendingNullFirst()
Sorts the column in descending direction, with
NULL
values at the beginning of the list.Example:
StartSignalEventElementQuery.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 StartSignalEventElementQuery.OrderByQuery descendingNullLast()
Sorts the column in descending direction, with
NULL
values at the end of the list.Example:
StartSignalEventElementQuery.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.
-
-