Interface CaseQuery.IFilterLink
-
- All Known Subinterfaces:
CaseQuery.IFilterQuery
- All Known Implementing Classes:
CaseQuery.FilterLink
,CaseQuery.FilterQuery
- Enclosing class:
- CaseQuery
public static interface CaseQuery.IFilterLink
Links a where condition with another.- API:
- This is a public API.
-
-
Method Summary
All Methods Instance Methods Abstract Methods Modifier and Type Method Description CaseQuery.FilterQuery
and()
Adds an AND statement to thewhere
condition.CaseQuery.FilterLink
and(CaseQuery subQuery)
Adds and AND statement with the given filtersubQuery
.CaseQuery.FilterQuery
andOverall()
Adds an AND statement to the wholewhere
condition configured before.CaseQuery.FilterLink
andOverall(CaseQuery subQuery)
Adds and AND statement with the given filtersubQuery
to the wholewhere
condition configured before.CaseQuery.FilterQuery
or()
Adds an OR statement to thewhere
condition.CaseQuery.FilterLink
or(CaseQuery subQuery)
Adds and OR statement with the given filtersubQuery
.
Only thewhere
condition of the givensubQuery
is considered.
-
-
-
Method Detail
-
and
CaseQuery.FilterQuery and()
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
- Returns:
- query for further composition
- See Also:
andOverall()
- API:
- This public API is available in IvyScript and Java. It has the visibility EXPERT.
-
and
CaseQuery.FilterLink and(CaseQuery subQuery)
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])
- Parameters:
subQuery
- query with a set of where conditions.- Returns:
- query for further composition
- Throws:
IllegalArgumentException
- when the query parameter is the same instance or null.- See Also:
andOverall(CaseQuery)
- API:
- This public API is available in IvyScript and Java. It has the visibility EXPERT.
-
andOverall
CaseQuery.FilterQuery andOverall()
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");
- Returns:
- query for further composition
- See Also:
and()
- API:
- This public API is available in IvyScript and Java. It has the visibility EXPERT.
-
andOverall
CaseQuery.FilterLink andOverall(CaseQuery subQuery)
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])
- Parameters:
subQuery
- query with a set of where conditions.- Returns:
- query for further composition
- Throws:
IllegalArgumentException
- when the query parameter is the same instance or null.- See Also:
and(CaseQuery)
- API:
- This public API is available in IvyScript and Java. It has the visibility EXPERT.
-
or
CaseQuery.FilterQuery or()
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
- Returns:
- query for further composition
- API:
- This public API is available in IvyScript and Java. It has the visibility EXPERT.
-
or
CaseQuery.FilterLink or(CaseQuery subQuery)
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])
- Parameters:
subQuery
- query with a set of where conditions.- Returns:
- query for further composition
- Throws:
IllegalArgumentException
- when the query parameter is the same instance or null.- API:
- This public API is available in IvyScript and Java. It has the visibility EXPERT.
-
-