Class UserQuery.FilterQuery
- java.lang.Object
-
- ch.ivyteam.ivy.persistence.query.Query<IUser>
-
- ch.ivyteam.ivy.security.query.UserQuery
-
- ch.ivyteam.ivy.security.query.UserQuery.FilterLink
-
- ch.ivyteam.ivy.security.query.UserQuery.FilterQuery
-
- All Implemented Interfaces:
UserQuery.IFilterableColumns
,UserQuery.IFilterLink
,UserQuery.IFilterQuery
- Enclosing class:
- UserQuery
public static class UserQuery.FilterQuery extends UserQuery.FilterLink implements UserQuery.IFilterQuery
Provides filter functionality forIUser
Example:
Corresponds to SQL:UserQuery.create().where().name().isLike("john%");
SELECT * FROM IWA_IWA_User WHERE name LIKE 'john%'
- API:
- This is a public API.
-
-
Nested Class Summary
-
Nested classes/interfaces inherited from class ch.ivyteam.ivy.security.query.UserQuery
UserQuery.FilterLink, UserQuery.FilterQuery, UserQuery.GroupByQuery, UserQuery.IBoolFilterQuery, UserQuery.IColumnFilterQuery, UserQuery.IFilterableColumns, UserQuery.IFilterLink, UserQuery.IFilterQuery, UserQuery.IGroupByQueryColumns, UserQuery.IIntegerColumnFilterQuery, UserQuery.INumberColumnFilterQuery, UserQuery.IOrderByQueryColumns, UserQuery.IPatternColumnFilterQuery, UserQuery.IStringColumnFilterQuery, UserQuery.OrderByColumnQuery, UserQuery.OrderByQuery
-
-
Method Summary
All Methods Instance Methods Concrete Methods Modifier and Type Method Description UserQuery.IIntegerColumnFilterQuery
applicationId()
Prepares a where statement for the columnApplicationId
.
Must be followed by a call to a condition method.UserQuery.IStringColumnFilterQuery
eMailAddress()
Prepares a where statement for the columnEMailAddress
.
Must be followed by a call to a condition method.UserQuery.IStringColumnFilterQuery
externalId()
Prepares a where statement for the columnExternalId
.
Must be followed by a call to a condition method.UserQuery.IStringColumnFilterQuery
fullName()
Prepares a where statement for the columnFullName
.
Must be followed by a call to a condition method.UserQuery.IStringColumnFilterQuery
name()
Prepares a where statement for the columnName
.
Must be followed by a call to a condition method.UserQuery.FilterQuery
not(UserQuery otherQuery)
Adds a condition, which negates a set of where conditions given by theotherQuery
with a NOT expression.
Only the where clause of the givenotherQuery
is considered.UserQuery.IStringColumnFilterQuery
securityMemberId()
Prepares a where statement for the columnSecurityMemberId
.
Must be followed by a call to a condition method.-
Methods inherited from class ch.ivyteam.ivy.security.query.UserQuery.FilterLink
and, and, andOverall, andOverall, or, or
-
Methods inherited from class ch.ivyteam.ivy.security.query.UserQuery
create, executor, groupBy, orderBy, where
-
Methods inherited from interface ch.ivyteam.ivy.security.query.UserQuery.IFilterLink
and, and, andOverall, andOverall, or, or
-
-
-
-
Method Detail
-
not
public UserQuery.FilterQuery not(UserQuery otherQuery)
Adds a condition, which negates a set of where conditions given by the
otherQuery
with a NOT expression.
Only the where clause of the givenotherQuery
is considered. All other parts are ignored.SQL part:
NOT([otherSqlExpression])
Example:
Corresponds to SQL:UserQuery subQuery = UserQuery.create().where() .name().isEqual("john"); UserQuery query = UserQuery.create().where() .not(subQuery);
SELECT * FROM IWA_IWA_User WHERE NOT(name = 'john')
- Specified by:
not
in interfaceUserQuery.IFilterableColumns
- Parameters:
otherQuery
- Query from which the negated where part will be added to the current query.- Returns:
- query for further composition
- API:
- This public API is available in IvyScript and Java. It has the visibility EXPERT.
-
name
public UserQuery.IStringColumnFilterQuery name()
Description copied from interface:UserQuery.IFilterableColumns
Prepares a where statement for the column
Name
.
Must be followed by a call to a condition method.- Specified by:
name
in interfaceUserQuery.IFilterableColumns
- Returns:
- query for further composition
- See Also:
UserQuery.IFilterableColumns.name()
- API:
- This public API is available in IvyScript and Java. It has the visibility EXPERT.
-
fullName
public UserQuery.IStringColumnFilterQuery fullName()
Description copied from interface:UserQuery.IFilterableColumns
Prepares a where statement for the column
FullName
.
Must be followed by a call to a condition method.- Specified by:
fullName
in interfaceUserQuery.IFilterableColumns
- Returns:
- query for further composition
- See Also:
UserQuery.IFilterableColumns.fullName()
- API:
- This public API is available in IvyScript and Java. It has the visibility EXPERT.
-
applicationId
public UserQuery.IIntegerColumnFilterQuery applicationId()
Description copied from interface:UserQuery.IFilterableColumns
Prepares a where statement for the column
ApplicationId
.
Must be followed by a call to a condition method.- Specified by:
applicationId
in interfaceUserQuery.IFilterableColumns
- Returns:
- query for further composition
- See Also:
UserQuery.IFilterableColumns.applicationId()
- API:
- This public API is available in IvyScript and Java. It has the visibility EXPERT.
-
externalId
public UserQuery.IStringColumnFilterQuery externalId()
Description copied from interface:UserQuery.IFilterableColumns
Prepares a where statement for the column
ExternalId
.
Must be followed by a call to a condition method.- Specified by:
externalId
in interfaceUserQuery.IFilterableColumns
- Returns:
- query for further composition
- See Also:
UserQuery.IFilterableColumns.externalId()
- API:
- This public API is available in IvyScript and Java. It has the visibility EXPERT.
-
eMailAddress
public UserQuery.IStringColumnFilterQuery eMailAddress()
Description copied from interface:UserQuery.IFilterableColumns
Prepares a where statement for the column
EMailAddress
.
Must be followed by a call to a condition method.- Specified by:
eMailAddress
in interfaceUserQuery.IFilterableColumns
- Returns:
- query for further composition
- See Also:
UserQuery.IFilterableColumns.eMailAddress()
- API:
- This public API is available in IvyScript and Java. It has the visibility EXPERT.
-
securityMemberId
public UserQuery.IStringColumnFilterQuery securityMemberId()
Description copied from interface:UserQuery.IFilterableColumns
Prepares a where statement for the column
SecurityMemberId
.
Must be followed by a call to a condition method.- Specified by:
securityMemberId
in interfaceUserQuery.IFilterableColumns
- Returns:
- query for further composition
- See Also:
UserQuery.IFilterableColumns.securityMemberId()
- API:
- This public API is available in IvyScript and Java. It has the visibility EXPERT.
-
-