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

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.

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.