Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

1. What is the problem?

English
We would like to run multiple store binders plugins in a single store binder selection. This would open up more use cases with the ability to store form data into multiple destinations without the need for relying on other approaches such as JSON Tool or SOAP Tool.

2. What is your idea to solve the problem?

...

The following of this tutorial is prepared with Joget Source Code version 7.0.0. Please refer to Guideline for developing Developing a pluginPlugin for other platform commands.

...

Then, let upload the plugin jar to Manage Plugins. After upload, the jar file, double-check the plugin is uploaded and activated correctly.

Image Modified

Let create a form to create and update user to dir_user table.

Image Modified

Then, configure the store binder of the section to Default Form Binder and JDBC Binder.

Image Modified

Code Block
languagesql
titleCheck Select Query
select username from dir_user where username = {id}
Code Block
languagesql
titleInsert Query
insert into dir_user
(id, username, firstName, lastName, email, active)
values
({id}, {id}, {firstName}, {lastName}, {email}, 1)

...

Info
titleNote

{uuid} can be used to generate a unique id

Code Block
languagesql
titleUpdate Query
update dir_user set firstName = {firstName}, lastName = {lastName},
email = {email}
where username = {id}

...

Code Block
languagesql
titleDelete Query
delete from TABLE_NAME where id = {id}


Image Modified

Now, let test to add a user.

Image Modified

Check the user is created in dir_user table.

Image Modified

It works! Please remember to test the other features of the plugin as well. (big grin)

...