This is a new feature in Joget DX 8

Introduction

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.

Get Started

To use the Database Wizard, here are the steps:

Inside the Form Builder, drag and drop a Select Box element onto the canvas. Click on the Select Box to display the properties.
Inside the properties, select Database Wizard inside Load Data From.
Configure the Database Wizard accordingly.

Database Wizard Properties

Knowledge Base for DX 8 > Database Wizard Options Data Store > image2022-6-29_14-8-12.png

Name Description

Datasource

Custom Datasource - setup to connect to an external database, has an additional configuration.
Default Datasource- connect to the Joget database.

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.

Example: jdbc:mysql://localhost/jwdb?characterEncoding=UTF8&useSSL=false

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

Field	Description
Join Type	Condition type to fulfil.
Table	Target table to join with.
Column	Field ID from source form to set as option label.
Join Column	Field ID from source form to set as option grouping value.

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.

Form Option Caching

Name

Description

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.

Advance

Knowledge Base for DX 8 > Database Wizard Options Data Store > image2022-9-1_16-43-14.png

Name	Description
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.

Filter

Knowledge Base for DX 8 > Database Wizard Options Data Store > image2022-6-29_14-34-32.png

Name

Description

Filter Conditions

Field	Description
Join Type	And Or
Column	Table Column ID
Operator	Equal Not Equal Greater Than Greater Than Or Equal Less Than Less Than Or Equal Like Not Like In Not In Is True Is False Is Null Is Not Null
Value	Filter value

Extra Conditions

Filter conditions in HQL to refine the selections.