Package ch.ivyteam.ivy.workflow.query

Interface TaskQuery.IStringColumnFilterQuery

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

  • Method Details

    • isEqual

      TaskQuery.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

      TaskQuery.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

      TaskQuery.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

      TaskQuery.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

      TaskQuery.FilterLink isGreaterThan(String 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
      API:
      This public API is available in Java.

    • isGreaterOrEqualThan

      TaskQuery.FilterLink isGreaterOrEqualThan(String 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
      API:
      This public API is available in Java.

    • isLowerThan

      TaskQuery.FilterLink isLowerThan(String 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
      API:
      This public API is available in Java.

    • isLowerOrEqualThan

      TaskQuery.FilterLink isLowerOrEqualThan(String 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
      API:
      This public API is available in Java.