Interface CaseQuery.INumberColumnFilterQuery
- All Superinterfaces:
CaseQuery.IColumnFilterQuery
,CaseQuery.IPatternColumnFilterQuery
- Enclosing class:
- CaseQuery
ICase
- API:
- This is a public API.
-
Method Summary
Modifier and TypeMethodDescriptionAdds a filter condition that selects rows with the givenvalue
.isGreaterOrEqualThan
(Number value) Adds a filter condition that selects rows that have values that are greater or equal than the givenvalue
.isGreaterThan
(Number value) Adds a filter condition that selects rows that have values that are greater than the givenvalue
.isLowerOrEqualThan
(Number value) Adds a filter condition that selects rows that have values that are lower or equal than the givenvalue
.isLowerThan
(Number value) Adds a filter condition that selects rows that have values that are lower than the givenvalue
.isNotEqual
(Number value) Adds a filter condition that selects rows that do not have the givenvalue
.Methods inherited from interface ch.ivyteam.ivy.workflow.query.CaseQuery.IColumnFilterQuery
isNotNull, isNull
Methods inherited from interface ch.ivyteam.ivy.workflow.query.CaseQuery.IPatternColumnFilterQuery
isLike, isLikeIgnoreCase, isNotLike, isNotLikeIgnoreCase
-
Method Details
-
isEqual
Adds a filter condition that selects rows with the given
value
.SQL part:
[column] = [value]
or[column] IS NULL
- Parameters:
value
-- Returns:
- query for further composition
- API:
- This public API is available in Java.
-
isNotEqual
Adds a filter condition that selects rows that do not have the given
value
.SQL part:
[column] <> [value]
or[column] IS NOT NULL
- Parameters:
value
-- Returns:
- query for further composition
- API:
- This public API is available in Java.
-
isGreaterThan
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
- Throws:
IllegalArgumentException
- If the given value is null- API:
- This public API is available in Java.
-
isGreaterOrEqualThan
Adds a filter condition that selects rows that have values that are greater or equal than the given
value
.SQL part:
[column] >= [value]
- Parameters:
value
-- Returns:
- query for further composition
- Throws:
IllegalArgumentException
- If the given value is null- API:
- This public API is available in Java.
-
isLowerThan
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
- Throws:
IllegalArgumentException
- If the given value is null- API:
- This public API is available in Java.
-
isLowerOrEqualThan
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
- Throws:
IllegalArgumentException
- If the given value is null- API:
- This public API is available in Java.
-