Page History

...

1. Datasource: Using custom datasource or Joget default datasource

   Thai
   แหล่งข้อมูล: การใช้แหล่งข้อมูลที่กำหนดเองหรือแหล่งข้อมูลเริ่มต้นของ Joget

2. Custom JDBC Driver: The JDBC driver for custom datasource

   Thai
   Custom JDBC Driver: ไดรเวอร์ JDBC สำหรับแหล่งข้อมูลที่กำหนดเอง

3. Custom JDBC URL: The JDBC connection URL for custom datasource

   Thai
   Custom JDBC URL: URL การเชื่อมต่อ JDBC สำหรับแหล่งข้อมูลที่กำหนดเอง

4. Custom JDBC Username: The username for custom datasource

   Thai
   ชื่อผู้ใช้ JDBC แบบกำหนดเอง: ชื่อผู้ใช้สำหรับแหล่งข้อมูลที่กำหนดเอง

5. Custom JDBC Password: The password for custom datasource

   Thai
   Custom JDBC Password: รหัสผ่านสำหรับแหล่งข้อมูลที่กำหนดเอง

6. SQL Query: The query to populate options. 

   Thai
   SQL Query: แบบสอบถามเพื่อเติมตัวเลือก

7. Use Ajax: A checkbox to decide whether or not it is using AJAX to load options. (For AJAX Cascading Drop-Down List)

   Thai
   ใช้ Ajax: ช่องทำเครื่องหมายเพื่อตัดสินใจว่าจะใช้ AJAX เพื่อโหลดตัวเลือกหรือไม่ (สำหรับ AJAX Cascading Drop-Down List)

The query should also support a syntax to inject dependency values when using AJAX.

Example:

1. SELECT id, name from app_fd_sample where group = ?

2. SELECT id, name from app_fd_sample where group in (?)

...

The following tutorial is prepared with a Macbook Pro and Joget Source Code version 58.0.0-Snapshot. Please refer to the the Guideline for developing a plugin article for other platform commands. 

...

- Home
  - joget
    - plugins
    - jw-community
      -5.0.0

The "plugins" directory is the folder we will create and store all our plugins and the "jw-community" directory is where the Joget Workflow Source code is stored.

...

cd joget/plugins/
~/joget/jw-community/5.0.0/wflow-plugin-archetype/create-plugin.sh org.joget.tutorial jdbc_options_binder 58.0.0-Snapshot

Then, the shell script will ask us to key in a version number for the plugin and request for a confirmation before generating the maven project.

...

Define value for property 'version':  1.0-SNAPSHOT: : 58.0.0-Snapshot
[INFO] Using property: package = org.joget.tutorial
Confirm properties configuration:
groupId: org.joget.tutorial
artifactId: jdbc_options_binder
version: 5.0.0
package: org.joget.tutorial
Y: : y

...

Then, we have to create a UI for admin user to provide inputs for our plugin. In getPropertyOptions method, we have already specify that our Plugin Properties Options definition file is located at "/properties/jdbcOptionsBinder.json". Let us create a directory "resources/properties" under "jdbc_options_binder/src/main" directory. After creating the directory, create a file named "jdbcOptionsBinder.json" in the "properties" folder.

...

...

Image RemovedImage Added

Then, let us create an AJAX Cascading Drop-Down List in a form to test it. Let's create our test form as follows.

Image RemovedImage Added

Then, configure our select box and JDBC binder.

Image Removed

Image RemovedImage Added

In the query, we will use the following query to get the user list based on group id.

...

select distinct username, firstName, groupId from dir_user u 
join dir_user_group g on u.username=g.userId 
where groupId in (?) group by username;

Image RemovedImage Added

Configure the dependency to "group". Then, test the result.

Image RemovedImage AddedImage Removed

Image Added

The user select box options changed based on the selected values of group select box.

...

Image RemovedImage Added

Yes, it works as well. Then, we can test the custom configuration and the test connection button.

...

You can download the source code from jdbc_options_binder_src.zip.

To download the ready-to-use plugin jar, please find it in http://marketplace.joget.org/.