Restrictions on SQL Expressions

The following restrictions apply for the use of SQL expressions:

  • The following logical expressions are supported: and, or, not, in, defined, undefined, like.
  • The following operands are supported: eq, neq, leq, lt, geq, gt.
  • You have to use a where clause if you have a table where source is sql.
  • Multi-column results can only be used in select and slice actions. All other functions require a single column result (that is, a list of values).
  • Built-in functions such as concat, count, and so on cannot be used within an SQL expression.
  • In case of rulebase evaluation with relationship attribute values, the access modifiers on records based on relationship attribute are not applied on the record list. For example, if you try to hide some records from a record list based on their relationship attribute value for a particular relationship, the records are not hidden.
  • The multi-value attribute can only be used in where clause and not supported in a select column list.
  • Only supported operators for multi-value are eq, neq, in and like.