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
In Joget Workflow, from a Process, map a Tool to plugins such as SQL Query.
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)