Package ch.ivyteam.ivy.workflow.query

Interface CaseQuery.IStringColumnFilterQuery

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

  • Method Details

    • isEqual

      CaseQuery.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 IvyScript and Java. It has the visibility EXPERT.

    • isEqualIgnoreCase

      CaseQuery.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 IvyScript and Java. It has the visibility EXPERT.

    • isNotEqual

      CaseQuery.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 IvyScript and Java. It has the visibility EXPERT.

    • isNotEqualIgnoreCase

      CaseQuery.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 IvyScript and Java. It has the visibility EXPERT.

    • isGreaterThan

      CaseQuery.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 IvyScript and Java. It has the visibility EXPERT.

    • isGreaterOrEqualThan

      CaseQuery.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 IvyScript and Java. It has the visibility EXPERT.

    • isLowerThan

      CaseQuery.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 IvyScript and Java. It has the visibility EXPERT.

    • isLowerOrEqualThan

      CaseQuery.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 IvyScript and Java. It has the visibility EXPERT.