| Panel | ||
|---|---|---|
| ||
SQL FunctionsSQL functions are CRM functions that can be used in summary pages. They translate into the respective database functions in order to be fully compatible. |
...
| 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_ADDMONTHS | Adds a number of months to a date. | SQL_ADDMONTHS(STARTDATE, 2)SQL_NUMERAL[SQL_GETDATETIME]SQL_NUMERAL |