Package ch.ivyteam.ivy.workflow.query

Interface CaseQuery.IPatternColumnFilterQuery

All Superinterfaces:
CaseQuery.IColumnFilterQuery
All Known Subinterfaces:
CaseQuery.IClobColumnFilterQuery, CaseQuery.IIntegerColumnFilterQuery, CaseQuery.INumberColumnFilterQuery, CaseQuery.IStringColumnFilterQuery
Enclosing class:
CaseQuery
public static interface CaseQuery.IPatternColumnFilterQuery extends CaseQuery.IColumnFilterQuery
Provides filter functionality for columns of ICase that can be filter by string patterns (isLike)
API:
This is a public API.

  • Method Details

    • isLike

      CaseQuery.FilterLink isLike(String value)

      Adds a filter condition that selects rows that have values that are like the given value.

      SQL part: [column] IS LIKE '[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 isLikeIgnoreCase(String) because indexes are used if available and the value does not start with wildcards.

      Parameters:
      value -
      Returns:
      query for further composition
      See Also:
      API:
      This public API is available in IvyScript and Java. It has the visibility EXPERT.

    • isLikeIgnoreCase

      CaseQuery.FilterLink isLikeIgnoreCase(String value)

      Adds a filter condition that selects rows that have values that are like the given value ignoring case.

      SQL part: LOWER([column]) IS LIKE LOWER('[value]')

      The operation is case insensitive (ignores case). E.g. 'a' is equal to 'A'.

      This method might be slower than isLike(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.

    • isNotLike

      CaseQuery.FilterLink isNotLike(String value)

      Adds a filter condition that selects rows that have values that are not like the given value.

      SQL part: [column] IS NOT LIKE '[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 isNotLikeIgnoreCase(String) because indexes are used if available and the value does not start with wildcards.

      Parameters:
      value -
      Returns:
      query for further composition
      See Also:
      API:
      This public API is available in IvyScript and Java. It has the visibility EXPERT.

    • isNotLikeIgnoreCase

      CaseQuery.FilterLink isNotLikeIgnoreCase(String value)

      Adds a filter condition that selects rows that have values that are not like the given value ignoring case.

      SQL part: LOWER([column]) IS NOT LIKE LOWER('[value]')

      The operation is case insensitive (ignores case). E.g. 'a' is equal to 'A'.

      This method might be slower than isNotLike(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.