/
SQL Functions
The following macros are not currently supported in the header:
  • style




YOU ARE CURRENTLY ACCESSING AN OUTDATED VERSION OF THE ZOOLA HELP DOCUMENTATION

Go to https://help.zoola.io for up-to-date documentation, videos, walkthroughs, and case studies.



SQL Functions

Owned by Zaqir Virani (Unlicensed)
Last updated: May 10, 2016

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.

 

​Copyright © Lambda Zoola™