Interface StartSignalEventElementQuery.IPatternColumnFilterQuery
-
- All Superinterfaces:
StartSignalEventElementQuery.IColumnFilterQuery
- All Known Subinterfaces:
StartSignalEventElementQuery.IIntegerColumnFilterQuery
,StartSignalEventElementQuery.INumberColumnFilterQuery
,StartSignalEventElementQuery.IStringColumnFilterQuery
- Enclosing class:
- StartSignalEventElementQuery
public static interface StartSignalEventElementQuery.IPatternColumnFilterQuery extends StartSignalEventElementQuery.IColumnFilterQuery
Provides filter functionality for columns ofIStartSignalEventElement
that can be filter by string patterns (isLike)- API:
- This is a public API.
-
-
Method Summary
All Methods Instance Methods Abstract Methods Modifier and Type Method Description StartSignalEventElementQuery.FilterLink
isLike(String value)
Adds a filter condition that selects rows that have values that are like the givenvalue
.StartSignalEventElementQuery.FilterLink
isLikeIgnoreCase(String value)
Adds a filter condition that selects rows that have values that are like the givenvalue
ignoring case.StartSignalEventElementQuery.FilterLink
isNotLike(String value)
Adds a filter condition that selects rows that have values that are not like the givenvalue
.StartSignalEventElementQuery.FilterLink
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.StartSignalEventElementQuery.IColumnFilterQuery
isNotNull, isNull
-
-
-
-
Method Detail
-
isLike
StartSignalEventElementQuery.FilterLink isLike(String value)
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:
isLikeIgnoreCase(String)
- API:
- This public API is available in IvyScript and Java. It has the visibility EXPERT.
-
isLikeIgnoreCase
StartSignalEventElementQuery.FilterLink isLikeIgnoreCase(String value)
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:
isLike(String)
- API:
- This public API is available in IvyScript and Java. It has the visibility EXPERT.
-
isNotLike
StartSignalEventElementQuery.FilterLink isNotLike(String value)
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:
isNotLikeIgnoreCase(String)
- API:
- This public API is available in IvyScript and Java. It has the visibility EXPERT.
-
isNotLikeIgnoreCase
StartSignalEventElementQuery.FilterLink isNotLikeIgnoreCase(String value)
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:
isNotLike(String)
- API:
- This public API is available in IvyScript and Java. It has the visibility EXPERT.
-
-