Related Topics

Datatypes

SQL Functions

Operators and Functions

Profile Attributes

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.