Class TaskQuery.FilterLink
- java.lang.Object
-
- ch.ivyteam.ivy.persistence.query.Query<ITask>
-
- ch.ivyteam.ivy.workflow.query.TaskQuery
-
- ch.ivyteam.ivy.workflow.query.TaskQuery.FilterLink
-
- All Implemented Interfaces:
TaskQuery.IFilterLink
- Direct Known Subclasses:
TaskQuery.FilterQuery
- Enclosing class:
- TaskQuery
public static class TaskQuery.FilterLink extends TaskQuery implements TaskQuery.IFilterLink
Links a where condition with another.- API:
- This is a public API.
-
-
Nested Class Summary
-
Nested classes/interfaces inherited from class ch.ivyteam.ivy.workflow.query.TaskQuery
TaskQuery.AggregationQuery, TaskQuery.FilterLink, TaskQuery.FilterQuery, TaskQuery.GroupByQuery, TaskQuery.IAggregationQuery, TaskQuery.IBooleanColumnFilterQuery, TaskQuery.IClobColumnFilterQuery, TaskQuery.IColumnFilterQuery, TaskQuery.ICustomFieldAggregationQuery, TaskQuery.ICustomFieldFilterQuery, TaskQuery.ICustomFieldGroupBy, TaskQuery.ICustomFieldOrderBy, TaskQuery.IDateColumnFilterQuery, TaskQuery.IFilterableColumns, TaskQuery.IFilterLink, TaskQuery.IFilterQuery, TaskQuery.IGroupByQueryColumns, TaskQuery.IIntegerColumnFilterQuery, TaskQuery.INumberColumnFilterQuery, TaskQuery.IOrderByQueryColumns, TaskQuery.IPatternColumnFilterQuery, TaskQuery.IStringColumnFilterQuery, TaskQuery.ITaskStateFilterQuery, TaskQuery.IWorkflowPriorityFilterQuery, TaskQuery.OrderByColumnQuery, TaskQuery.OrderByQuery
-
-
Method Summary
All Methods Instance Methods Concrete Methods Modifier and Type Method Description TaskQuery.FilterQuery
and()
Adds an AND statement to thewhere
condition.TaskQuery.FilterLink
and(TaskQuery subQuery)
Adds and AND statement with the given filtersubQuery
.TaskQuery.FilterQuery
andOverall()
Adds an AND statement to the wholewhere
condition configured before.TaskQuery.FilterLink
andOverall(TaskQuery subQuery)
Adds and AND statement with the given filtersubQuery
to the wholewhere
condition configured before.TaskQuery.FilterQuery
or()
Adds an OR statement to thewhere
condition.TaskQuery.FilterLink
or(TaskQuery subQuery)
Adds and OR statement with the given filtersubQuery
.
Only thewhere
condition of the givensubQuery
is considered.
-
-
-
Method Detail
-
and
public TaskQuery.FilterQuery and()
Description copied from interface:TaskQuery.IFilterLink
Adds an AND statement to the
where
condition.
Must be followed by other query conditions.Note that
and
operations are always evaluated beforeor
operations, e.g. the expressionA OR B AND C
is evaluated toA OR (B AND C)
. If you need to get(A OR B) AND C
, then use theandOverall
method.Example
A OR (B AND C)
:TaskQuery.create().description().isEqual("A").or().description().isEqual("B") .and().name().isEqual("C");
SQL part:
AND
- Specified by:
and
in interfaceTaskQuery.IFilterLink
- Returns:
- query for further composition
- See Also:
TaskQuery.IFilterLink.and()
- API:
- This public API is available in IvyScript and Java. It has the visibility EXPERT.
-
and
public TaskQuery.FilterLink and(TaskQuery subQuery)
Description copied from interface:TaskQuery.IFilterLink
Adds and AND statement with the given filter
subQuery
. Only thewhere
condition of the givensubQuery
is considered. All other parts are ignored. The wholewhere
condition of the given filtersubQuery
is and-ed to the query as one term with brackets around it.Note that
and
operations are always evaluated beforeor
operations, e.g. the expressionA OR B AND (subQuery)
is evaluated toA OR (B AND (subQuery))
. If you need to get(A OR B) AND (subQuery)
, then use theandOverall
method.Example
A AND (B OR C)
:TaskQuery.create().description().isEqual("A") .and(TaskQuery.create().name().isEqual("B").or().name().isEqual("C"));
SQL part:
AND([subQueryWhereClause])
- Specified by:
and
in interfaceTaskQuery.IFilterLink
- Parameters:
subQuery
- query with a set of where conditions.- Returns:
- query for further composition
- See Also:
TaskQuery.IFilterLink.and(TaskQuery)
- API:
- This public API is available in IvyScript and Java. It has the visibility EXPERT.
-
andOverall
public TaskQuery.FilterQuery andOverall()
Description copied from interface:TaskQuery.IFilterLink
Adds an AND statement to the whole
where
condition configured before.
Must be followed by other query conditions.Example
(A OR B) AND C
:TaskQuery.create().description().isEqual("A").or().description().isEqual("B") .andOverall().name().isEqual("C");
- Specified by:
andOverall
in interfaceTaskQuery.IFilterLink
- Returns:
- query for further composition
- See Also:
TaskQuery.IFilterLink.andOverall()
- API:
- This public API is available in IvyScript and Java. It has the visibility EXPERT.
-
andOverall
public TaskQuery.FilterLink andOverall(TaskQuery subQuery)
Description copied from interface:TaskQuery.IFilterLink
Adds and AND statement with the given filter
subQuery
to the wholewhere
condition configured before. Only thewhere
condition of the givensubQuery
is considered. All other parts are ignored. The wholewhere
condition of the given filtersubQuery
is and-ed to the query as one term with brackets around it.Example (A OR B) AND (C OR D):
TaskQuery.create().description().isEqual("A").or().description().isEqual("B") .andOverall(TaskQuery.create().name().isEqual("C").or().name().isEqual("D"));
SQL part:
AND([subQueryWhereClause])
- Specified by:
andOverall
in interfaceTaskQuery.IFilterLink
- Parameters:
subQuery
- query with a set of where conditions.- Returns:
- query for further composition
- See Also:
TaskQuery.IFilterLink.andOverall(TaskQuery)
- API:
- This public API is available in IvyScript and Java. It has the visibility EXPERT.
-
or
public TaskQuery.FilterQuery or()
Description copied from interface:TaskQuery.IFilterLink
Adds an OR statement to the
where
condition.
Must be followed by other query conditions.Note that
and
operations are evaluated beforeor
operations. E.g. the expressionA and B or C
is evaluated like(A and B) or C
SQL part:
OR
- Specified by:
or
in interfaceTaskQuery.IFilterLink
- Returns:
- query for further composition
- See Also:
TaskQuery.IFilterLink.or()
- API:
- This public API is available in IvyScript and Java. It has the visibility EXPERT.
-
or
public TaskQuery.FilterLink or(TaskQuery subQuery)
Description copied from interface:TaskQuery.IFilterLink
Adds and OR statement with the given filter
subQuery
.
Only thewhere
condition of the givensubQuery
is considered. All other parts are ignored. The wholewhere
condition of the given filtersubQuery
is or-ed to the query as one term with brackets around it.Note that
and
operations are always evaluated beforeor
operations, e.g. the expressionA AND B OR C
is evaluated to(A AND B) OR C
. If you need to getA AND (B OR C)
, then use this method to add a sub query (B OR C
) with aAND
operation to the current query (A).SQL part:
OR([subQueryWhereClause])
- Specified by:
or
in interfaceTaskQuery.IFilterLink
- Parameters:
subQuery
- query with a set of where conditions.- Returns:
- query for further composition
- See Also:
TaskQuery.IFilterLink.or(TaskQuery)
- API:
- This public API is available in IvyScript and Java. It has the visibility EXPERT.
-
-