SQL Queries
Reminder:
- SQL Query can be used to define the domain of values of any field in the quote header, any column and total cell of the quote spreadsheetinformation: SQL Query statements are directly entered in the corresponding property pop-up.
The table below details the associated parameters:
| PARAMETERS | DEFINITION | EXAMPLE |
|---|---|---|
| datasource | Datasource name (must be declared in the application server configuration file) | java:/cartDataSource |
| SQL Statement, only | ||
| SELECT statement is | ||
| allowed. | SELECT ID\_SERVICE,DESCR\_SERVICE | |
| sqlStatement | The “?” parameter is | FROM SERVICE\_TRANSLATE\_CCP WHERE |
| sqlStatement | replaced @runt-time by | ID_LANGUAGE=? |
| the language Id associated | ||
| with the current quote |