| 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. |
Attributes
| Name | Description | Example | |
|---|---|---|---|
| SQL_ISNULL | If the field is null then it replaces its value. | SQL_ | UPPERISNULL(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_NUMERAL DAY[CREATEDDATE]SQL_DAY | |
| SQL_NUMERAL[ ]SQL_NUMERAL | Gets the number of days of a date |
Examples
...
| SQL_ |
...
| Code Block | ||||||
|---|---|---|---|---|---|---|
| ||||||
SQL_ISNULL(FieldA, '') |
...
| title | SQL_CONCAT |
|---|
...
| theme | Eclipse |
|---|---|
| language | xml |
| title | SQL_CONCAT |
...
| NUMERAL[SQL_GETDATETIME]SQL_NUMERAL |