Joget DX 8 Stable Released
The stable release for Joget DX 8 is now available, with a focus on UX and Governance.
Database Wizard for Loading Selections / Options is a new feature introduced in Joget DX 8. Database Wizard allows the user to integrate external databases inside Form Select Box element. Instead of dealing with SQL code, users can now visually configure database connections, queries and updates.
To use the Database Wizard, here are the steps:
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.
|Table||Choose a Table from the database as a source to retrieve data.|
|Joins Form Data Table|
Joins Form Data Table
|ID Column||Field ID from source form to set as the option value.|
|Label Column||Column to be chosen as the Label.|
|Grouping Column||Column to be chosen as the Grouping.|
|Pause sync after idle|
How long to wait to pause synchronization after idle.
|Sync Cache Interval|
How often to activate cache synchronization (in seconds).
For example, when set to 180 seconds, background synchronization in the server will take place every 180 seconds to refresh with the new/latest data.
|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 a 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.|
|Extra Conditions||Filter conditions in HQL to refine the selections.|