Package ch.ivyteam.ivy.workflow.query

Interface TaskBoundarySignalEventReceiverQuery.IStringColumnFilterQuery

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

  • Method Details

    • isEqual

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

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

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

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

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

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

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

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