Interface UserQuery.INumberColumnFilterQuery
-
- All Superinterfaces:
UserQuery.IColumnFilterQuery
,UserQuery.IPatternColumnFilterQuery
- Enclosing class:
- UserQuery
public static interface UserQuery.INumberColumnFilterQuery extends UserQuery.IPatternColumnFilterQuery
Provides filter functionality for a decimal number column ofIUser
- API:
- This is a public API.
-
-
Method Summary
All Methods Instance Methods Abstract Methods Modifier and Type Method Description UserQuery.FilterLink
isEqual(Number value)
Adds a filter condition that selects rows with the givenvalue
.UserQuery.FilterLink
isGreaterOrEqualThan(Number value)
Adds a filter condition that selects rows that have values that are greater or equal than the givenvalue
.UserQuery.FilterLink
isGreaterThan(Number value)
Adds a filter condition that selects rows that have values that are greater than the givenvalue
.UserQuery.FilterLink
isLowerOrEqualThan(Number value)
Adds a filter condition that selects rows that have values that are lower or equal than the givenvalue
.UserQuery.FilterLink
isLowerThan(Number value)
Adds a filter condition that selects rows that have values that are lower than the givenvalue
.UserQuery.FilterLink
isNotEqual(Number value)
Adds a filter condition that selects rows that do not have the givenvalue
.-
Methods inherited from interface ch.ivyteam.ivy.security.query.UserQuery.IColumnFilterQuery
isNotNull, isNull
-
Methods inherited from interface ch.ivyteam.ivy.security.query.UserQuery.IPatternColumnFilterQuery
isLike, isLikeIgnoreCase, isNotLike, isNotLikeIgnoreCase
-
-
-
-
Method Detail
-
isEqual
UserQuery.FilterLink isEqual(Number value)
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 IvyScript and Java. It has the visibility EXPERT.
-
isNotEqual
UserQuery.FilterLink isNotEqual(Number value)
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 IvyScript and Java. It has the visibility EXPERT.
-
isGreaterThan
UserQuery.FilterLink isGreaterThan(Number 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
- Throws:
IllegalArgumentException
- If the given value is null- API:
- This public API is available in IvyScript and Java. It has the visibility EXPERT.
-
isGreaterOrEqualThan
UserQuery.FilterLink isGreaterOrEqualThan(Number value)
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 IvyScript and Java. It has the visibility EXPERT.
-
isLowerThan
UserQuery.FilterLink isLowerThan(Number 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
- Throws:
IllegalArgumentException
- If the given value is null- API:
- This public API is available in IvyScript and Java. It has the visibility EXPERT.
-
isLowerOrEqualThan
UserQuery.FilterLink isLowerOrEqualThan(Number 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
- Throws:
IllegalArgumentException
- If the given value is null- API:
- This public API is available in IvyScript and Java. It has the visibility EXPERT.
-
-