Database Wizard Form Data Store

The Database Wizard Form Data Store allows users to configure the database connection and perform queries without coding visually. This simplifies the process of integrating database operations into your forms.

Configure loading

When configuring a data load from Database Wizard, you are presented with the form below.

Configure the following fields:

• Datasource:
  • Custom Datasource: Setup to connect to an external database with 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: Required when Custom Datasource is selected. For example, com.mysql.jdbc.Driver.
• Custom JDBC URL: Required when Custom Datasource is selected. For example, jdbc:mysql://localhost:3307/jwdb?characterEncoding=UTF8&useSSL=false.
• Custom JDBC Username: Required when Custom Datasource is selected.
• Custom JDBC Password: Required when Custom Datasource is selected.
  
  Test the connection parameters: Click the Test Connection button at the bottom of the page to test your configurations quickly.
• Table: Name of the table.
• Key Column: Key Column is the field ID from a form.

Below this form is the advanced section, which is presented in the following image:

Configure the following fields:

• Filter Conditions: Conditions to filter the data set.
• Extra Conditions: Additional condition(s) for filtering the data set. HQL is expected here.
• Handling for Field Workflow Variable?: Click the checkbox if you are using workflow variables mapping in your form elements. The JDBC data store will copy the field value to the workflow variable when you submit the form if the form is mapped to a process. Not applicable to grid elements.
• Handling for Uploaded Files?: Click the checkbox if you are using file or image attachments in your form elements. When you save the form, the JDBC data store will save your file or image attachment into the folder. Select the form to store uploaded files only if you are using a form grid or spreadsheet.

Configure saving

When configuring a data save from Database Wizard, you are presented with the form below.

Configure the following fields:

• Datasource:
  • Custom Datasource: Setup to connect to an external database with 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: Required when Custom Datasource is selected.
  • Example: com.mysql.jdbc.Driver
• Custom JDBC URL: Required when Custom Datasource is selected.
  • Example: jdbc:mysql://localhost:3307/jwdb?characterEncoding=UTF8&useSSL=false
• Custom JDBC Username: Required when Custom Datasource is selected.
• Custom JDBC Password: Required when Custom Datasource is selected.
• Test the connection parameters: Click on the "Test Connection" button at the bottom of the page to quickly test your configurations.
• Table: Name of the table.
• Key Column: Key Column is the field ID from a form.
• Handling for Field Workflow Variable?: Click the checkbox if you are using workflow variables mapping in your form elements. The JDBC data store will copy the field value to the workflow variable when you submit the form if the form is mapped to a process. Not applicable to grid elements.
• Handling for Uploaded Files?: Click the checkbox if you are using file or image attachments in your form elements. The JDBC data store will save your file or image attachment into the .wflow folder when you save the form. Select the form to store uploaded files only if you are using a form grid or spreadsheet.