| 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 |
|---|---|
| SQL_ISNULL | If the field is null then it replaces its value. |
SQL_UPPER | |
| SQL_+ | String concatenation. |
| SQL_GETDATETIME | Used to retrieve the current timestamp. |
SQL_TOCHAR | |
| SQL_SUBSTRING | Retrieves the substring of a string. |
| SQL_CONCAT | Concatenates a number of fields. |
| SQL_YEAR[ ]SQL_YEAR | Get the year of a date. |
| SQL_MONTH[ ]SQL_MONTH | Get the month of a date. |
| SQL_WEEK[ ]SQL_WEEK | Get the week of a date. |
| SQL_DAY[ ]SQL_DAY | Get the day of a date. |
| SQL_NUMERAL SQL_NUMERAL | Gets the number of days of a date |
...