JDBC Datalist Database Binder gives you the flexibility of designing a list by using your own custom SQL query and connection.
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. |
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. (e.g. Select * from dir_user) | |||||
Primary Key | Define the primary key column. By default, it should be "id". |