Table of Contents
Introduction
| Panel | ||||||||||
|---|---|---|---|---|---|---|---|---|---|---|
| ||||||||||
JDBC Options Binder allows you to retrieve form options from Joget or custom database via user-defined SQL statements. |
| Panel | ||||||||||
|---|---|---|---|---|---|---|---|---|---|---|
| ||||||||||
This is a new feature in Joget Workflow v6. |
...
JDBC Datalist Properties
Configure JDBC Datalist Binder
Figure 1: JDBC Options Binder Properties
| Name | Description | ||||||
|---|---|---|---|---|---|---|---|
| Datasource |
| ||||||
| Custom JDBC Driver | Custom JDBC Driver. This field is required when Custom Datasource is selected in Datasource above. Example: com.mysql.jdbc.Driver | ||||||
Custom JDBC URL | Custom JDBC URL. This field is required when Custom Datasource is selected in Datasource above. | ||||||
Custom JDBC Username | Custom JDBC Username. This field is required when Custom Datasource is selected in Datasource above. | ||||||
Custom JDBC Password | Custom JDBC Password. This field is required when Custom Datasource is selected in Datasource above.
| ||||||
| Use AJAX for cascade options? | When checked, this allows these fields to dynamically load available options based on the other field value (grouping column) when dealing with tremendous amount of selections. |
Read more at Ajax Cascading Drop-Down List. |
|
| ||||||||||
| Add Empty Option | If checked, an empty option will be added to the selections. | |||||||||
| Empty Option Label | Empty option label. Only in use when Add Empty Option is checked. | |||||||||
SQL SELECT Query | To populate a selectbox, for example, you need to return at least 2 columns. The first column is used for value/ID. The second column is used for label. An optional third column can be returned for grouping value.
|
When Use AJAX for cascade options? is checked, make sure that a question mark is placed within the query.
|
...