DomEL expressions are stored in the Domain design and interpreted when the server prepares to run a query to retrieve data from the data source. Therefore, all references to field values in an expression are based on the IDs given in the Domain design. Field references have the following format, depending on where the expression appears:
Appears In | Field Reference | Explanation |
Derived table | table_ID.field_name | The SQL query that defines a derived table can refer to any previously defined table or derived table in the Domain. Therefore, you must include the table ID. |
Join expression | table_alias.field_name | Within a join expression, tables are given alias names that must be used. Even though join expressions may appear in separate joinedDatasetRef elements, the alias declared in each one can be used in any subsequent one. |
Calculated field on a table or derived table | field_name | Calculated fields can only appear on a table if they refer exclusively to fields of the table, in which case no table ID is needed. However, the table ID is not forbidden, and the Domain Designer sometimes includes it. |
Calculated field on a join tree | table_ID.field_name | Calculated fields declared in join trees refer to fields prefixed with their table ID. |
Filter on a table or derived table | field_name | Filters that are evaluated within the table or derived table do not need the table ID. |
Filter on a join tree | table_ID.field_name | Filters that refer to fields in separate tables of the join tree need to use the table ID on each field name. |
Calculated field in an Ad Hoc view | "Field Label" | Calculated fields declared in Ad Hoc views can refer to fields using their Item Labels entered with double quotes ("). Item Labels are created on the Display tab of the Domain Designer. |
table_ID.field_name | Calculated fields declared in Ad Hoc views can refer to fields prefixed with their table ID. |
Recommended Comments
There are no comments to display.