| Panel | ||
|---|---|---|
| ||
SQL FunctionsSQL functions are CRM functions that are used that can be used in summary pages. They translate translate into their the respective database functions in order to be fully compatible functions. |
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_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 |