...
...
...
...
...
...
...
...
...
...
...
...
| Info | ||
|---|---|---|
| ||
|
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.
...
For instance, you own a store and sell car parts and you have thousands of products and have to work with huge data sets. Power Custom Fields Premium™ Fields™ helps you save your time tremendously because you no longer need to go through a list of all products to select the necessary one.
...
Description
- Type Custom Field: PCF - Multiple Autocomplete
- Datasource: SQL™ Data Source
- Min. chars: 0
SQL Initial Script
...
Description
- Type Custom Field: PCF- 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.
...
Description
- Type Custom Field: PCF - 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:
