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