Package ch.ivyteam.ivy.security.query

Interface UserQuery.IStringColumnFilterQuery

All Superinterfaces:

UserQuery.IColumnFilterQuery, UserQuery.IPatternColumnFilterQuery

Enclosing class:

UserQuery

public static interface UserQuery.IStringColumnFilterQuery
extends UserQuery.IPatternColumnFilterQuery

Provides filter functionality for a string column of IUser

API:

This is a public API.

Method Summary

Modifier and Type	Method	Description
UserQuery.FilterLink	isEqual(String value)	Adds a filter condition that selects rows with the given value.
UserQuery.FilterLink	isEqualIgnoreCase(String value)	Adds a filter condition that selects rows with the given value ignoring case.
UserQuery.FilterLink	isGreaterOrEqualThan(String value)	Adds a filter condition that selects rows that have values that are greater than the given value.
UserQuery.FilterLink	isGreaterThan(String value)	Adds a filter condition that selects rows that have values that are greater than the given value.
UserQuery.FilterLink	isLowerOrEqualThan(String value)	Adds a filter condition that selects rows that have values that are lower or equal than the given value.
UserQuery.FilterLink	isLowerThan(String value)	Adds a filter condition that selects rows that have values that are lower than the given value.
UserQuery.FilterLink	isNotEqual(String value)	Adds a filter condition that selects rows that do not have the given value.
UserQuery.FilterLink	isNotEqualIgnoreCase(String value)	Adds a filter condition that selects rows that do not have the given value ignoring case.

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

isNotNull, isNull

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

isLike, isLikeIgnoreCase, isNotLike, isNotLikeIgnoreCase

Method Detail

isEqual

UserQuery.FilterLink isEqual(String value)

Adds a filter condition that selects rows with the given value.

SQL part: [column] = '[value]' or [column] IS NULL

The operation might be case sensitive or insensitive depending on the database system. See Engine Guide > System Database > Character set and collation for details.

This method might be faster than isEqualIgnoreCase(String) because indexes are used if available.

Parameters:

value -

Returns:

query for further composition

See Also:

isEqualIgnoreCase(String)

API:

This public API is available in IvyScript and Java. It has the visibility EXPERT.

isEqualIgnoreCase

UserQuery.FilterLink isEqualIgnoreCase(String value)

Adds a filter condition that selects rows with the given value ignoring case.

SQL part: LOWER([column]) = LOWER('[value]') or [column] IS NULL

The operation is case insensitive (ignores case). E.g. 'a' is equal to 'A'.

This method might be slower than isEqual(String) because indexes cannot be used. See Engine Guide > System Database > Character set and collation for details.

Parameters:

value -

Returns:

query for further composition

Since:

6.7

See Also:

isEqual(String)

API:

This public API is available in IvyScript and Java. It has the visibility EXPERT.

isNotEqual

UserQuery.FilterLink isNotEqual(String value)

Adds a filter condition that selects rows that do not have the given value.

SQL part: [column] <> '[value]'

The operation might be case sensitive or insensitive depending on the database system. See Engine Guide > System Database > Character set and collation for details.

This method might be faster than isNotEqualIgnoreCase(String) because indexes are used if available.

Parameters:

value -

Returns:

query for further composition

See Also:

isNotEqualIgnoreCase(String)

API:

This public API is available in IvyScript and Java. It has the visibility EXPERT.

isNotEqualIgnoreCase

UserQuery.FilterLink isNotEqualIgnoreCase(String value)

Adds a filter condition that selects rows that do not have the given value ignoring case.

SQL part: LOWER([column]) <> LOWER('[value]') or [column] IS NULL

The operation is case insensitive (ignores case). E.g. 'a' is equal to 'A'.

This method might be slower than isNotEqual(String) because indexes cannot be used. See Engine Guide > System Database > Character set and collation for details.

Parameters:

value -

Returns:

query for further composition

Since:

6.7

See Also:

isNotEqual(String)

API:

This public API is available in IvyScript and Java. It has the visibility EXPERT.

isGreaterThan

UserQuery.FilterLink isGreaterThan(String value)

Adds a filter condition that selects rows that have values that are greater than the given value.

SQL part: [column] > '[value]'

Parameters:

value -

Returns:

query for further composition

API:

This public API is available in IvyScript and Java. It has the visibility EXPERT.

isGreaterOrEqualThan

UserQuery.FilterLink isGreaterOrEqualThan(String value)

Adds a filter condition that selects rows that have values that are greater than the given value.

SQL part: [column] >= '[value]'

Parameters:

value -

Returns:

query for further composition

API:

This public API is available in IvyScript and Java. It has the visibility EXPERT.

isLowerThan

UserQuery.FilterLink isLowerThan(String value)

Adds a filter condition that selects rows that have values that are lower than the given value.

SQL part: [column] < '[value]'

Parameters:

value -

Returns:

query for further composition

API:

This public API is available in IvyScript and Java. It has the visibility EXPERT.

isLowerOrEqualThan

UserQuery.FilterLink isLowerOrEqualThan(String value)

Adds a filter condition that selects rows that have values that are lower or equal than the given value.

SQL part: [column] <= '[value]'

Parameters:

value -

Returns:

query for further composition

API:

This public API is available in IvyScript and Java. It has the visibility EXPERT.