Derived Table | SQL query with boolean expressions | A derived table is defined by an SQL expression that contains DomEL expressions.
The join on clause may contain boolean comparisons and the where clause may contain filters, both of which are described below. |
Join expression | boolean | Within a join expression, the on clause contains a comparison of fields from each table that has a boolean result.
The on clause may also contain other DomEL expressions logically associated with and or to create a complex join condition. |
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.
For example, if the declared type is java.lang.Float,the expression must compute a decimal value. |
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). |