Class CaseQuery.FilterLink
- All Implemented Interfaces:
CaseQuery.IFilterLink
- Direct Known Subclasses:
CaseQuery.FilterQuery
- Enclosing class:
- CaseQuery
- API:
- This is a public API.
-
Nested Class Summary
Nested classes/interfaces inherited from class ch.ivyteam.ivy.workflow.query.CaseQuery
CaseQuery.AggregationQuery, CaseQuery.FilterLink, CaseQuery.FilterQuery, CaseQuery.GroupByQuery, CaseQuery.IAggregationQuery, CaseQuery.IBoolFilterQuery, CaseQuery.ICaseBusinessStateFilterQuery, CaseQuery.ICaseStateFilterQuery, CaseQuery.IClobColumnFilterQuery, CaseQuery.IColumnFilterQuery, CaseQuery.ICustomFieldAggregationQuery, CaseQuery.ICustomFieldFilterQuery, CaseQuery.ICustomFieldGroupBy, CaseQuery.ICustomFieldOrderBy, CaseQuery.IDateColumnFilterQuery, CaseQuery.IFilterableColumns, CaseQuery.IFilterLink, CaseQuery.IFilterQuery, CaseQuery.IGroupByQueryColumns, CaseQuery.IIntegerColumnFilterQuery, CaseQuery.INumberColumnFilterQuery, CaseQuery.IOrderByQueryColumns, CaseQuery.IPatternColumnFilterQuery, CaseQuery.IStringColumnFilterQuery, CaseQuery.IUUIDColumnFilterQuery, CaseQuery.IWorkflowPriorityFilterQuery, CaseQuery.OrderByColumnQuery, CaseQuery.OrderByQuery
-
Method Summary
Modifier and TypeMethodDescriptionand()
Adds an AND statement to thewhere
condition.Adds and AND statement with the given filtersubQuery
.Adds an AND statement to the wholewhere
condition configured before.andOverall
(CaseQuery subQuery) Adds and AND statement with the given filtersubQuery
to the wholewhere
condition configured before.or()
Adds an OR statement to thewhere
condition.Adds and OR statement with the given filtersubQuery
.
Only thewhere
condition of the givensubQuery
is considered.
-
Method Details
-
and
Description copied from interface:CaseQuery.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)
:CaseQuery.businessCases().description().isEqual("A").or().description().isEqual("B") .and().name().isEqual("C");
SQL part:
AND
- Specified by:
and
in interfaceCaseQuery.IFilterLink
- Returns:
- query for further composition
- See Also:
- API:
- This public API is available in Java.
-
and
Description copied from interface:CaseQuery.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)
:CaseQuery.businessCases().description().isEqual("A") .and(CaseQuery.businessCases().name().isEqual("B").or().name().isEqual("C"));
SQL part:
AND([subQueryWhereClause])
- Specified by:
and
in interfaceCaseQuery.IFilterLink
- Parameters:
subQuery
- query with a set of where conditions.- Returns:
- query for further composition
- See Also:
- API:
- This public API is available in Java.
-
andOverall
Description copied from interface:CaseQuery.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
:CaseQuery.businessCases().description().isEqual("A").or().description().isEqual("B") .andOverall().name().isEqual("C");
- Specified by:
andOverall
in interfaceCaseQuery.IFilterLink
- Returns:
- query for further composition
- See Also:
- API:
- This public API is available in Java.
-
andOverall
Description copied from interface:CaseQuery.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):
CaseQuery.businessCases().description().isEqual("A").or().description().isEqual("B") .andOverall(CaseQuery.businessCases().name().isEqual("C").or().name().isEqual("D"));
SQL part:
AND([subQueryWhereClause])
- Specified by:
andOverall
in interfaceCaseQuery.IFilterLink
- Parameters:
subQuery
- query with a set of where conditions.- Returns:
- query for further composition
- See Also:
- API:
- This public API is available in Java.
-
or
Description copied from interface:CaseQuery.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 interfaceCaseQuery.IFilterLink
- Returns:
- query for further composition
- API:
- This public API is available in Java.
-
or
Description copied from interface:CaseQuery.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 interfaceCaseQuery.IFilterLink
- Parameters:
subQuery
- query with a set of where conditions.- Returns:
- query for further composition
- API:
- This public API is available in Java.
-