Package ch.ivyteam.ivy.workflow.query

Interface TaskQuery.IStringColumnFilterQuery

All Superinterfaces:

TaskQuery.IColumnFilterQuery, TaskQuery.IPatternColumnFilterQuery

Enclosing class:

TaskQuery

public static interface TaskQuery.IStringColumnFilterQuery
extends TaskQuery.IPatternColumnFilterQuery

Provides filter functionality for a string column of ITask

API:

This is a public API.

Method Summary

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

isNotNull, isNull

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

isLike, isLikeIgnoreCase, isNotLike, isNotLikeIgnoreCase

Method Detail

isEqual

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

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

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

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

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

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

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

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