| Table of Contents |
|---|
Introduction
...
This plugin is designed to enhance Joget DX 8 functionality. Known as the JDBC Validator, it empowers users to conduct validations through custom SQL queries. With this capability, users can ensure the accuracy and consistency of their data within the Joget DX 8 platform.
...
Plugin Usage
When crafting the SQL query, users have access to dynamic parameters to retrieve form field values. Two primary symbols are available for this purpose: the question mark '?' and curly braces '{fieldId}'. These symbols serve distinct functions in data retrieval.
The question mark '?' is utilised to fetch the current form field's value within the SQL query. It enables users to perform validations based on the data input provided by the user during the form-filling process
On the other hand, the curly braces '{fieldId}' serve a different purpose. They allow users to access values from other form fields, not necessarily the one currently being validated. This versatility is valuable in scenarios where cross-field validation is required, enabling comparisons and dependencies between different form elements.
By leveraging these dynamic symbols within their SQL queries, users can create sophisticated validation rules tailored to their specific business requirements. Whether it's simple data checks or complex inter-field relationships, the JDBC Validator provides a flexible and powerful solution to ensure data integrity and compliance within the Joget DX 8 environment.
Figure 1: JDBC Validator Properties
...
Understanding JDBC Validator
...
| Info |
|---|
...
| |||||
|
| Info | ||
|---|---|---|
| ||
The combination of these conditions ensures that the JDBC Validator checks for duplicate budget entries with the same year and name, excluding the current budget entry being edited (identified by its 'id') from the validation process. |
Figure 2: Demo
...
- Read more at https://github.com/jogetoss/jdbc-validator
- Download the plugin from https://github.com/jogetoss/jdbc-validator/releases/tag/7.0.1
- Download the sample app here