Interface TaskBoundarySignalEventReceiverQuery.IPatternColumnFilterQuery
- All Superinterfaces:
TaskBoundarySignalEventReceiverQuery.IColumnFilterQuery
- All Known Subinterfaces:
TaskBoundarySignalEventReceiverQuery.IIntegerColumnFilterQuery
,TaskBoundarySignalEventReceiverQuery.INumberColumnFilterQuery
,TaskBoundarySignalEventReceiverQuery.IStringColumnFilterQuery
- Enclosing class:
- TaskBoundarySignalEventReceiverQuery
ITaskBoundarySignalEventReceiver
that can be filter by string patterns (isLike)- API:
- This is a public API.
-
Method Summary
Modifier and TypeMethodDescriptionAdds a filter condition that selects rows that have values that are like the givenvalue
.isLikeIgnoreCase
(String value) Adds a filter condition that selects rows that have values that are like the givenvalue
ignoring case.Adds a filter condition that selects rows that have values that are not like the givenvalue
.isNotLikeIgnoreCase
(String value) Adds a filter condition that selects rows that have values that are not like the givenvalue
ignoring case.Methods inherited from interface ch.ivyteam.ivy.workflow.query.TaskBoundarySignalEventReceiverQuery.IColumnFilterQuery
isNotNull, isNull
-
Method Details
-
isLike
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:
- API:
- This public API is available in Java.
-
isLikeIgnoreCase
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:
- API:
- This public API is available in Java.
-
isNotLike
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:
- API:
- This public API is available in Java.
-
isNotLikeIgnoreCase
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:
- API:
- This public API is available in Java.
-