Package ch.ivyteam.ivy.security.query

Interface UserQuery.IPatternColumnFilterQuery

All Superinterfaces:

UserQuery.IColumnFilterQuery

All Known Subinterfaces:

UserQuery.IIntegerColumnFilterQuery, UserQuery.INumberColumnFilterQuery, UserQuery.IStringColumnFilterQuery

Enclosing class:

UserQuery

public static interface UserQuery.IPatternColumnFilterQuery
extends UserQuery.IColumnFilterQuery

Provides filter functionality for columns of IUser that can be filter by string patterns (isLike)

API:

This is a public API.

Method Summary

Modifier and Type	Method	Description
UserQuery.FilterLink	isLike(String value)	Adds a filter condition that selects rows that have values that are like the given value.
UserQuery.FilterLink	isLikeIgnoreCase(String value)	Adds a filter condition that selects rows that have values that are like the given value ignoring case.
UserQuery.FilterLink	isNotLike(String value)	Adds a filter condition that selects rows that have values that are not like the given value.
UserQuery.FilterLink	isNotLikeIgnoreCase(String value)	Adds a filter condition that selects rows that have values that are not like the given value ignoring case.

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

isNotNull, isNull

Method Detail

isLike

UserQuery.FilterLink isLike(String value)

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

SQL part: [column] IS LIKE '[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 isLikeIgnoreCase(String) because indexes are used if available and the value does not start with wildcards.

Parameters:

value -

Returns:

query for further composition

See Also:

isLikeIgnoreCase(String)

API:

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

isLikeIgnoreCase

UserQuery.FilterLink isLikeIgnoreCase(String value)

Adds a filter condition that selects rows that have values that are like the given value ignoring case.

SQL part: LOWER([column]) IS LIKE LOWER('[value]')

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

This method might be slower than isLike(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:

isLike(String)

API:

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

isNotLike

UserQuery.FilterLink isNotLike(String value)

Adds a filter condition that selects rows that have values that are not like the given value.

SQL part: [column] IS NOT LIKE '[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 isNotLikeIgnoreCase(String) because indexes are used if available and the value does not start with wildcards.

Parameters:

value -

Returns:

query for further composition

See Also:

isNotLikeIgnoreCase(String)

API:

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

isNotLikeIgnoreCase

UserQuery.FilterLink isNotLikeIgnoreCase(String value)

Adds a filter condition that selects rows that have values that are not like the given value ignoring case.

SQL part: LOWER([column]) IS NOT LIKE LOWER('[value]')

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

This method might be slower than isNotLike(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:

isNotLike(String)

API:

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