Joget DX Preview Release Available for Download

Check out Joget DX, the next generation successor to Joget Workflow for faster, simpler digital transformation.

Skip to end of metadata
Go to start of metadata

Create a sample table

Run the following to create a temporary table in the database to observe the changes.

CREATE TABLE IF NOT EXISTS `app_fd_demo` (
  `id` varchar(255) NOT NULL,
  `dateCreated` datetime DEFAULT NULL,
  `dateModified` datetime DEFAULT NULL,
  `c_message` longtext,
  PRIMARY KEY (`id`)
)

Prepare the Stored Procedure

In your SQL client, create a sample procedure called as jogetaddrecord by executing the statements below. 

In this procedure, it will insert a new record into app_fd_demo every time it is called.

DELIMITER //
CREATE PROCEDURE jogetaddrecord(IN inputParam VARCHAR(255))
BEGIN
    INSERT INTO app_fd_demo VALUES (now(), now(), now(), inputParam);
END //
DELIMITER ;

Calling the stored procedure in Joget Workflow

  1. In Joget Workflow, from a Process, map a Tool to plugins such as Database Update Tool.
  2. Add the following code in to call the stored procedure.

    call jogetaddrecord("hello");

Observe database change

mysql> select * from app_fd_demo;
+---------------------+---------------------+---------------------+-----------+
| id | dateCreated | dateModified | c_message |
+---------------------+---------------------+---------------------+-----------+
| 2016-06-29 11:57:19 | 2016-06-29 11:57:19 | 2016-06-29 11:57:19 | hello |
+---------------------+---------------------+---------------------+-----------+
1 row in set (0.00 sec)

 

Related Elements

 

 

  • No labels