Interface UserQuery.IOrderByQueryColumns
- All Known Implementing Classes:
UserQuery.OrderByColumnQuery,UserQuery.OrderByQuery
- 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.
-
Method Summary
Modifier and TypeMethodDescriptionAdds an order by statement for the columnEMailAddressin the default direction ascending.
To change the order to descending useeMailAddress().descending()Adds an order by statement for the columnExternalIdin the default direction ascending.
To change the order to descending useexternalId().descending()fullName()Adds an order by statement for the columnFullNamein the default direction ascending.
To change the order to descending usefullName().descending()name()Adds an order by statement for the columnNamein the default direction ascending.
To change the order to descending usename().descending()Adds an order by statement for the columnSecurityMemberIdin the default direction ascending.
To change the order to descending usesecurityMemberId().descending()Adds an order by statement for the columnSecuritySystemIdin the default direction ascending.
To change the order to descending usesecuritySystemId().descending()
-
Method Details
-
name
UserQuery.OrderByColumnQuery name()Adds an order by statement for the column
Namein the default direction ascending.
To change the order to descending usename().descending()Example:
UserQuery.create().orderBy().name()
SQL part:
ORDER BY Name ASC- Returns:
- query for further composition
- See Also:
- API:
- This public API is available in Java.
-
fullName
UserQuery.OrderByColumnQuery fullName()Adds an order by statement for the column
FullNamein the default direction ascending.
To change the order to descending usefullName().descending()Example:
UserQuery.create().orderBy().fullName()
SQL part:
ORDER BY FullName ASC- Returns:
- query for further composition
- See Also:
- API:
- This public API is available in Java.
-
securitySystemId
UserQuery.OrderByColumnQuery securitySystemId()Adds an order by statement for the column
SecuritySystemIdin the default direction ascending.
To change the order to descending usesecuritySystemId().descending()Example:
UserQuery.create().orderBy().securitySystemId()
SQL part:
ORDER BY SecuritySystemId ASC- Returns:
- query for further composition
- See Also:
- API:
- This public API is available in Java.
-
externalId
UserQuery.OrderByColumnQuery externalId()Adds an order by statement for the column
ExternalIdin the default direction ascending.
To change the order to descending useexternalId().descending()Example:
UserQuery.create().orderBy().externalId()
SQL part:
ORDER BY ExternalId ASC- Returns:
- query for further composition
- See Also:
- API:
- This public API is available in Java.
-
eMailAddress
UserQuery.OrderByColumnQuery eMailAddress()Adds an order by statement for the column
EMailAddressin the default direction ascending.
To change the order to descending useeMailAddress().descending()Example:
UserQuery.create().orderBy().eMailAddress()
SQL part:
ORDER BY EMailAddress ASC- Returns:
- query for further composition
- See Also:
- API:
- This public API is available in Java.
-
securityMemberId
UserQuery.OrderByColumnQuery securityMemberId()Adds an order by statement for the column
SecurityMemberIdin the default direction ascending.
To change the order to descending usesecurityMemberId().descending()Example:
UserQuery.create().orderBy().securityMemberId()
SQL part:
ORDER BY SecurityMemberId ASC- Returns:
- query for further composition
- See Also:
- API:
- This public API is available in Java.
-