SQL code and JavaScript code

SQL code

An SQL code activity executes an SQL script. The script is a JST template.

• Script

  The central area of the editor contains the script to be executed. This script is a JST template and can therefore be configured according to the workflow context.

• Processing errors

  Refer to Processing errors.

JavaScript code and Advanced JavaScript code

JavaScript code and Advanced JavaScript code activities execute a JavaScript script in the context of a workflow. For more on scripting, refer to the JavaScript scripts and templates section.

Execution delay

Starting 20.2 release, an execution delay has been added to the JavaScript code and Advanced JavaScript code activities. By default, the execution phase cannot exceed 1 hour. After this delay, the process will be aborted with an error message and the activity execution will fail.

You can change this delay in the Stop execution after field available in these activities.

To ignore this limit, you need to set the value to 0.

JavaScript code

• Script: The central area of the editor contains the script to be executed.

• Process errors: Refer to Processing errors.

Advanced JavaScript code

• First call: The first zone of the editor contains the script to execute during the first call.
• Next calls: The second zone of the editor contains the script to execute during the next calls.
• Transitions: You can define several activity output transitions.
• Schedule: The Schedule tab lets you schedule when to trigger the activity.

Advanced JavaScript is a persistent task and is periodically recalled if it has not been marked as completed. To terminate the task and prevent future recalls, you must use the task.setCompleted() method in the Next calls section:

task.postEvent(task.transitionByName("ok")); // to transition to Ok branch
task.setCompleted();

return 0;