Package ch.ivyteam.ivy.workflow.query

Interface CaseQuery.IStringColumnFilterQuery

All Superinterfaces:

CaseQuery.IColumnFilterQuery, CaseQuery.IPatternColumnFilterQuery

Enclosing class:

CaseQuery

public static interface CaseQuery.IStringColumnFilterQuery
extends CaseQuery.IPatternColumnFilterQuery

Provides filter functionality for a string column of ICase

API:

This is a public API.

Method Summary

Modifier and Type	Method	Description
CaseQuery.FilterLink	isEqual(String value)	Adds a filter condition that selects rows with the given value.
CaseQuery.FilterLink	isEqualIgnoreCase(String value)	Adds a filter condition that selects rows with the given value ignoring case.
CaseQuery.FilterLink	isGreaterOrEqualThan(String value)	Adds a filter condition that selects rows that have values that are greater than the given value.
CaseQuery.FilterLink	isGreaterThan(String value)	Adds a filter condition that selects rows that have values that are greater than the given value.
CaseQuery.FilterLink	isLowerOrEqualThan(String value)	Adds a filter condition that selects rows that have values that are lower or equal than the given value.
CaseQuery.FilterLink	isLowerThan(String value)	Adds a filter condition that selects rows that have values that are lower than the given value.
CaseQuery.FilterLink	isNotEqual(String value)	Adds a filter condition that selects rows that do not have the given value.
CaseQuery.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.workflow.query.CaseQuery.IColumnFilterQuery

isNotNull, isNull

Methods inherited from interface ch.ivyteam.ivy.workflow.query.CaseQuery.IPatternColumnFilterQuery

isLike, isLikeIgnoreCase, isNotLike, isNotLikeIgnoreCase

Method Detail

isEqual

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

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

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

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

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

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

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

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