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 for IUser
Example:
```
UserQuery.create().where().name().isLike("john%");
```
Corresponds to SQL: 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 column `ApplicationId`. Must be followed by a call to a condition method.
`UserQuery.IStringColumnFilterQuery`	`eMailAddress()`	Prepares a where statement for the column `EMailAddress`. Must be followed by a call to a condition method.
`UserQuery.IStringColumnFilterQuery`	`externalId()`	Prepares a where statement for the column `ExternalId`. Must be followed by a call to a condition method.
`UserQuery.IStringColumnFilterQuery`	`fullName()`	Prepares a where statement for the column `FullName`. Must be followed by a call to a condition method.
`UserQuery.IStringColumnFilterQuery`	`name()`	Prepares a where statement for the column `Name`. 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 the `otherQuery` with a NOT expression. Only the where clause of the given `otherQuery` is considered.
`UserQuery.IStringColumnFilterQuery`	`securityMemberId()`	Prepares a where statement for the column `SecurityMemberId`. 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 given otherQuery is considered. All other parts are ignored.
    
    SQL part: NOT([otherSqlExpression])
    
    Example:
    UserQuery subQuery = UserQuery.create().where() .name().isEqual("john"); UserQuery query = UserQuery.create().where() .not(subQuery);
    Corresponds to SQL: SELECT * FROM IWA_IWA_User WHERE NOT(name = 'john')
    Specified by:
    
    not in interface UserQuery.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 interface UserQuery.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 interface UserQuery.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 interface UserQuery.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 interface UserQuery.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 interface UserQuery.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 interface UserQuery.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.

Class UserQuery.FilterQuery

Nested Class Summary

Nested classes/interfaces inherited from class ch.ivyteam.ivy.security.query.UserQuery

Method Summary

Methods inherited from class ch.ivyteam.ivy.security.query.UserQuery.FilterLink

Methods inherited from class ch.ivyteam.ivy.security.query.UserQuery

Methods inherited from interface ch.ivyteam.ivy.security.query.UserQuery.IFilterLink

Method Detail

not

name

fullName

applicationId

externalId

eMailAddress

securityMemberId