Package ch.ivyteam.ivy.workflow.query

Class CaseQuery.FilterLink

java.lang.Object
ch.ivyteam.ivy.persistence.query.Query<ICase>
ch.ivyteam.ivy.workflow.query.CaseQuery
ch.ivyteam.ivy.workflow.query.CaseQuery.FilterLink
All Implemented Interfaces:
CaseQuery.IFilterLink
Direct Known Subclasses:
CaseQuery.FilterQuery
Enclosing class:
CaseQuery
public static class CaseQuery.FilterLink extends CaseQuery implements CaseQuery.IFilterLink
API:
This is a public API.

  • Method Details

    • and

      public CaseQuery.FilterQuery 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 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): 

      CaseQuery.businessCases().description().isEqual("A").or().description().isEqual("B")
  .and().name().isEqual("C");

      SQL part: AND

      Specified by:
      and in interface CaseQuery.IFilterLink
      Returns:
      query for further composition
      See Also:
      API:
      This public API is available in IvyScript and Java. It has the visibility EXPERT.

    • and

      public CaseQuery.FilterLink and(CaseQuery subQuery)
      Description copied from interface: CaseQuery.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): 

      CaseQuery.businessCases().description().isEqual("A")
  .and(CaseQuery.businessCases().name().isEqual("B").or().name().isEqual("C"));

      SQL part: AND([subQueryWhereClause])

      Specified by:
      and in interface CaseQuery.IFilterLink
      Parameters:
      subQuery - query with a set of where conditions.
      Returns:
      query for further composition
      See Also:
      API:
      This public API is available in IvyScript and Java. It has the visibility EXPERT.

    • andOverall

      public CaseQuery.FilterQuery 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 interface CaseQuery.IFilterLink
      Returns:
      query for further composition
      See Also:
      API:
      This public API is available in IvyScript and Java. It has the visibility EXPERT.

    • andOverall

      public CaseQuery.FilterLink andOverall(CaseQuery subQuery)
      Description copied from interface: CaseQuery.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): 

      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 interface CaseQuery.IFilterLink
      Parameters:
      subQuery - query with a set of where conditions.
      Returns:
      query for further composition
      See Also:
      API:
      This public API is available in IvyScript and Java. It has the visibility EXPERT.

    • or

      public CaseQuery.FilterQuery 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 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 CaseQuery.IFilterLink
      Returns:
      query for further composition
      API:
      This public API is available in IvyScript and Java. It has the visibility EXPERT.

    • or

      public CaseQuery.FilterLink or(CaseQuery subQuery)
      Description copied from interface: CaseQuery.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 CaseQuery.IFilterLink
      Parameters:
      subQuery - query with a set of where conditions.
      Returns:
      query for further composition
      API:
      This public API is available in IvyScript and Java. It has the visibility EXPERT.