Red Hat Training

A Red Hat training course is available for Red Hat JBoss Data Virtualization

B.3. Condition

A criteria is a combination of expressions and operators that evaluates to true, false, or unknown. Criteria are most commonly used in the WHERE or HAVING clauses.
  • Condition - the base criteria interface
  • Not - used to NOT another criteria
  • AndOr - used to combine other criteria via AND or OR
  • SubqueryComparison - represents a comparison criteria with a subquery including a quantifier such as SOME or ALL
  • Comparison - represents a comparison criteria with =, >, <, etc.
  • BaseInCondition - base class for an IN criteria
  • In - represents an IN criteria that has a set of expressions for values
  • SubqueryIn - represents an IN criteria that uses a subquery to produce the value set
  • IsNull - represents an IS NULL criteria
  • Exists represents an EXISTS criteria that determines whether a subquery will return any values
  • Like - represents a LIKE/SIMILAR TO/LIKE_REGEX criteria that compares string values