Interface TaskBoundarySignalEventReceiverQuery.IStringColumnFilterQuery
-
- All Superinterfaces:
TaskBoundarySignalEventReceiverQuery.IColumnFilterQuery
,TaskBoundarySignalEventReceiverQuery.IPatternColumnFilterQuery
- Enclosing class:
- TaskBoundarySignalEventReceiverQuery
public static interface TaskBoundarySignalEventReceiverQuery.IStringColumnFilterQuery extends TaskBoundarySignalEventReceiverQuery.IPatternColumnFilterQuery
Provides filter functionality for a string column ofITaskBoundarySignalEventReceiver
- API:
- This is a public API.
-
-
Method Summary
All Methods Instance Methods Abstract Methods Modifier and Type Method Description TaskBoundarySignalEventReceiverQuery.FilterLink
isEqual(String value)
Adds a filter condition that selects rows with the givenvalue
.TaskBoundarySignalEventReceiverQuery.FilterLink
isEqualIgnoreCase(String value)
Adds a filter condition that selects rows with the givenvalue
ignoring case.TaskBoundarySignalEventReceiverQuery.FilterLink
isGreaterOrEqualThan(String value)
Adds a filter condition that selects rows that have values that are greater than the givenvalue
.TaskBoundarySignalEventReceiverQuery.FilterLink
isGreaterThan(String value)
Adds a filter condition that selects rows that have values that are greater than the givenvalue
.TaskBoundarySignalEventReceiverQuery.FilterLink
isLowerOrEqualThan(String value)
Adds a filter condition that selects rows that have values that are lower or equal than the givenvalue
.TaskBoundarySignalEventReceiverQuery.FilterLink
isLowerThan(String value)
Adds a filter condition that selects rows that have values that are lower than the givenvalue
.TaskBoundarySignalEventReceiverQuery.FilterLink
isNotEqual(String value)
Adds a filter condition that selects rows that do not have the givenvalue
.TaskBoundarySignalEventReceiverQuery.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.TaskBoundarySignalEventReceiverQuery.IColumnFilterQuery
isNotNull, isNull
-
Methods inherited from interface ch.ivyteam.ivy.workflow.query.TaskBoundarySignalEventReceiverQuery.IPatternColumnFilterQuery
isLike, isLikeIgnoreCase, isNotLike, isNotLikeIgnoreCase
-
-
-
-
Method Detail
-
isEqual
TaskBoundarySignalEventReceiverQuery.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
TaskBoundarySignalEventReceiverQuery.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
TaskBoundarySignalEventReceiverQuery.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
TaskBoundarySignalEventReceiverQuery.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
TaskBoundarySignalEventReceiverQuery.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
TaskBoundarySignalEventReceiverQuery.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
TaskBoundarySignalEventReceiverQuery.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
TaskBoundarySignalEventReceiverQuery.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.
-
-