...
...
| Warning | ||
|---|---|---|
| ||
|
SQL Data Source has the following fields:
- JNDI — represents the resource name of the database used.
Before setting the JNDI, configure it as described on the Data Source Configuration page. - SQL Initial Script — represents the initial script which filters the result from the database for custom fields with or without autocomplete and "0" set for Min. chars.
- SQL Autocomplete Script — represents the script made by user for custom fields with autocomplete.
...
Description
- Type Custom Field: PCF-PRO - Multiple Autocomplete
- Datasource: SQL Data Source
- Min. chars: 0
SQL Initial Script
The script above returns the following result:
...
Description
- Type Custom Field: PCF-PRO - Single Autocomplete
- Datasource: SQL Data Source
- Min. chars: 3
Note: you need to set the JNDI. Before setting the JNDI, configure it as described on the Data Source Configuration page.
...
The script for autocomplete returns the following results:
Example 3
Description
- Type Custom Field: PCF-PRO - Checkbox
- Datasource: SQL Data Source
Note: you need to set the JNDI. Before setting the JNDI, configure it as described on the Data Source Configuration page.
...
The script returns the following results:
