SQL Functions
SQL functions are CRM functions that can be used in summary pages. They translate into the respective database functions in order to be fully compatible.
Attributes
| Name | Description | Example |
|---|---|---|
| SQL_ISNULL | If the field is null then it replaces its value. | SQL_ISNULL(FieldA, '') |
SQL_UPPER | Converts lowercase letters to uppercase. | SQL_UPPER(CC.CONTACTFIRSTNAME) |
| SQL_+ | String concatenation. | |
| SQL_GETDATETIME | Used to retrieve the current timestamp. | |
SQL_TOCHAR | Converts a field to a value of VARCHAR2 datatype. | |
| SQL_SUBSTRING | Retrieves the substring of a string. | |
| SQL_CONCAT | Concatenates a number of fields. | SQL_CONTCAT[FieldA~FieldB~…~FieldN] |
| SQL_YEAR[ ]SQL_YEAR | Get the year of a date. | |
| SQL_MONTH[ ]SQL_MONTH | Get the month of a date. | |
| SQL_WEEK[ ]SQL_WEEK | Get the week of a date. | |
| SQL_DAY[ ]SQL_DAY | Get the day of a date. | |
| SQL_NUMERAL SQL_NUMERAL | Gets the number of days of a date |