...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
| 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 Configurationsource 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 Configurationsource configuration page.
SQL Autocomplete Script
...
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 Configurationsource configuration page.
SQL Initial Script
...
The script returns the following results:
