Package ch.ivyteam.ivy.security.query

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.IBoolFilterQuery, 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

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

Methods inherited from class ch.ivyteam.ivy.security.query.UserQuery.OrderByQuery

applicationId, eMailAddress, externalId, fullName, name, securityMemberId

Methods inherited from class ch.ivyteam.ivy.security.query.UserQuery

create, executor, groupBy, orderBy, where

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.