public class UserQueryImpl extends AbstractQuery<UserQuery,User> implements UserQuery
AbstractQuery.NullHandlingOnOrder
Modifier and Type | Field and Description |
---|---|
protected String |
email |
protected String |
emailLike |
protected String |
firstName |
protected String |
firstNameLike |
protected String |
fullNameLike |
protected String |
groupId |
protected String |
id |
protected String |
lastName |
protected String |
lastNameLike |
protected String |
procDefId |
commandContext, commandExecutor, databaseType, nullHandlingOnOrder, orderBy, orderProperty, resultType, SORTORDER_ASC, SORTORDER_DESC
firstResult, maxResults, parameter
Constructor and Description |
---|
UserQueryImpl() |
UserQueryImpl(CommandContext commandContext) |
UserQueryImpl(CommandExecutor commandExecutor) |
Modifier and Type | Method and Description |
---|---|
long |
executeCount(CommandContext commandContext) |
List<User> |
executeList(CommandContext commandContext,
Page page)
Executes the actual query to retrieve the list of results.
|
String |
getEmail() |
String |
getEmailLike() |
String |
getFirstName() |
String |
getFirstNameLike() |
String |
getFullNameLike() |
String |
getGroupId() |
String |
getId() |
String |
getLastName() |
String |
getLastNameLike() |
UserQuery |
memberOfGroup(String groupId)
Only select
User s that belong to the given group. |
UserQuery |
orderByUserEmail()
Order by user email (needs to be followed by
Query.asc() or Query.desc() ). |
UserQuery |
orderByUserFirstName()
Order by user first name (needs to be followed by
Query.asc() or Query.desc() ). |
UserQuery |
orderByUserId()
Order by user id (needs to be followed by
Query.asc() or Query.desc() ). |
UserQuery |
orderByUserLastName()
Order by user last name (needs to be followed by
Query.asc() or Query.desc() ). |
UserQuery |
potentialStarter(String procDefId)
Only select
User S that are potential starter for the given process definition. |
UserQuery |
userEmail(String email)
Only those
User s with the given email addres. |
UserQuery |
userEmailLike(String emailLike)
Only select
User s where the email matches the given parameter. |
UserQuery |
userFirstName(String firstName)
Only select
User s with the given firstName. |
UserQuery |
userFirstNameLike(String firstNameLike)
Only select
User s where the first name matches the given parameter. |
UserQuery |
userFullNameLike(String fullNameLike)
Only select
User s where the full name matches the given parameters. |
UserQuery |
userId(String id)
Only select
User s with the given id/ |
UserQuery |
userLastName(String lastName)
Only select
User s with the given lastName. |
UserQuery |
userLastNameLike(String lastNameLike)
Only select
User s where the last name matches the given parameter. |
addOrder, asc, checkQueryOk, count, desc, direction, execute, executeSingleResult, getDatabaseType, getOrderBy, getOrderByColumns, list, listPage, orderBy, orderBy, setCommandExecutor, setDatabaseType, singleResult
getFirstResult, getFirstRow, getLastRow, getMaxResults, getParameter, setFirstResult, setMaxResults, setParameter
protected String id
protected String firstName
protected String firstNameLike
protected String lastName
protected String lastNameLike
protected String fullNameLike
protected String email
protected String emailLike
protected String groupId
protected String procDefId
public UserQueryImpl()
public UserQueryImpl(CommandContext commandContext)
public UserQueryImpl(CommandExecutor commandExecutor)
public UserQuery userId(String id)
UserQuery
User
s with the given id/public UserQuery userFirstName(String firstName)
UserQuery
User
s with the given firstName.userFirstName
in interface UserQuery
public UserQuery userFirstNameLike(String firstNameLike)
UserQuery
User
s where the first name matches the given parameter.
The syntax is that of SQL, eg. %activivi%.userFirstNameLike
in interface UserQuery
public UserQuery userLastName(String lastName)
UserQuery
User
s with the given lastName.userLastName
in interface UserQuery
public UserQuery userLastNameLike(String lastNameLike)
UserQuery
User
s where the last name matches the given parameter.
The syntax is that of SQL, eg. %activivi%.userLastNameLike
in interface UserQuery
public UserQuery userFullNameLike(String fullNameLike)
UserQuery
User
s where the full name matches the given parameters.
Both the first name and last name will be tried, ie in semi-sql:
where firstName like xxx or lastname like xxxuserFullNameLike
in interface UserQuery
public UserQuery userEmail(String email)
UserQuery
User
s with the given email addres.public UserQuery userEmailLike(String emailLike)
UserQuery
User
s where the email matches the given parameter.
The syntax is that of SQL, eg. %activivi%.userEmailLike
in interface UserQuery
public UserQuery memberOfGroup(String groupId)
UserQuery
User
s that belong to the given group.memberOfGroup
in interface UserQuery
public UserQuery potentialStarter(String procDefId)
UserQuery
User
S that are potential starter for the given process definition.potentialStarter
in interface UserQuery
public UserQuery orderByUserId()
UserQuery
Query.asc()
or Query.desc()
).orderByUserId
in interface UserQuery
public UserQuery orderByUserEmail()
UserQuery
Query.asc()
or Query.desc()
).orderByUserEmail
in interface UserQuery
public UserQuery orderByUserFirstName()
UserQuery
Query.asc()
or Query.desc()
).orderByUserFirstName
in interface UserQuery
public UserQuery orderByUserLastName()
UserQuery
Query.asc()
or Query.desc()
).orderByUserLastName
in interface UserQuery
public long executeCount(CommandContext commandContext)
executeCount
in class AbstractQuery<UserQuery,User>
public List<User> executeList(CommandContext commandContext, Page page)
AbstractQuery
executeList
in class AbstractQuery<UserQuery,User>
page
- used if the results must be paged. If null, no paging will be applied.public String getId()
public String getFirstName()
public String getFirstNameLike()
public String getLastName()
public String getLastNameLike()
public String getEmail()
public String getEmailLike()
public String getGroupId()
public String getFullNameLike()
Copyright © 2016 Alfresco. All rights reserved.