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