Package ch.ivyteam.ivy.workflow.query

Interface CaseQuery.IDateColumnFilterQuery

All Superinterfaces:

CaseQuery.IColumnFilterQuery

Enclosing class:

CaseQuery

public static interface CaseQuery.IDateColumnFilterQuery
extends CaseQuery.IColumnFilterQuery

Provides filter functionality for a date column of ICase

API:

This is a public API.

Method Summary

Modifier and Type	Method	Description
CaseQuery.FilterLink	isEqual(Date value)	Adds a filter condition that selects rows with the given value.
CaseQuery.FilterLink	isGreaterOrEqualThan(Date value)	Adds a filter condition that selects rows that have values that are greater or equal than the given value.
CaseQuery.FilterLink	isGreaterThan(Date value)	Adds a filter condition that selects rows that have values that are greater than the given value.
CaseQuery.FilterLink	isLowerOrEqualThan(Date value)	Adds a filter condition that selects rows that have values that are lower or equal than the given value.
CaseQuery.FilterLink	isLowerThan(Date value)	Adds a filter condition that selects rows that have values that are lower than the given value.
CaseQuery.FilterLink	isNotEqual(Date value)	Adds a filter condition that selects rows that do not have the given value.

Methods inherited from interface ch.ivyteam.ivy.workflow.query.CaseQuery.IColumnFilterQuery

isNotNull, isNull

Method Detail

isEqual

CaseQuery.FilterLink isEqual(Date value)

Adds a filter condition that selects rows with the given value.

SQL part: [column] = [value] or [column] IS NULL

Parameters:

value -

Returns:

query for further composition

API:

This public API is available in IvyScript and Java. It has the visibility EXPERT.

isNotEqual

CaseQuery.FilterLink isNotEqual(Date value)

Adds a filter condition that selects rows that do not have the given value.

SQL part: [column] <> [value] or [column] IS NOT NULL

Parameters:

value -

Returns:

query for further composition

API:

This public API is available in IvyScript and Java. It has the visibility EXPERT.

isGreaterThan

CaseQuery.FilterLink isGreaterThan(Date value)

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

SQL part: [column] > [value]

Parameters:

value -

Returns:

query for further composition

Throws:

IllegalArgumentException - If the given value is null

API:

This public API is available in IvyScript and Java. It has the visibility EXPERT.

isGreaterOrEqualThan

CaseQuery.FilterLink isGreaterOrEqualThan(Date value)

Adds a filter condition that selects rows that have values that are greater or equal than the given value.

SQL part: [column] >= [value]

Parameters:

value -

Returns:

query for further composition

Throws:

IllegalArgumentException - If the given value is null

API:

This public API is available in IvyScript and Java. It has the visibility EXPERT.

isLowerThan

CaseQuery.FilterLink isLowerThan(Date value)

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

SQL part: [column] < [value]

Parameters:

value -

Returns:

query for further composition

Throws:

IllegalArgumentException - If the given value is null

API:

This public API is available in IvyScript and Java. It has the visibility EXPERT.

isLowerOrEqualThan

CaseQuery.FilterLink isLowerOrEqualThan(Date value)

Adds a filter condition that selects rows that have values that are lower or equal than the given value.

SQL part: [column] <= [value]

Parameters:

value -

Returns:

query for further composition

Throws:

IllegalArgumentException - If the given value is null

API:

This public API is available in IvyScript and Java. It has the visibility EXPERT.