Package ch.ivyteam.ivy.workflow.query

Interface CaseQuery.IColumnFilterQuery

All Known Subinterfaces:
CaseQuery.ICaseStateFilterQuery, CaseQuery.IClobColumnFilterQuery, CaseQuery.IDateColumnFilterQuery, CaseQuery.IIntegerColumnFilterQuery, CaseQuery.INumberColumnFilterQuery, CaseQuery.IPatternColumnFilterQuery, CaseQuery.IStringColumnFilterQuery, CaseQuery.IWorkflowPriorityFilterQuery
Enclosing class:
CaseQuery
public static interface CaseQuery.IColumnFilterQuery
Basic filter functionality provider for a column of ICase
API:
This is a public API.

  • Method Summary

    Modifier and Type
    Method
    Description
    CaseQuery.FilterLink
    isNotNull()
    Adds a filter condition that selects rows that do not have NULL values.
    CaseQuery.FilterLink
    isNull()
    Adds a filter condition that selects rows with NULL values.

  • Method Details

    • isNull

      CaseQuery.FilterLink isNull()

      Adds a filter condition that selects rows with NULL values.

      SQL part: [column] IS NULL

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

    • isNotNull

      CaseQuery.FilterLink isNotNull()

      Adds a filter condition that selects rows that do not have NULL values.

      SQL part: [column] IS NOT NULL

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