Class CaseQuery.OrderByColumnQuery
- java.lang.Object
-
- ch.ivyteam.ivy.persistence.query.Query<ICase>
-
- ch.ivyteam.ivy.workflow.query.CaseQuery
-
- ch.ivyteam.ivy.workflow.query.CaseQuery.OrderByQuery
-
- ch.ivyteam.ivy.workflow.query.CaseQuery.OrderByColumnQuery
-
- All Implemented Interfaces:
CaseQuery.IOrderByQueryColumns
- Enclosing class:
- CaseQuery
public static class CaseQuery.OrderByColumnQuery extends CaseQuery.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.CaseQuery
CaseQuery.AggregationQuery, CaseQuery.FilterLink, CaseQuery.FilterQuery, CaseQuery.GroupByQuery, CaseQuery.IAggregationQuery, CaseQuery.ICaseStateFilterQuery, CaseQuery.IClobColumnFilterQuery, CaseQuery.IColumnFilterQuery, CaseQuery.ICustomFieldAggregationQuery, CaseQuery.ICustomFieldFilterQuery, CaseQuery.ICustomFieldGroupBy, CaseQuery.ICustomFieldOrderBy, CaseQuery.IDateColumnFilterQuery, CaseQuery.IFilterableColumns, CaseQuery.IFilterLink, CaseQuery.IFilterQuery, CaseQuery.IGroupByQueryColumns, CaseQuery.IIntegerColumnFilterQuery, CaseQuery.INumberColumnFilterQuery, CaseQuery.IOrderByQueryColumns, CaseQuery.IPatternColumnFilterQuery, CaseQuery.IStringColumnFilterQuery, CaseQuery.IWorkflowPriorityFilterQuery, CaseQuery.OrderByColumnQuery, CaseQuery.OrderByQuery
-
-
Method Summary
All Methods Instance Methods Concrete Methods Modifier and Type Method Description CaseQuery.OrderByQuery
ascending()
Sorts the column in ascending direction.CaseQuery.OrderByQuery
ascendingNullFirst()
Sorts the column in ascending direction, withNULL
values at the beginning of the list.CaseQuery.OrderByQuery
ascendingNullLast()
Sorts the column in ascending direction, withNULL
values at the end of the list.CaseQuery.OrderByQuery
descending()
Sorts the column in descending direction.CaseQuery.OrderByQuery
descendingNullFirst()
Sorts the column in descending direction, withNULL
values at the beginning of the list.CaseQuery.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.CaseQuery.OrderByQuery
applicationId, businessCalendar, businessCaseId, businessRuntime, caseId, category, creatorTaskId, creatorUserDisplayName, creatorUserId, creatorUserName, customField, description, displayDescriptionTemplate, displayNameTemplate, endTimestamp, environmentId, name, ownerName, ownerRoleId, ownerUserId, priority, processModelId, stage, startTimestamp, state, taskStartId, workingTime
-
-
-
-
Method Detail
-
ascending
public CaseQuery.OrderByQuery ascending()
Sorts the column in ascending direction.
Example:
CaseQuery.businessCases().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 CaseQuery.OrderByQuery ascendingNullFirst()
Sorts the column in ascending direction, with
NULL
values at the beginning of the list.Example:
CaseQuery.businessCases().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 CaseQuery.OrderByQuery ascendingNullLast()
Sorts the column in ascending direction, with
NULL
values at the end of the list.Example:
CaseQuery.businessCases().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 CaseQuery.OrderByQuery descending()
Sorts the column in descending direction.
Example:
CaseQuery.businessCases().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 CaseQuery.OrderByQuery descendingNullFirst()
Sorts the column in descending direction, with
NULL
values at the beginning of the list.Example:
CaseQuery.businessCases().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 CaseQuery.OrderByQuery descendingNullLast()
Sorts the column in descending direction, with
NULL
values at the end of the list.Example:
CaseQuery.businessCases().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.
-
-