Package ch.ivyteam.ivy.security.query

Class UserQuery.OrderByQuery

java.lang.Object

ch.ivyteam.ivy.persistence.query.Query<IUser>

ch.ivyteam.ivy.security.query.UserQuery

ch.ivyteam.ivy.security.query.UserQuery.OrderByQuery

All Implemented Interfaces:

UserQuery.IOrderByQueryColumns

Direct Known Subclasses:

UserQuery.OrderByColumnQuery

Enclosing class:

UserQuery

public static class UserQuery.OrderByQuery
extends UserQuery
implements UserQuery.IOrderByQueryColumns

Provides methods to order the result by columns of IUser.

Example:

UserQuery.create()
  .orderBy()
    .fullName().descending()
    .name();

Corresponds to SQL:

SELECT * FROM IWA_User
  ORDER BY
    FullName DESC,
    Name ASC
    

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.OrderByColumnQuery	eMailAddress()	Adds an order by statement for the column EMailAddress in the default direction ascending. To change the order to descending use eMailAddress().descending()
UserQuery.OrderByColumnQuery	externalId()	Adds an order by statement for the column ExternalId in the default direction ascending. To change the order to descending use externalId().descending()
UserQuery.OrderByColumnQuery	fullName()	Adds an order by statement for the column FullName in the default direction ascending. To change the order to descending use fullName().descending()
UserQuery.OrderByColumnQuery	name()	Adds an order by statement for the column Name in the default direction ascending. To change the order to descending use name().descending()
UserQuery.OrderByColumnQuery	securityMemberId()	Adds an order by statement for the column SecurityMemberId in the default direction ascending. To change the order to descending use securityMemberId().descending()
UserQuery.OrderByColumnQuery	securitySystemId()	Adds an order by statement for the column SecuritySystemId in the default direction ascending. To change the order to descending use securitySystemId().descending()

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

create, executor, groupBy, orderBy, where

Method Details

name

public UserQuery.OrderByColumnQuery name()

Description copied from interface: UserQuery.IOrderByQueryColumns

Adds an order by statement for the column Name in the default direction ascending.
To change the order to descending use name().descending()

Example:

UserQuery.create().orderBy().name()

SQL part: ORDER BY Name ASC

Specified by:

name in interface UserQuery.IOrderByQueryColumns

Returns:

query for further composition

See Also:

• UserQuery.IOrderByQueryColumns.name()

API:

This public API is available in IvyScript and Java. It has the visibility EXPERT.

fullName

public UserQuery.OrderByColumnQuery fullName()

Description copied from interface: UserQuery.IOrderByQueryColumns

Adds an order by statement for the column FullName in the default direction ascending.
To change the order to descending use fullName().descending()

Example:

UserQuery.create().orderBy().fullName()

SQL part: ORDER BY FullName ASC

Specified by:

fullName in interface UserQuery.IOrderByQueryColumns

Returns:

query for further composition

See Also:

• UserQuery.IOrderByQueryColumns.fullName()

API:

This public API is available in IvyScript and Java. It has the visibility EXPERT.

securitySystemId

public UserQuery.OrderByColumnQuery securitySystemId()

Description copied from interface: UserQuery.IOrderByQueryColumns

Adds an order by statement for the column SecuritySystemId in the default direction ascending.
To change the order to descending use securitySystemId().descending()

Example:

UserQuery.create().orderBy().securitySystemId()

SQL part: ORDER BY SecuritySystemId ASC

Specified by:

securitySystemId in interface UserQuery.IOrderByQueryColumns

Returns:

query for further composition

See Also:

• UserQuery.IOrderByQueryColumns.securitySystemId()

API:

This public API is available in IvyScript and Java. It has the visibility EXPERT.

externalId

public UserQuery.OrderByColumnQuery externalId()

Description copied from interface: UserQuery.IOrderByQueryColumns

Adds an order by statement for the column ExternalId in the default direction ascending.
To change the order to descending use externalId().descending()

Example:

UserQuery.create().orderBy().externalId()

SQL part: ORDER BY ExternalId ASC

Specified by:

externalId in interface UserQuery.IOrderByQueryColumns

Returns:

query for further composition

See Also:

• UserQuery.IOrderByQueryColumns.externalId()

API:

This public API is available in IvyScript and Java. It has the visibility EXPERT.

eMailAddress

public UserQuery.OrderByColumnQuery eMailAddress()

Description copied from interface: UserQuery.IOrderByQueryColumns

Adds an order by statement for the column EMailAddress in the default direction ascending.
To change the order to descending use eMailAddress().descending()

Example:

UserQuery.create().orderBy().eMailAddress()

SQL part: ORDER BY EMailAddress ASC

Specified by:

eMailAddress in interface UserQuery.IOrderByQueryColumns

Returns:

query for further composition

See Also:

• UserQuery.IOrderByQueryColumns.eMailAddress()

API:

This public API is available in IvyScript and Java. It has the visibility EXPERT.

securityMemberId

public UserQuery.OrderByColumnQuery securityMemberId()

Description copied from interface: UserQuery.IOrderByQueryColumns

Adds an order by statement for the column SecurityMemberId in the default direction ascending.
To change the order to descending use securityMemberId().descending()

Example:

UserQuery.create().orderBy().securityMemberId()

SQL part: ORDER BY SecurityMemberId ASC

Specified by:

securityMemberId in interface UserQuery.IOrderByQueryColumns

Returns:

query for further composition

See Also:

• UserQuery.IOrderByQueryColumns.securityMemberId()

API:

This public API is available in IvyScript and Java. It has the visibility EXPERT.