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

Open

The script above returns the following result: 

SQL Autocomplete Script

Open

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