Package ch.ivyteam.ivy.workflow.query

Interface CaseQuery.IPatternColumnFilterQuery

All Superinterfaces:

CaseQuery.IColumnFilterQuery

All Known Subinterfaces:

CaseQuery.IClobColumnFilterQuery, CaseQuery.IIntegerColumnFilterQuery, CaseQuery.INumberColumnFilterQuery, CaseQuery.IStringColumnFilterQuery

Enclosing class:

CaseQuery

public static interface CaseQuery.IPatternColumnFilterQuery
extends CaseQuery.IColumnFilterQuery

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

API:

This is a public API.

Method Summary

Modifier and Type	Method	Description
CaseQuery.FilterLink	isLike(String value)	Adds a filter condition that selects rows that have values that are like the given value.
CaseQuery.FilterLink	isLikeIgnoreCase(String value)	Adds a filter condition that selects rows that have values that are like the given value ignoring case.
CaseQuery.FilterLink	isNotLike(String value)	Adds a filter condition that selects rows that have values that are not like the given value.
CaseQuery.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.workflow.query.CaseQuery.IColumnFilterQuery

isNotNull, isNull

Method Detail

isLike

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

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

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

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