Table of Contents
Introduction
JDBC Datalist Action allows you to perform SQL queries on the current or custom datasource as a row action and a bulk action.
JDBC Binder Properties
Configure JDBC Load Binder
Figure 1 : Hyperlink in the row action placeholder and in the bulk action placeholder in the datalist builder
Figure 2 : JDBC Datalist Action Properties
| Name | Description | |||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Label | Link / Button label. | |||||||||||||||||||
| Confirmation Message | Confirmation message before performing action. | |||||||||||||||||||
| Datasource |
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. | |||||||||||||||||||
| Custom JDBC URL | Custom JDBC URL. This field is required when Custom Datasource is selected in Datasource above. | |||||||||||||||||||
| 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.
| |||||||||||||||||||
| Query | Insert your SQL statement here. Use syntax like {id} in query to inject the selected row key.Use {uuid} to generate a unique id.
|
Figure 3 : JDBC Datalist Action Properties - Visibility Control
| Name | Description |
|---|---|
| Rules | Controls on when the action should appear based on the condition(s) set. |