| Table of Contents |
|---|
| English | |||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
Introduction
The Database Wizard Form Data Store allows users to visually configure the database connection and perform queries without coding
Database Wizard Form Data Properties
Figure 1: Database Wizard selected as Load Data From & Save Data To
...
Figure 2: Configure Database Wizard (Load)
| Name | Description | |||||
|---|---|---|---|---|---|---|
| Datasource |
By selecting Default Datasource, the database your Joget is currently using will be selected. (See Figure 3). | |||||
| Custom JDBC Driver | Custom JDBC Driver. This field is required when Custom Datasource is selected in Datasource above. Example: | |||||
Custom JDBC URL | Custom JDBC URL. This field is required when Custom Datasource is selected in Datasource above. Example: | |||||
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 | Table Name. | |||||
Key Column | Key Column is the field id from a form. |
Figure 3: Advanced
| Name | Description |
|---|---|
| Filter Conditions | Filter Conditions |
| 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. |
| The JDBC |
| data store will save your file or image attachment into the ".\wflow" folder when you save the form. |
| Select form to store uploaded files only if you are using a form grid or spreadsheet. |
Figure 4: Configure Database Wizard (Save)
| Name | Description | |||||
|---|---|---|---|---|---|---|
| Datasource |
By selecting Default Datasource, the database your Joget is currently using will be selected. (See Figure 3). | |||||
| Custom JDBC Driver | Custom JDBC Driver. This field is required when Custom Datasource is selected in Datasource above. Example: | |||||
Custom JDBC URL | Custom JDBC URL. This field is required when Custom Datasource is selected in Datasource above. Example: | |||||
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 | Table Name. | |||||
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 form to store uploaded files only if you are using a form grid or spreadsheet. |
Related Video Tutorials
Widget Connector width 700 url https://www.youtube.com/watch?v=LlJsXi5e6pQ&ab_channel=Joget%2CInc. height 550