Interface CaseQuery.IPatternColumnFilterQuery
-
- All Superinterfaces:
CaseQuery.IColumnFilterQuery
- All Known Subinterfaces:
CaseQuery.IClobColumnFilterQuery
,CaseQuery.IIntegerColumnFilterQuery
,CaseQuery.INumberColumnFilterQuery
,CaseQuery.IStringColumnFilterQuery
- Enclosing class:
- CaseQuery
public static interface CaseQuery.IPatternColumnFilterQuery extends CaseQuery.IColumnFilterQuery
Provides filter functionality for columns ofICase
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 CaseQuery.FilterLink
isLike(String value)
Adds a filter condition that selects rows that have values that are like the givenvalue
.CaseQuery.FilterLink
isLikeIgnoreCase(String value)
Adds a filter condition that selects rows that have values that are like the givenvalue
ignoring case.CaseQuery.FilterLink
isNotLike(String value)
Adds a filter condition that selects rows that have values that are not like the givenvalue
.CaseQuery.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.CaseQuery.IColumnFilterQuery
isNotNull, isNull
-
-
-
-
Method Detail
-
isLike
CaseQuery.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
CaseQuery.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
CaseQuery.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
CaseQuery.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.
-
-