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 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
UserQuery.OrderByColumnQuery name()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
- 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
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
- 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
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
- 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
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
- 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
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
- 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
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
- Returns:
- query for further composition
- See Also:
- API:
- This public API is available in Java.
-