Versions Compared

Old Version 6

changes.mady.by.user Hugo

Saved on

compared with

New Version 7

changes.mady.by.user Hugo

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

Please visit https://github.com/jogetoss/iterator-process-tool/releases to download the plugin.

Examples

Send Daily Reminder on Upcoming Meeting within 2 days

  1. In this example, we are making use of Scheduler plugin to trigger the plugin at 7am daily. Set the plugin to "Iterator Process Tool (Record)".
    Image Added

  2. We can make use of "Database Query Process Tool" as the mean to pick up the records later. First, we will need to prepare the SQL to pick up bookings that are happening within 2 days from the time the job runs.

    Code Block
    languagesql
    linenumberstrue
    SELECT id, c_subject, c_name, c_room, c_date_from, c_date_from FROM app_fd_mrb_booking  
WHERE c_date_from > NOW() AND DATE(c_date_from) < DATE_ADD(NOW(), INTERVAL 2 DAY)
/*pick up bookings happening within 2 days from now to send reminder*/

    Image Added
    Take note that it is important that we return the "id" column as it will be used to set the record context for hash variable to work.

  3. This is the complete configurations.
    Image Added
  4. Choose "Process Tool", followed by "Database Query Process Tool"
  5. Set "id" in "Record ID" for the reason explained above.
  6. In "Execute Process Tool", choose "Email Tool".
  7. The email tool will be triggered once per record it iterates through.

  8. Observe the server log or check emails to verify.

    Image Added

    Code Block
    languagebash
    linenumberstrue
    INFO  15 Mar 2022 18:17:00 org.joget.marketplace.IteratorProcessToolRecord$1 - Executing tool: executeProcessTool - org.joget.apps.app.lib.EmailTool
INFO  15 Mar 2022 18:17:00 org.joget.marketplace.IteratorProcessToolRecord$1 - Executed tool: executeProcessTool - org.joget.apps.app.lib.EmailTool
INFO  15 Mar 2022 18:17:00 org.joget.apps.app.lib.EmailTool - EmailTool: Sending email from=hugolim@outlook.com, to=hugo@joget.org, cc=, bcc=, subject=Booking Product Discussion
INFO  15 Mar 2022 18:17:02 org.joget.apps.app.lib.EmailTool - EmailTool: Sending email completed for subject=Booking Product Discussion
INFO  15 Mar 2022 18:17:05 org.joget.marketplace.IteratorProcessToolRecord - Finished item 1 - Record: 2960b356-161d-451a-8c2d-85fdebf2e111
INFO  15 Mar 2022 18:17:05 org.joget.marketplace.IteratorProcessToolRecord - Iterating item: 2 - Record: 2960b356-161d-451a-8c2d-85fdebf2e121
INFO  15 Mar 2022 18:17:05 org.joget.marketplace.IteratorProcessToolRecord$1 - Executing tool: executeProcessTool - org.joget.apps.app.lib.EmailTool
INFO  15 Mar 2022 18:17:05 org.joget.marketplace.IteratorProcessToolRecord$1 - Executed tool: executeProcessTool - org.joget.apps.app.lib.EmailTool
INFO  15 Mar 2022 18:17:05 org.joget.apps.app.lib.EmailTool - EmailTool: Sending email from=hugolim@outlook.com, to=hugo@joget.org, cc=, bcc=, subject=Booking Project Debrief
INFO  15 Mar 2022 18:17:06 org.joget.apps.app.lib.EmailTool - EmailTool: Sending email completed for subject=Booking Project Debrief
INFO  15 Mar 2022 18:17:10 org.joget.marketplace.IteratorProcessToolRecord - Finished item 2 - Record: 2960b356-161d-451a-8c2d-85fdebf2e121