Class UserQuery.FilterQuery
- All Implemented Interfaces:
UserQuery.IFilterableColumns
,UserQuery.IFilterLink
,UserQuery.IFilterQuery
- Enclosing class:
- UserQuery
IUser
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
Modifier and TypeMethodDescriptionPrepares a where statement for the columnEMailAddress
.
Must be followed by a call to a condition method.Prepares a where statement for the columnExternalId
.
Must be followed by a call to a condition method.fullName()
Prepares a where statement for the columnFullName
.
Must be followed by a call to a condition method.name()
Prepares a where statement for the columnName
.
Must be followed by a call to a condition method.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.Prepares a where statement for the columnSecurityMemberId
.
Must be followed by a call to a condition method.Prepares a where statement for the columnSecuritySystemId
.
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 Details
-
not
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 Java.
-
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:
- API:
- This public API is available in Java.
-
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:
- API:
- This public API is available in Java.
-
securitySystemId
Description copied from interface:UserQuery.IFilterableColumns
Prepares a where statement for the column
SecuritySystemId
.
Must be followed by a call to a condition method.- Specified by:
securitySystemId
in interfaceUserQuery.IFilterableColumns
- Returns:
- query for further composition
- See Also:
- API:
- This public API is available in Java.
-
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:
- API:
- This public API is available in Java.
-
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:
- API:
- This public API is available in Java.
-
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:
- API:
- This public API is available in Java.
-