Example 3 - SQL Data Source
Power Custom Fields PRO™ is becoming Power Custom Fields™
Power Custom Fields PRO™ is being upgraded to Power Custom Fields™. We are removing Power Custom Fields PRO™ from the market to focus resources on the combined app, Power Custom Fields™ which has all the features of PRO™ and more. Existing Power Custom Fields PRO™ users can get 65% off their new Power Custom Fields™ license by following the steps here.
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.
The following examples work for huge data sets.
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 PRO helps you save your time tremendously because you no longer need to go through a list of all products to select the necessary one.
The app enables you to intervene in the process of data build-up even in the stages of the autocomplete.
Example 1
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:
SQL Autocomplete Script
The script for autocomplete returns the following results:
Example 2
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.
SQL Autocomplete Script
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.
SQL Initial Script
The script returns the following results: