Table of Contents
Introduction
...
| borderColor | green |
|---|---|
| borderWidth | 1 |
| titleBGColor | #ddffcc |
| borderStyle | solid |
| title | Definition |
JDBC Datalist Database Binder gives you the flexibility of designing a list by using your own custom SQL query and connection.
| Panel | ||||||||||
|---|---|---|---|---|---|---|---|---|---|---|
| ||||||||||
This feature has been enhanced in Joget Workflow v6. |
Figure 1: JDBC Datalist Database Binder Properties
| Name | Description | |||||
|---|---|---|---|---|---|---|
| Datasource |
By selecting Default Datasource, the database your Joget is currently using will be selected. |
| ||||
| 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.
| |||||
SQL SELECT Query | SQL Select |
query to populate the datalist.
| |||||||
Primary Key | Define the primary key column. By default, it should be "id". | ||||||
| Optimize query for paging | When checked, the binder only fetches selected page's items rather than the returning the whole data set for improved loading speed. |
Note: Only applicable to MYSQL and MSSQL target database. |
| Info | ||
|---|---|---|
| ||
This is a new feature in Joget Workflow v6. |
...