Package ch.ivyteam.ivy.workflow.query

Interface SignalEventQuery.IPatternColumnFilterQuery

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

  • Method Details

    • isLike

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

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

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

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