by Joget, Inc.
FREE
390
DESCRIPTION

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 Enterprise v6 & DX comes preinstalled with JDBC plugins and the v6 & DX 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
  • This plugin works only with Joget Enterprise v5.
  • This plugin requires the Joget Enterprise version 5.0.6 build to be installed in your Joget 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 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 Knowledge Base has more information on managing and developing plugins.

 

Additional Plugin Information

July 19, 2016
FREE
1155
v5.0.0
Developer Info
Joget, Inc.
Write a review
Reviews
Print