License Error
The license of the app Translations for Confluence (formerly Language Macros) has expired. Please renew the license.
License Error
The license of the app Translations for Confluence (formerly Language Macros) has expired. Please renew the license.
Run the following to create a temporary table in the database to observe the changes.
License Error
The license of the app Translations for Confluence (formerly Language Macros) has expired. Please renew the license.
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
License Error
The license of the app Translations for Confluence (formerly Language Macros) has expired. Please renew the license.
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.
License Error
The license of the app Translations for Confluence (formerly Language Macros) has expired. Please renew the license.
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
License Error
The license of the app Translations for Confluence (formerly Language Macros) has expired. Please renew the license.
In Joget Workflow, from a Process, map a Tool to plugins such as SQL Query Tool.
License Error
The license of the app Translations for Confluence (formerly Language Macros) has expired. Please renew the license.
Add the following code in to call the stored procedure.
License Error
The license of the app Translations for Confluence (formerly Language Macros) has expired. Please renew the license.
3.
call jogetaddrecord("hello");
Observe database change
License Error
The license of the app Translations for Confluence (formerly Language Macros) has expired. Please renew the license.
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)
License Error
The license of the app Translations for Confluence (formerly Language Macros) has expired. Please renew the license.