Package ch.ivyteam.ivy.security.query

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 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

Modifier and Type	Method	Description
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.
UserQuery.IIntegerColumnFilterQuery	securitySystemId()	Prepares a where statement for the column SecuritySystemId. 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

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.

securitySystemId

public UserQuery.IIntegerColumnFilterQuery 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 interface UserQuery.IFilterableColumns

Returns:

query for further composition

See Also:

• UserQuery.IFilterableColumns.securitySystemId()

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.