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. | CUSTOMERS.CustName SQL_+ ' (' SQL_+ CUSTOMERS.CustNum SQL_+ ')' |
| SQL_GETDATETIME | Used to retrieve the current timestamp. | SQL_GETDATETIME |
SQL_TOCHAR | Converts a field to a value of VARCHAR2 datatype. | SQL_TOCHAR(13) |
| SQL_SUBSTRING | Retrieves the substring of a string. | SQL_SUBSTRING(FirstName, 1, 1) |
| SQL_CONCAT | Concatenates a number of fields. | SQL_CONCAT[FieldA~FieldB~…~FieldN] |
| SQL_YEAR[ ]SQL_YEAR | Get the year of a date. | SQL_YEAR[SQL_GETDATETIME]SQL_YEAR |
| SQL_MONTH[ ]SQL_MONTH | Get the month of a date. | SQL_MONTH[EFFECTIVEDATE]SQL_MONTH |
| SQL_WEEK[ ]SQL_WEEK | Get the week of a date. | SQL_WEEK[UPDATEDDATE]SQL_WEEK |
| SQL_DAY[ ]SQL_DAY | Get the day of a date. | SQL_DAY[CREATEDDATE]SQL_DAY |
| SQL_NUMERAL[ ]SQL_NUMERAL | Gets the number of days of a date | SQL_NUMERAL[SQL_GETDATETIME]SQL_NUMERAL |