Example 3 - SQL Data Source
The app enables you to intervene in the process of data build-up even in the stages of the autocomplete.
SQL Data Source fields
JNDI: Represents the resource name of the database that is used.
Before setting the JNDI, configure it using the steps in the SQL Data Source page.SQL Initial Script: Represents the initial script that filters the results from the database for custom fields with or without autocomplete and "0" set for Min. chars.
SQL Autocomplete Script: Represents the user-created script for custom fields with autocomplete.
Example 1
Description
Type Custom Field: PCF - 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- Single Autocomplete
Datasource: SQL Data Source
Min. chars: 3
SQL Autocomplete Script
The script for autocomplete returns the following results:
Example 3
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 SQL Data Source page.
SQL Initial Script
The script returns the following results:
See More