public class UserQueryImpl extends AbstractQuery<UserQuery,User> implements UserQuery, CacheAwareQuery<UserEntity>
ListQueryParameterObject.OrderBy, ListQueryParameterObject.ResultTypeQuery.NullHandlingOnOrder| Modifier and Type | Field and Description |
|---|---|
protected String |
displayName |
protected String |
displayNameLike |
protected String |
displayNameLikeIgnoreCase |
protected String |
email |
protected String |
emailLike |
protected String |
firstName |
protected String |
firstNameLike |
protected String |
firstNameLikeIgnoreCase |
protected String |
fullNameLike |
protected String |
fullNameLikeIgnoreCase |
protected String |
groupId |
protected List<String> |
groupIds |
protected String |
id |
protected String |
idIgnoreCase |
protected List<String> |
ids |
protected String |
lastName |
protected String |
lastNameLike |
protected String |
lastNameLikeIgnoreCase |
protected String |
tenantId |
commandContext, commandExecutordatabaseType, DEFAULT_ORDER_BY, defaultOrderBy, firstResult, maxResults, nullHandlingColumn, nullHandlingOnOrder, orderByCollection, orderProperty, parameter, resultType, SORTORDER_ASC, SORTORDER_DESC| 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)
Executes the actual query to retrieve the list of results.
|
String |
getDisplayName() |
String |
getDisplayNameLike() |
String |
getDisplayNameLikeIgnoreCase() |
String |
getEmail() |
String |
getEmailLike() |
String |
getFirstName() |
String |
getFirstNameLike() |
String |
getFirstNameLikeIgnoreCase() |
String |
getFullNameLike() |
String |
getFullNameLikeIgnoreCase() |
String |
getGroupId() |
List<String> |
getGroupIds() |
String |
getId() |
String |
getIdIgnoreCase() |
List<String> |
getIds() |
String |
getLastName() |
String |
getLastNameLike() |
String |
getLastNameLikeIgnoreCase() |
String |
getTenantId() |
UserQuery |
memberOfGroup(String groupId)
Only select
Users that belong to the given group. |
UserQuery |
memberOfGroups(List<String> groupIds)
Only select
Users that belong to the given groups. |
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 |
tenantId(String tenantId)
Only select
Users that belong to the given tenant. |
UserQuery |
userDisplayName(String displayName)
Only select
Users with the given displayName. |
UserQuery |
userDisplayNameLike(String displayNameLike)
Only select
Users where the display name matches the given parameter. |
UserQuery |
userDisplayNameLikeIgnoreCase(String displayNameLikeIgnoreCase)
Only select
Users where the display name matches the given parameter (ignoring case). |
UserQuery |
userEmail(String email)
Only those
Users with the given email address. |
UserQuery |
userEmailLike(String emailLike)
Only select
Users where the email matches the given parameter. |
UserQuery |
userFirstName(String firstName)
Only select
Users with the given firstName. |
UserQuery |
userFirstNameLike(String firstNameLike)
Only select
Users where the first name matches the given parameter. |
UserQuery |
userFirstNameLikeIgnoreCase(String firstNameLikeIgnoreCase)
Only select
Users where the first name matches the given parameter (ignoring case). |
UserQuery |
userFullNameLike(String fullNameLike)
Only select
Users where the full name matches the given parameters. |
UserQuery |
userFullNameLikeIgnoreCase(String fullNameLikeIgnoreCase)
Only select
Users where the full name matches the given parameters (ignoring case). |
UserQuery |
userId(String id)
Only select
Users with the given id/ |
UserQuery |
userIdIgnoreCase(String id)
Only select
Users with the given id (ignoring case) / |
UserQuery |
userIds(List<String> ids)
Only select
Users with the given ids/ |
UserQuery |
userLastName(String lastName)
Only select
Users with the given lastName. |
UserQuery |
userLastNameLike(String lastNameLike)
Only select
Users where the last name matches the given parameter. |
UserQuery |
userLastNameLikeIgnoreCase(String lastNameLikeIgnoreCase)
Only select
Users where the last name matches the given parameter (ignoring case). |
asc, checkQueryOk, count, desc, direction, execute, executeSingleResult, list, listPage, orderBy, orderBy, setCommandExecutor, singleResultaddOrder, buildOrderBy, getDatabaseType, getFirstResult, getFirstRow, getLastRow, getMaxResults, getNullHandlingColumn, getOrderBy, getOrderByCollectionSafe, getOrderByForWindow, getOuterJoinOrderBy, getParameter, hasOrderBy, hasOrderByForColumn, isNeedsPaging, mapOrderByToSql, setDatabaseType, setFirstResult, setMaxResults, setNullHandlingColumn, setParameterclone, equals, finalize, getClass, hashCode, notify, notifyAll, toString, wait, wait, waitasc, count, desc, list, listPage, orderBy, orderBy, singleResultenhanceCachedValueprotected String id
protected String idIgnoreCase
protected String firstName
protected String firstNameLike
protected String firstNameLikeIgnoreCase
protected String lastName
protected String lastNameLike
protected String lastNameLikeIgnoreCase
protected String fullNameLike
protected String fullNameLikeIgnoreCase
protected String displayName
protected String displayNameLike
protected String displayNameLikeIgnoreCase
protected String email
protected String emailLike
protected String groupId
protected String tenantId
public UserQueryImpl()
public UserQueryImpl(CommandContext commandContext)
public UserQueryImpl(CommandExecutor commandExecutor)
public UserQuery userId(String id)
UserBaseQueryUsers with the given id/userId in interface UserBaseQuery<UserQuery,User>public UserQuery userIds(List<String> ids)
UserBaseQueryUsers with the given ids/userIds in interface UserBaseQuery<UserQuery,User>public UserQuery userIdIgnoreCase(String id)
UserBaseQueryUsers with the given id (ignoring case) /userIdIgnoreCase in interface UserBaseQuery<UserQuery,User>public UserQuery userFirstName(String firstName)
UserBaseQueryUsers with the given firstName.userFirstName in interface UserBaseQuery<UserQuery,User>public UserQuery userFirstNameLike(String firstNameLike)
UserBaseQueryUsers where the first name matches the given parameter. The syntax is that of SQL, eg. %name%.userFirstNameLike in interface UserBaseQuery<UserQuery,User>public UserQuery userFirstNameLikeIgnoreCase(String firstNameLikeIgnoreCase)
UserBaseQueryUsers where the first name matches the given parameter (ignoring case). The syntax is that of SQL, eg. %name%.userFirstNameLikeIgnoreCase in interface UserBaseQuery<UserQuery,User>public UserQuery userLastName(String lastName)
UserBaseQueryUsers with the given lastName.userLastName in interface UserBaseQuery<UserQuery,User>public UserQuery userLastNameLike(String lastNameLike)
UserBaseQueryUsers where the last name matches the given parameter. The syntax is that of SQL, eg. %name%.userLastNameLike in interface UserBaseQuery<UserQuery,User>public UserQuery userLastNameLikeIgnoreCase(String lastNameLikeIgnoreCase)
UserBaseQueryUsers where the last name matches the given parameter (ignoring case). The syntax is that of SQL, eg. %name%.userLastNameLikeIgnoreCase in interface UserBaseQuery<UserQuery,User>public UserQuery userFullNameLike(String fullNameLike)
UserBaseQueryUsers 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 UserBaseQuery<UserQuery,User>public UserQuery userFullNameLikeIgnoreCase(String fullNameLikeIgnoreCase)
UserBaseQueryUsers where the full name matches the given parameters (ignoring case). Both the first name and last name will be tried, ie in semi-sql: where firstName like xxx or lastname
like xxxuserFullNameLikeIgnoreCase in interface UserBaseQuery<UserQuery,User>public UserQuery userDisplayName(String displayName)
UserBaseQueryUsers with the given displayName.userDisplayName in interface UserBaseQuery<UserQuery,User>public UserQuery userDisplayNameLike(String displayNameLike)
UserBaseQueryUsers where the display name matches the given parameter. The syntax is that of SQL, eg. %name%.userDisplayNameLike in interface UserBaseQuery<UserQuery,User>public UserQuery userDisplayNameLikeIgnoreCase(String displayNameLikeIgnoreCase)
UserBaseQueryUsers where the display name matches the given parameter (ignoring case). The syntax is that of SQL, eg. %name%.userDisplayNameLikeIgnoreCase in interface UserBaseQuery<UserQuery,User>public UserQuery userEmail(String email)
UserBaseQueryUsers with the given email address.userEmail in interface UserBaseQuery<UserQuery,User>public UserQuery userEmailLike(String emailLike)
UserBaseQueryUsers where the email matches the given parameter. The syntax is that of SQL, eg. %test%.userEmailLike in interface UserBaseQuery<UserQuery,User>public UserQuery memberOfGroup(String groupId)
UserBaseQueryUsers that belong to the given group.memberOfGroup in interface UserBaseQuery<UserQuery,User>public UserQuery memberOfGroups(List<String> groupIds)
UserBaseQueryUsers that belong to the given groups.memberOfGroups in interface UserBaseQuery<UserQuery,User>public UserQuery tenantId(String tenantId)
UserBaseQueryUsers that belong to the given tenant.tenantId in interface UserBaseQuery<UserQuery,User>public UserQuery orderByUserId()
UserBaseQueryQuery.asc() or Query.desc()).orderByUserId in interface UserBaseQuery<UserQuery,User>public UserQuery orderByUserEmail()
UserBaseQueryQuery.asc() or Query.desc()).orderByUserEmail in interface UserBaseQuery<UserQuery,User>public UserQuery orderByUserFirstName()
UserBaseQueryQuery.asc() or Query.desc()).orderByUserFirstName in interface UserBaseQuery<UserQuery,User>public UserQuery orderByUserLastName()
UserBaseQueryQuery.asc() or Query.desc()).orderByUserLastName in interface UserBaseQuery<UserQuery,User>public long executeCount(CommandContext commandContext)
executeCount in class AbstractQuery<UserQuery,User>public List<User> executeList(CommandContext commandContext)
AbstractQueryexecuteList in class AbstractQuery<UserQuery,User>public String getId()
getId in interface CacheAwareQuery<UserEntity>public String getIdIgnoreCase()
public String getFirstName()
public String getFirstNameLike()
public String getFirstNameLikeIgnoreCase()
public String getLastName()
public String getLastNameLike()
public String getLastNameLikeIgnoreCase()
public String getEmail()
public String getEmailLike()
public String getGroupId()
public String getFullNameLike()
public String getFullNameLikeIgnoreCase()
public String getDisplayName()
public String getDisplayNameLike()
public String getDisplayNameLikeIgnoreCase()
public String getTenantId()
Copyright © 2023 Flowable. All rights reserved.