Package ch.ivyteam.ivy.security.query

Interface UserQuery.IStringColumnFilterQuery

All Superinterfaces:
UserQuery.IColumnFilterQuery, UserQuery.IPatternColumnFilterQuery
Enclosing class:
UserQuery
public static interface UserQuery.IStringColumnFilterQuery extends UserQuery.IPatternColumnFilterQuery
Provides filter functionality for a string column of IUser
API:
This is a public API.

  • Method Details

    • isEqual

      UserQuery.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:
      API:
      This public API is available in Java.

    • isEqualIgnoreCase

      UserQuery.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:
      API:
      This public API is available in Java.

    • isNotEqual

      UserQuery.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:
      API:
      This public API is available in Java.

    • isNotEqualIgnoreCase

      UserQuery.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:
      API:
      This public API is available in Java.

    • isGreaterThan

      @Deprecated(since="13.1", forRemoval=true) UserQuery.FilterLink isGreaterThan(String value)
      Deprecated, for removal: This API element is subject to removal in a future version.
      isGreaterThan on string fields make no sense.

      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

      @Deprecated(since="13.1", forRemoval=true) UserQuery.FilterLink isGreaterOrEqualThan(String value)
      Deprecated, for removal: This API element is subject to removal in a future version.
      isGreaterOrEqualThan on string fields make no sense.

      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

      @Deprecated(since="13.1", forRemoval=true) UserQuery.FilterLink isLowerThan(String value)
      Deprecated, for removal: This API element is subject to removal in a future version.
      isLowerThan on string fields make no sense.

      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

      @Deprecated(since="13.1", forRemoval=true) UserQuery.FilterLink isLowerOrEqualThan(String value)
      Deprecated, for removal: This API element is subject to removal in a future version.
      isLowerOrEqualThan on string fields make no sense.

      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.