Package ch.ivyteam.ivy.workflow.query

Class StartSignalEventElementQuery.FilterLink

java.lang.Object

ch.ivyteam.ivy.persistence.query.Query<IStartSignalEventElement>

ch.ivyteam.ivy.workflow.query.StartSignalEventElementQuery

ch.ivyteam.ivy.workflow.query.StartSignalEventElementQuery.FilterLink

All Implemented Interfaces:

StartSignalEventElementQuery.IFilterLink

Direct Known Subclasses:

StartSignalEventElementQuery.FilterQuery

Enclosing class:

StartSignalEventElementQuery

public static class StartSignalEventElementQuery.FilterLink
extends StartSignalEventElementQuery
implements StartSignalEventElementQuery.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.StartSignalEventElementQuery

StartSignalEventElementQuery.AggregationQuery, StartSignalEventElementQuery.FilterLink, StartSignalEventElementQuery.FilterQuery, StartSignalEventElementQuery.GroupByQuery, StartSignalEventElementQuery.IAggregationQuery, StartSignalEventElementQuery.IBooleanColumnFilterQuery, StartSignalEventElementQuery.IColumnFilterQuery, StartSignalEventElementQuery.IFilterableColumns, StartSignalEventElementQuery.IFilterLink, StartSignalEventElementQuery.IFilterQuery, StartSignalEventElementQuery.IGroupByQueryColumns, StartSignalEventElementQuery.IIntegerColumnFilterQuery, StartSignalEventElementQuery.INumberColumnFilterQuery, StartSignalEventElementQuery.IOrderByQueryColumns, StartSignalEventElementQuery.IPatternColumnFilterQuery, StartSignalEventElementQuery.IStringColumnFilterQuery, StartSignalEventElementQuery.OrderByColumnQuery, StartSignalEventElementQuery.OrderByQuery

Method Summary

Modifier and Type	Method	Description
StartSignalEventElementQuery.FilterQuery	and()	Adds an AND statement to the where condition.
StartSignalEventElementQuery.FilterLink	and(StartSignalEventElementQuery subQuery)	Adds and AND statement with the given filter subQuery.
StartSignalEventElementQuery.FilterQuery	andOverall()	Adds an AND statement to the whole where condition configured before.
StartSignalEventElementQuery.FilterLink	andOverall(StartSignalEventElementQuery subQuery)	Adds and AND statement with the given filter subQuery to the whole where condition configured before.
StartSignalEventElementQuery.FilterQuery	or()	Adds an OR statement to the where condition.
StartSignalEventElementQuery.FilterLink	or(StartSignalEventElementQuery subQuery)	Adds and OR statement with the given filter subQuery. Only the where condition of the given subQuery is considered.

Methods inherited from class ch.ivyteam.ivy.workflow.query.StartSignalEventElementQuery

aggregate, create, executor, groupBy, orderBy, where

Method Detail

and

public StartSignalEventElementQuery.FilterQuery and()

Description copied from interface: StartSignalEventElementQuery.IFilterLink

Adds an AND statement to the where condition.
Must be followed by other query conditions.

Note that and operations are always evaluated before or operations, e.g. the expression A OR B AND C is evaluated to A OR (B AND C). If you need to get (A OR B) AND C, then use the andOverall method.

Example A OR (B AND C):

StartSignalEventElementQuery.create().description().isEqual("A").or().description().isEqual("B")
  .and().name().isEqual("C");

SQL part: AND

Specified by:

and in interface StartSignalEventElementQuery.IFilterLink

Returns:

query for further composition

See Also:

StartSignalEventElementQuery.IFilterLink.and()

API:

This public API is available in IvyScript and Java. It has the visibility EXPERT.

and

public StartSignalEventElementQuery.FilterLink and(StartSignalEventElementQuery subQuery)

Description copied from interface: StartSignalEventElementQuery.IFilterLink

Adds and AND statement with the given filter subQuery. Only the where condition of the given subQuery is considered. All other parts are ignored. The whole where condition of the given filter subQuery is and-ed to the query as one term with brackets around it.

Note that and operations are always evaluated before or operations, e.g. the expression A OR B AND (subQuery) is evaluated to A OR (B AND (subQuery)). If you need to get (A OR B) AND (subQuery), then use the andOverall method.

Example A AND (B OR C):

StartSignalEventElementQuery.create().description().isEqual("A")
  .and(StartSignalEventElementQuery.create().name().isEqual("B").or().name().isEqual("C"));

SQL part: AND([subQueryWhereClause])

Specified by:

and in interface StartSignalEventElementQuery.IFilterLink

Parameters:

subQuery - query with a set of where conditions.

Returns:

query for further composition

See Also:

StartSignalEventElementQuery.IFilterLink.and(StartSignalEventElementQuery)

API:

This public API is available in IvyScript and Java. It has the visibility EXPERT.

andOverall

public StartSignalEventElementQuery.FilterQuery andOverall()

Description copied from interface: StartSignalEventElementQuery.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:

StartSignalEventElementQuery.create().description().isEqual("A").or().description().isEqual("B")
  .andOverall().name().isEqual("C");

Specified by:

andOverall in interface StartSignalEventElementQuery.IFilterLink

Returns:

query for further composition

See Also:

StartSignalEventElementQuery.IFilterLink.andOverall()

API:

This public API is available in IvyScript and Java. It has the visibility EXPERT.

andOverall

public StartSignalEventElementQuery.FilterLink andOverall(StartSignalEventElementQuery subQuery)

Description copied from interface: StartSignalEventElementQuery.IFilterLink

Adds and AND statement with the given filter subQuery to the whole where condition configured before. Only the where condition of the given subQuery is considered. All other parts are ignored. The whole where condition of the given filter subQuery is and-ed to the query as one term with brackets around it.

Example (A OR B) AND (C OR D):

StartSignalEventElementQuery.create().description().isEqual("A").or().description().isEqual("B")
  .andOverall(StartSignalEventElementQuery.create().name().isEqual("C").or().name().isEqual("D"));

SQL part: AND([subQueryWhereClause])

Specified by:

andOverall in interface StartSignalEventElementQuery.IFilterLink

Parameters:

subQuery - query with a set of where conditions.

Returns:

query for further composition

See Also:

StartSignalEventElementQuery.IFilterLink.andOverall(StartSignalEventElementQuery)

API:

This public API is available in IvyScript and Java. It has the visibility EXPERT.

or

public StartSignalEventElementQuery.FilterQuery or()

Description copied from interface: StartSignalEventElementQuery.IFilterLink

Adds an OR statement to the where condition.
Must be followed by other query conditions.

Note that and operations are evaluated before or operations. E.g. the expression A and B or C is evaluated like (A and B) or C

SQL part: OR

Specified by:

or in interface StartSignalEventElementQuery.IFilterLink

Returns:

query for further composition

See Also:

StartSignalEventElementQuery.IFilterLink.or()

API:

This public API is available in IvyScript and Java. It has the visibility EXPERT.

or

public StartSignalEventElementQuery.FilterLink or(StartSignalEventElementQuery subQuery)

Description copied from interface: StartSignalEventElementQuery.IFilterLink

Adds and OR statement with the given filter subQuery.
Only the where condition of the given subQuery is considered. All other parts are ignored. The whole where condition of the given filter subQuery is or-ed to the query as one term with brackets around it.

Note that and operations are always evaluated before or operations, e.g. the expression A AND B OR C is evaluated to (A AND B) OR C. If you need to get A AND (B OR C), then use this method to add a sub query (B OR C) with a AND operation to the current query (A).

SQL part: OR([subQueryWhereClause])

Specified by:

or in interface StartSignalEventElementQuery.IFilterLink

Parameters:

subQuery - query with a set of where conditions.

Returns:

query for further composition

See Also:

StartSignalEventElementQuery.IFilterLink.or(StartSignalEventElementQuery)

API:

This public API is available in IvyScript and Java. It has the visibility EXPERT.