Div | ||
---|---|---|
| ||
DomEL expressions are used in different contexts for different purposes. The expected return type depends on where the expression appears:
Appears In | Expected Return Type | Explanation |
---|---|---|
Derived Table | SQL query with boolean expressions | A derived table is defined by an SQL expression that contains DomEL expressions. |
Join expression | boolean | Within a join expression, the on clause contains a comparison of fields from each table that has a boolean result. |
Calculated field | any type | The expression must evaluate to a type that is compatible with the SQL type declared in the Domain Designer or in the design file. |
Filter | boolean | Filters must be true or false overall. When there are several conditions, they must be logically associated with "and" or "or" (currently, only and is supported in the Domain Designer). |