Class UserQuery.OrderByQuery
- All Implemented Interfaces:
UserQuery.IOrderByQueryColumns
- Direct Known Subclasses:
UserQuery.OrderByColumnQuery
- Enclosing class:
- UserQuery
IUser
.
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
Modifier and TypeMethodDescriptionAdds an order by statement for the columnEMailAddress
in the default direction ascending.
To change the order to descending useeMailAddress().descending()
Adds an order by statement for the columnExternalId
in the default direction ascending.
To change the order to descending useexternalId().descending()
fullName()
Adds an order by statement for the columnFullName
in the default direction ascending.
To change the order to descending usefullName().descending()
name()
Adds an order by statement for the columnName
in the default direction ascending.
To change the order to descending usename().descending()
Adds an order by statement for the columnSecurityMemberId
in the default direction ascending.
To change the order to descending usesecurityMemberId().descending()
Adds an order by statement for the columnSecuritySystemId
in the default direction ascending.
To change the order to descending usesecuritySystemId().descending()
-
Method Details
-
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:
- API:
- This public API is available in Java.
-
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:
- API:
- This public API is available in Java.
-
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 usesecuritySystemId().descending()
Example:
UserQuery.create().orderBy().securitySystemId()
SQL part:
ORDER BY SecuritySystemId ASC
- Specified by:
securitySystemId
in interfaceUserQuery.IOrderByQueryColumns
- Returns:
- query for further composition
- See Also:
- API:
- This public API is available in Java.
-
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:
- API:
- This public API is available in Java.
-
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:
- API:
- This public API is available in Java.
-
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:
- API:
- This public API is available in Java.
-