Package ch.ivyteam.ivy.workflow.query

Interface TaskQuery.INumberColumnFilterQuery

All Superinterfaces:

TaskQuery.IColumnFilterQuery, TaskQuery.IPatternColumnFilterQuery

Enclosing class:

TaskQuery

public static interface TaskQuery.INumberColumnFilterQuery
extends TaskQuery.IPatternColumnFilterQuery

Provides filter functionality for a decimal number column of ITask

API:

This is a public API.

Method Summary

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

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

isNotNull, isNull

Methods inherited from interface ch.ivyteam.ivy.workflow.query.TaskQuery.IPatternColumnFilterQuery

isLike, isLikeIgnoreCase, isNotLike, isNotLikeIgnoreCase

Method Detail

isEqual

TaskQuery.FilterLink isEqual(Number 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

TaskQuery.FilterLink isNotEqual(Number 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

TaskQuery.FilterLink isGreaterThan(Number 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

TaskQuery.FilterLink isGreaterOrEqualThan(Number 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

TaskQuery.FilterLink isLowerThan(Number 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

TaskQuery.FilterLink isLowerOrEqualThan(Number 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.