Page History

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.

   Thai
   ใน Joget Workflow จาก Process ให้จับคู่เครื่องมือกับปลั๊กอินเช่น Database Update Tool

2. Add the following code in to call the stored procedure.

   Thai
   เพิ่มรหัสต่อไปนี้ในการเรียกกระบวนงานที่เก็บไว้

   

   Code Block
   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

• Database Update Tool

...