Package ch.ivyteam.ivy.workflow.query

Interface TaskQuery.IIntegerColumnFilterQuery

All Superinterfaces:

TaskQuery.IColumnFilterQuery, TaskQuery.IPatternColumnFilterQuery

Enclosing class:

TaskQuery

public static interface TaskQuery.IIntegerColumnFilterQuery
extends TaskQuery.IPatternColumnFilterQuery

Provides filter functionality for an integer column of ITask

API:

This is a public API.

Method Summary

Modifier and Type	Method	Description
TaskQuery.FilterLink	isEqual(int value)	Adds a filter condition that selects rows with the given value.
TaskQuery.FilterLink	isEqual(long value)	Adds a filter condition that selects rows with the given value.
TaskQuery.FilterLink	isGreaterOrEqualThan(int value)	Adds a filter condition that selects rows that have values that are greater or equal than the given value.
TaskQuery.FilterLink	isGreaterOrEqualThan(long value)	Adds a filter condition that selects rows that have values that are greater or equal than the given value.
TaskQuery.FilterLink	isGreaterThan(int value)	Adds a filter condition that selects rows that have values that are greater than the given value.
TaskQuery.FilterLink	isGreaterThan(long value)	Adds a filter condition that selects rows that have values that are greater than the given value.
TaskQuery.FilterLink	isIn(long... values)	Adds a filter condition that selects rows that have values that are in the given list of values.
TaskQuery.FilterLink	isIn(List<Long> values)	Adds a filter condition that selects rows that have values that are in the given list of values.
TaskQuery.FilterLink	isLowerOrEqualThan(int value)	Adds a filter condition that selects rows that have values that are lower or equal than the given value.
TaskQuery.FilterLink	isLowerOrEqualThan(long value)	Adds a filter condition that selects rows that have values that are lower or equal than the given value.
TaskQuery.FilterLink	isLowerThan(int value)	Adds a filter condition that selects rows that have values that are lower than the given value.
TaskQuery.FilterLink	isLowerThan(long value)	Adds a filter condition that selects rows that have values that are lower than the given value.
TaskQuery.FilterLink	isNotEqual(int value)	Adds a filter condition that selects rows that do not have the given value.
TaskQuery.FilterLink	isNotEqual(long value)	Adds a filter condition that selects rows that do not have the given value.
TaskQuery.FilterLink	isNotIn(long... values)	Adds a filter condition that selects rows that have values that are not in the given list of values.
TaskQuery.FilterLink	isNotIn(List<Long> values)	Adds a filter condition that selects rows that have values that are not in the given list of values.

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 Details

isEqual

TaskQuery.FilterLink isEqual(int value)

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

SQL part: [column] = [value]

Parameters:

value -

Returns:

query for further composition

API:

This public API is available in Java.

isEqual

TaskQuery.FilterLink isEqual(long value)

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

SQL part: [column] = [value]

Parameters:

value -

Returns:

query for further composition

API:

This public API is available in Java.

isNotEqual

TaskQuery.FilterLink isNotEqual(int value)

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

SQL part: [column] <> [value]

Parameters:

value -

Returns:

query for further composition

API:

This public API is available in Java.

isNotEqual

TaskQuery.FilterLink isNotEqual(long value)

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

SQL part: [column] <> [value]

Parameters:

value -

Returns:

query for further composition

API:

This public API is available in Java.

isGreaterThan

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

API:

This public API is available in Java.

isGreaterThan

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

API:

This public API is available in Java.

isGreaterOrEqualThan

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

API:

This public API is available in Java.

isGreaterOrEqualThan

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

API:

This public API is available in Java.

isLowerThan

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

API:

This public API is available in Java.

isLowerThan

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

API:

This public API is available in Java.

isLowerOrEqualThan

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

API:

This public API is available in Java.

isLowerOrEqualThan

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

API:

This public API is available in Java.

isIn

TaskQuery.FilterLink isIn(long... values)

Adds a filter condition that selects rows that have values that are in the given list of values.

SQL part: [column] IN ([values])

Parameters:

values -

Returns:

query for further composition

Since:

11.1

API:

This public API is available in Java.

isIn

TaskQuery.FilterLink isIn(List<Long> values)

Adds a filter condition that selects rows that have values that are in the given list of values.

SQL part: [column] IN ([values])

Parameters:

values -

Returns:

query for further composition

Since:

11.1

API:

This public API is available in Java.

isNotIn

TaskQuery.FilterLink isNotIn(long... values)

Adds a filter condition that selects rows that have values that are not in the given list of values.

SQL part: [column] NOT IN ([values])

Parameters:

values -

Returns:

query for further composition

Since:

12.0

API:

This public API is available in Java.

isNotIn

TaskQuery.FilterLink isNotIn(List<Long> values)

Adds a filter condition that selects rows that have values that are not in the given list of values.

SQL part: [column] NOT IN ([values])

Parameters:

values -

Returns:

query for further composition

Since:

12.0

API:

This public API is available in Java.