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 Detail

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.