...
| Name | Description | Screens (Click to view) | |||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 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 databaseto optimize the performance for large dataset paging. Only works for MySQL and Microsoft SQL Server 2012 onwards. |
Related JDBC Binders & Useful Links
...