New Feature

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:

  1. Inside the Form Builder, drag and drop a Select Box element onto the canvas. Click on the Select Box to display the properties.


  2. Inside the properties, select Database Wizard inside Load Data From.


  3. Configure the Database Wizard accordingly.

Database Wizard Properties

NameDescription
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.

TableChoose a Table from the database as a source to retrieve data.
Joins Form Data Table

Joins Form Data Table

FieldDescription
Join TypeCondition type to fulfil.
TableTarget table to join with.
ColumnField ID from source form to set as option label. 
Join ColumnField ID from source form to set as option grouping value.
ID ColumnField ID from source form to set as the option value. 
Label ColumnColumn to be chosen as the Label.
Grouping ColumnColumn to be chosen as the Grouping.


Form Option Caching

NameDescription
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

NameDescription
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 OptionIf checked, an empty option will be added to the selections.
Empty Option LabelEmpty option label. Only in use when Add Empty Option is checked.


Filter

NameDescription
Filter Conditions

Filter Conditions

FieldDescription
Join Type
  • And
  • Or
ColumnTable 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
ValueFilter value
Extra ConditionsFilter conditions in HQL to refine the selections.



Related Video Tutorials

  • No labels