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 ofIUser
.Example:
Corresponds to SQL:UserQuery.create() .orderBy() .fullName().descending() .name();
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
All Methods Instance Methods Concrete Methods Modifier and Type Method Description UserQuery.OrderByColumnQuery
applicationId()
Adds an order by statement for the columnApplicationId
in the default direction ascending.
To change the order to descending useapplicationId().descending()
UserQuery.OrderByColumnQuery
eMailAddress()
Adds an order by statement for the columnEMailAddress
in the default direction ascending.
To change the order to descending useeMailAddress().descending()
UserQuery.OrderByColumnQuery
externalId()
Adds an order by statement for the columnExternalId
in the default direction ascending.
To change the order to descending useexternalId().descending()
UserQuery.OrderByColumnQuery
fullName()
Adds an order by statement for the columnFullName
in the default direction ascending.
To change the order to descending usefullName().descending()
UserQuery.OrderByColumnQuery
name()
Adds an order by statement for the columnName
in the default direction ascending.
To change the order to descending usename().descending()
UserQuery.OrderByColumnQuery
securityMemberId()
Adds an order by statement for the columnSecurityMemberId
in the default direction ascending.
To change the order to descending usesecurityMemberId().descending()
-
-
-
Method Detail
-
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 usename().descending()
Example:
UserQuery.create().orderBy().name()
SQL part:
ORDER BY Name ASC
- Specified by:
name
in interfaceUserQuery.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 usefullName().descending()
Example:
UserQuery.create().orderBy().fullName()
SQL part:
ORDER BY FullName ASC
- Specified by:
fullName
in interfaceUserQuery.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.
-
applicationId
public UserQuery.OrderByColumnQuery applicationId()
Description copied from interface:UserQuery.IOrderByQueryColumns
Adds an order by statement for the column
ApplicationId
in the default direction ascending.
To change the order to descending useapplicationId().descending()
Example:
UserQuery.create().orderBy().applicationId()
SQL part:
ORDER BY ApplicationId ASC
- Specified by:
applicationId
in interfaceUserQuery.IOrderByQueryColumns
- Returns:
- query for further composition
- See Also:
UserQuery.IOrderByQueryColumns.applicationId()
- 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 useexternalId().descending()
Example:
UserQuery.create().orderBy().externalId()
SQL part:
ORDER BY ExternalId ASC
- Specified by:
externalId
in interfaceUserQuery.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 useeMailAddress().descending()
Example:
UserQuery.create().orderBy().eMailAddress()
SQL part:
ORDER BY EMailAddress ASC
- Specified by:
eMailAddress
in interfaceUserQuery.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 usesecurityMemberId().descending()
Example:
UserQuery.create().orderBy().securityMemberId()
SQL part:
ORDER BY SecurityMemberId ASC
- Specified by:
securityMemberId
in interfaceUserQuery.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.
-
-