Package ch.ivyteam.ivy.workflow.query

Interface TaskQuery.IUUIDColumnFilterQuery

Enclosing class:
TaskQuery
public static interface TaskQuery.IUUIDColumnFilterQuery
Since:
11.2
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.

      Parameters:
      value -
      Returns:
      query for further composition
      Since:
      11.2
      API:
      This public API is available in Java.

    • isNull

      TaskQuery.FilterLink isNull()

      Adds a filter condition that selects rows with null.

      SQL part: [column] IS NULL

      Returns:
      query for further composition
      Since:
      11.3
      API:
      This public API is available in Java.

    • isNotNull

      TaskQuery.FilterLink isNotNull()

      Adds a filter condition that selects rows with NOT null.

      SQL part: [column] = IS NOT NULL

      Returns:
      query for further composition
      Since:
      11.3
      API:
      This public API is available in Java.

    • isIn

      TaskQuery.FilterLink isIn(String... values)

      Adds a filter condition that selects rows that have values that are in the given list of values.

      SQL part: [column] IN ([values])

      Parameters:
      values -
      Returns:
      query for further composition
      Since:
      12.0.5
      API:
      This public API is available in Java.

    • isIn

      TaskQuery.FilterLink isIn(List<String> values)

      Adds a filter condition that selects rows that have values that are in the given list of values.

      SQL part: [column] IN ([values])

      Parameters:
      values -
      Returns:
      query for further composition
      Since:
      12.0.5
      API:
      This public API is available in Java.

    • isNotIn

      TaskQuery.FilterLink isNotIn(String... values)

      Adds a filter condition that selects rows that have values that are not in the given list of values.

      SQL part: [column] NOT IN ([values])

      Parameters:
      values -
      Returns:
      query for further composition
      Since:
      12.0.5
      API:
      This public API is available in Java.

    • isNotIn

      TaskQuery.FilterLink isNotIn(List<String> values)

      Adds a filter condition that selects rows that have values that are not in the given list of values.

      SQL part: [column] NOT IN ([values])

      Parameters:
      values -
      Returns:
      query for further composition
      Since:
      12.0.5
      API:
      This public API is available in Java.