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 ofITask
- API:
- This is a public API.
-
-
Method Summary
All Methods Instance Methods Abstract Methods Modifier and Type Method Description TaskQuery.FilterLink
isEqual(String value)
Adds a filter condition that selects rows with the givenvalue
.TaskQuery.FilterLink
isEqualIgnoreCase(String value)
Adds a filter condition that selects rows with the givenvalue
ignoring case.TaskQuery.FilterLink
isGreaterOrEqualThan(String value)
Adds a filter condition that selects rows that have values that are greater than the givenvalue
.TaskQuery.FilterLink
isGreaterThan(String value)
Adds a filter condition that selects rows that have values that are greater than the givenvalue
.TaskQuery.FilterLink
isLowerOrEqualThan(String value)
Adds a filter condition that selects rows that have values that are lower or equal than the givenvalue
.TaskQuery.FilterLink
isLowerThan(String value)
Adds a filter condition that selects rows that have values that are lower than the givenvalue
.TaskQuery.FilterLink
isNotEqual(String value)
Adds a filter condition that selects rows that do not have the givenvalue
.TaskQuery.FilterLink
isNotEqualIgnoreCase(String value)
Adds a filter condition that selects rows that do not have the givenvalue
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.
-
-