Field References

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 id attributes defined 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_id.field_name

Within a join expression, tables are given alias names that must be used.

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 Label entered with double quotes ("). Item labels are created on the Data Presentation 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.