Interface UserQuery.IStringColumnFilterQuery
- All Superinterfaces:
UserQuery.IColumnFilterQuery
,UserQuery.IPatternColumnFilterQuery
- Enclosing class:
- UserQuery
IUser
- API:
- This is a public API.
-
Method Summary
Modifier and TypeMethodDescriptionAdds a filter condition that selects rows with the givenvalue
.isEqualIgnoreCase
(String value) Adds a filter condition that selects rows with the givenvalue
ignoring case.isGreaterOrEqualThan
(String value) Adds a filter condition that selects rows that have values that are greater than the givenvalue
.isGreaterThan
(String value) Adds a filter condition that selects rows that have values that are greater than the givenvalue
.isLowerOrEqualThan
(String value) Adds a filter condition that selects rows that have values that are lower or equal than the givenvalue
.isLowerThan
(String value) Adds a filter condition that selects rows that have values that are lower than the givenvalue
.isNotEqual
(String value) Adds a filter condition that selects rows that do not have the givenvalue
.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.security.query.UserQuery.IColumnFilterQuery
isNotNull, isNull
Methods inherited from interface ch.ivyteam.ivy.security.query.UserQuery.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
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:
- API:
- This public API is available in Java.
-
isEqualIgnoreCase
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:
- 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]'
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:
- API:
- This public API is available in Java.
-
isNotEqualIgnoreCase
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:
- 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
- API:
- This public API is available in Java.
-
isGreaterOrEqualThan
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 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
- 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
- API:
- This public API is available in Java.
-