JDBC Datalist Action Plugin v5

The JDBC Datalist Action Plugin expands the power of the datalist builder in two amazing ways:

  • Provides a new action button or hyperlink in any columns in your list. The action button can perform a JDBC SQL action (example an update or delete statement) to execute on the selected record when the user clicks the column hyperlink.
  • Provides a new action button above or below the list of records to 'process' one or many records (selected via the list's selector checkbox). The plugin allows you to add a JDBC SQL action to execute on the selected records when the user clicks the action button.

How To Use

Use the format '{id}' to inject the selected row key value in your query, for example: "DELETE FROM <table_name> WHERE <id> = {id}".

You are allowed to use {uuid} to inject a generated unique id to your query for INSERT new record query statements. To execute multiple queries, you can add '&allowMultiQueries=true' to your JDBC URL.

  

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
  • This plugin works only with Joget Workflow Enterprise v5.
  • This plugin requires the Joget Enterprise version 5.0.6 build to be installed in your Joget Workflow platform.

  •  

    If you use the JDBC Datalist Action as a List Action, it will execute the query once for every selected rows.

 

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.

 

 

 

300
$ 0.00
Additional App Information
July 19, 2016
v1
Joget, Inc.
info@joget.org
More Plugin By Joget, Inc.
1 Account Creation App
2 Aggregate Datalist Binder Plugin
3 AJAX Selectbox App
4 AJAX Selectbox Plugin
5 Approve Via Email
6 Asset Management and Tracking
7 Beanshell Datalist Formatter Plugin
8 Book Catalog
9 Calendar Menu Plugin v5
10 Candlestick Charting
11 Card Viewer Userview Menu
12 Classic HTML Userview Menu
13 Color Datalist Formatter
14 Color Picker
15 Condition Datalist Formatter Plugin
16 Country List
17 Currency Field Plugin v5
18 Datalist Hash Variable Plugin v6
19 Duplicate Data Plugin
20 Employee Loan Management
21 Employee Services Portal
22 Enhanced Task Delegation
23 Form File Manager Plugin
24 Form JSON POST Tool Plugin v5
25 Gantt Chart Userview
26 Google Maps App
27 HR Expenses Claim v6
28 Image Datalist Formatter
29 Internal Service Request
30 ISIC List
31 Job Recruitment Management
32 Joget User Mgnt Utility v6
33 JSON Form Options Plugin
34 JSON Form Options Tutorial App
35 JSON POST Tool Plugin v5
36 Kerberos Directory Manager Plugin
37 Loan Calculator
38 Medical Reimbursement
39 Messaging App
40 Multirow Condition Form Binder
41 NAICS List
42 Newsletter Management
43 Partner Opportunity Locking
44 Process Enhancement Plugin DX
45 Process Monitoring Utility For MSSQL
46 Process Monitoring Utility for MySQL
47 Process Version Migrator
48 Purchase Requisition for v6
49 SAML Directory Manager Plugin
50 Scheduler Plugin v5
51 Scheduler Plugin v6
52 Section Wizard App v6
53 Section Wizard Plugin v6
54 Service Help Desk for v6
55 Signature Hash Variable Plugin
56 Simple Document Repository v6
57 Simple Leave & Vacation for v6
58 Simple Meeting Room Booking App
59 Simple Visitor Management
60 Star Rating Plugin
61 Stationery Request
62 Training Evaluation
63 Travel Advisory Tracking App
64 Travel Request
65 Tree Menu App
66 Tree Menu Plugin
67 Workflow Variable Update Process Tool
View More Plugin By Joget, Inc.
Write a review
Reviews
Print