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 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.
-
-
Method Summary
All Methods Instance Methods Abstract 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
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:
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 usefullName().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 useapplicationId().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 useexternalId().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 useeMailAddress().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 usesecurityMemberId().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.
-
-