Class UserQuery.FilterLink
- java.lang.Object
-
- ch.ivyteam.ivy.persistence.query.Query<IUser>
-
- ch.ivyteam.ivy.security.query.UserQuery
-
- ch.ivyteam.ivy.security.query.UserQuery.FilterLink
-
- All Implemented Interfaces:
UserQuery.IFilterLink
- Direct Known Subclasses:
UserQuery.FilterQuery
- Enclosing class:
- UserQuery
public static class UserQuery.FilterLink extends UserQuery implements UserQuery.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.security.query.UserQuery
UserQuery.FilterLink, UserQuery.FilterQuery, UserQuery.GroupByQuery, UserQuery.IColumnFilterQuery, UserQuery.IFilterableColumns, UserQuery.IFilterLink, UserQuery.IFilterQuery, UserQuery.IGroupByQueryColumns, UserQuery.IIntegerColumnFilterQuery, UserQuery.INumberColumnFilterQuery, UserQuery.IOrderByQueryColumns, UserQuery.IPatternColumnFilterQuery, UserQuery.IStringColumnFilterQuery, UserQuery.OrderByColumnQuery, UserQuery.OrderByQuery
-
-
Method Summary
All Methods Instance Methods Concrete Methods Modifier and Type Method Description UserQuery.FilterQuery
and()
Adds an AND statement to thewhere
condition.UserQuery.FilterLink
and(UserQuery subQuery)
Adds and AND statement with the given filtersubQuery
.UserQuery.FilterQuery
andOverall()
Adds an AND statement to the wholewhere
condition configured before.UserQuery.FilterLink
andOverall(UserQuery subQuery)
Adds and AND statement with the given filtersubQuery
to the wholewhere
condition configured before.UserQuery.FilterQuery
or()
Adds an OR statement to thewhere
condition.UserQuery.FilterLink
or(UserQuery subQuery)
Adds and OR statement with the given filtersubQuery
.
Only thewhere
condition of the givensubQuery
is considered.
-
-
-
Method Detail
-
and
public UserQuery.FilterQuery and()
Description copied from interface:UserQuery.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)
:UserQuery.create().description().isEqual("A").or().description().isEqual("B") .and().name().isEqual("C");
SQL part:
AND
- Specified by:
and
in interfaceUserQuery.IFilterLink
- Returns:
- query for further composition
- See Also:
UserQuery.IFilterLink.and()
- API:
- This public API is available in IvyScript and Java. It has the visibility EXPERT.
-
and
public UserQuery.FilterLink and(UserQuery subQuery)
Description copied from interface:UserQuery.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)
:UserQuery.create().description().isEqual("A") .and(UserQuery.create().name().isEqual("B").or().name().isEqual("C"));
SQL part:
AND([subQueryWhereClause])
- Specified by:
and
in interfaceUserQuery.IFilterLink
- Parameters:
subQuery
- query with a set of where conditions.- Returns:
- query for further composition
- See Also:
UserQuery.IFilterLink.and(UserQuery)
- API:
- This public API is available in IvyScript and Java. It has the visibility EXPERT.
-
andOverall
public UserQuery.FilterQuery andOverall()
Description copied from interface:UserQuery.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
:UserQuery.create().description().isEqual("A").or().description().isEqual("B") .andOverall().name().isEqual("C");
- Specified by:
andOverall
in interfaceUserQuery.IFilterLink
- Returns:
- query for further composition
- See Also:
UserQuery.IFilterLink.andOverall()
- API:
- This public API is available in IvyScript and Java. It has the visibility EXPERT.
-
andOverall
public UserQuery.FilterLink andOverall(UserQuery subQuery)
Description copied from interface:UserQuery.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):
UserQuery.create().description().isEqual("A").or().description().isEqual("B") .andOverall(UserQuery.create().name().isEqual("C").or().name().isEqual("D"));
SQL part:
AND([subQueryWhereClause])
- Specified by:
andOverall
in interfaceUserQuery.IFilterLink
- Parameters:
subQuery
- query with a set of where conditions.- Returns:
- query for further composition
- See Also:
UserQuery.IFilterLink.andOverall(UserQuery)
- API:
- This public API is available in IvyScript and Java. It has the visibility EXPERT.
-
or
public UserQuery.FilterQuery or()
Description copied from interface:UserQuery.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 interfaceUserQuery.IFilterLink
- Returns:
- query for further composition
- See Also:
UserQuery.IFilterLink.or()
- API:
- This public API is available in IvyScript and Java. It has the visibility EXPERT.
-
or
public UserQuery.FilterLink or(UserQuery subQuery)
Description copied from interface:UserQuery.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 interfaceUserQuery.IFilterLink
- Parameters:
subQuery
- query with a set of where conditions.- Returns:
- query for further composition
- See Also:
UserQuery.IFilterLink.or(UserQuery)
- API:
- This public API is available in IvyScript and Java. It has the visibility EXPERT.
-
-