SQL Functions
- Former user (Deleted)
- Former user (Deleted)
Owned by Former user (Deleted)
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 |