Package ch.ivyteam.ivy.security.query

Interface UserQuery.IOrderByQueryColumns

All Known Implementing Classes:

UserQuery.OrderByColumnQuery, UserQuery.OrderByQuery

Enclosing class:

UserQuery

public static interface 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.

Method Summary

Modifier and Type	Method	Description
UserQuery.OrderByColumnQuery	applicationId()	Adds an order by statement for the column ApplicationId in the default direction ascending. To change the order to descending use applicationId().descending()
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()

Method Detail

name

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()

Example:

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

SQL part: ORDER BY Name ASC

Returns:

query for further composition

See Also:

UserQuery.OrderByColumnQuery.descending(), UserQuery.OrderByColumnQuery.ascending()

API:

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

fullName

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()

Example:

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

SQL part: ORDER BY FullName ASC

Returns:

query for further composition

See Also:

UserQuery.OrderByColumnQuery.descending(), UserQuery.OrderByColumnQuery.ascending()

API:

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

applicationId

UserQuery.OrderByColumnQuery applicationId()

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

Example:

UserQuery.create().orderBy().applicationId()

SQL part: ORDER BY ApplicationId ASC

Returns:

query for further composition

See Also:

UserQuery.OrderByColumnQuery.descending(), UserQuery.OrderByColumnQuery.ascending()

API:

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

externalId

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()

Example:

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

SQL part: ORDER BY ExternalId ASC

Returns:

query for further composition

See Also:

UserQuery.OrderByColumnQuery.descending(), UserQuery.OrderByColumnQuery.ascending()

API:

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

eMailAddress

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()

Example:

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

SQL part: ORDER BY EMailAddress ASC

Returns:

query for further composition

See Also:

UserQuery.OrderByColumnQuery.descending(), UserQuery.OrderByColumnQuery.ascending()

API:

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

securityMemberId

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()

Example:

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

SQL part: ORDER BY SecurityMemberId ASC

Returns:

query for further composition

See Also:

UserQuery.OrderByColumnQuery.descending(), UserQuery.OrderByColumnQuery.ascending()

API:

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