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