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
Steps To Import This Plugin
- Click "Download" on this plugin screen (It will be a .jar file).
- Go to your Joget localhost or server, in Joget Console navigate to "Admin Bar>Systems Settings>Manage Plugins" and click "Upload Plugins" button.
- In "Upload Plugin", select the plugin .jar file you just downloaded, then click "Upload".
- Depending on the plugin type, you can now view your new plugin in your form or datalist or userview.
- Remember to always uninstall the old plugin before uploading a new version.
- The Joget Knowledge Base has more information on managing and developing plugins.