SQL Functions

DomEL is the primary language used inside the tags in the Domain design file. You can use SQL in the following situations:

• The query tag in the derived tables section of the Domain design file expects an SQL function.
• In addition, you may use SQL functions in a DomEL expression, but only in limited circumstances:
  • The functions must be supported by the database. See the vendor documentation for available functions and their syntax.
  • The functions must follow the convention of comma-separated parameters. For example, you can use "TRIM( person.name)," but not "TRIM('Jr' FROM person.name)".
  • The type of the return values must be appropriate, either within the expression or for the type of the calculated field.
  • The SQL context must be appropriate for the functions. For example, you cannot use aggregation functions such as "COUNT" in a calculated field because there is no "GROUP BY" clause. Except for the comma-separated parameter pattern, the DomEL validation cannot enforce these criteria. You must ensure that any SQL functions meet these criteria; otherwise, the expression causes errors when using the Domain to create a report.