JDBC Options Binder Plugin v5

The JDBC Options Binder Plugins allows you to use SQL Select statements, to retrieve and populate 3 types of form elements.

The data could come from the default Joget database or an external database source of your choice.

You can use the JDBC Options Binder plugin on the following form elements:

  • Checkbox
  • Radio
  • SelectBox

If an "external database source" is required, you will need to specify the following:

  • Custom JDBC Driver
  • Custom JDBC URL
  • Custom JDBC Username & Password

Example of a SQL Select statement:

SELECT id, c_CountryName FROM app_fd_country

Do download all three plugins sets as they work together:

Note: In a Joget database, your actual table name is prefix with "app_fd_" and column name prefix with "c_".

Read more at Joget Knowledge Base v5

  

Notes

  • Joget Workflow Enterprise v6 comes preinstalled with JDBC plugins and the v6 plugins are not compatible with v5 JDBC plugins..
  • In a Joget database, your actual table name is prefix with "app_fd_" and column name prefix with "c_". Read more at Joget Knowledge Base v5

 

What's New

  • Updated on 01-Mac-2016 for fix on Custom Datasource.
  • Updated on 23-Oct-2019 for Joget v6 Professional and Enterprise. This JDBC binder will display with binder name "... (Marketplace)" appended.

  

Steps To Import This Plugin

  1. Click "Download" on this plugin screen (It will be a .jar file).
  2. Go to your Joget Workflow localhost or server, in Joget Console navigate to "Admin Bar>Systems Settings>Manage Plugins" and click "Upload Plugins" button.
  3. In "Upload Plugin", select the plugin .jar file you just downloaded, then click "Upload".
  4. Depending on the plugin type, you can now view your new plugin in your form or datalist or userview.
  5. Remember to always uninstall the old plugin before uploading a new version.
  6. The Joget Workflow Knowledge Base has more information on managing and developing plugins.

 

738
$ 0.00
Additional App Information
October 23, 2019
v1
Joget, Inc.
info@joget.org
More Plugin By Joget, Inc.
1 Beanshell Hash Variable Plugin v5
2 Download PDF Datalist Action Plugin
3 Email With Process Audit Trail PDF Plugin
4 Email With Template Plugin
5 Enhanced Theme Plugin
6 File Link Datalist Formatter Plugin
7 Full Text Search Datalist Plugin
8 Gantt Chart Userview Plugin
9 Hyperlink Options Filter Plugin
10 JDBC Form Load Binder Plugin v5
11 JDBC Form Store Binder Plugin v5
12 Mobile Push Notification Plugin
13 Mood Rating Plugin
14 Not Permission Plugin
15 Section Tab Plugin
16 Slack Notification Plugin
17 Slack Webhook Plugin
18 Subform Repeater Plugin
19 Submission Stats Generator Plugin
View More Plugin By Joget, Inc.
Write a review
Reviews
sjk s
1
October 24, 2016
Print