...
Workflow variables in Joget are key data elements that are essential for the overall operation and flow of a process. Unlike data specific to individual forms or activities, workflow variables have a broader scope and are used throughout the entire process.
Distinction
...
Between Normal Data and Workflow Variables
For example, consider a Leave Application process . When an employee fills out a leave application form, they provide details such as the date of application, the duration of the leave, and the reason for the leave. This type of data is specific to that particular form. These details are critical where form data like application date, leave duration, and reason are specific to each application. They are used for record-keeping and for informing the decision-makers (like supervisors ) about the leave request . However, they typically serve only within the scope of that form and are used for informational purposes rather than driving the process flow. This form-specific data is usually stored associated with that particular leave application instance. It can be accessed and reviewed by relevant parties, such as HR personnel or supervisors, to understand the specifics of the leave request.but do not control the workflow.
Workflow variables, on the other hand, are elements that carry significant weight in determining the flow of the process. In the Leave Application process, a good example of a workflow variable could be "supervisorApproval". This variable might store a value like "approvedApproved" or "rejectedRejected". The value of this variable is used to decide the next steps in the workflow. For example, if "supervisorApproval" is "approved", the process might move to the HR department for final processing. If it's "rejected", the process might end or return to the employee for further action. The key here is that the workflow variable directly influences the overall process flow. It's not just a piece of information, but a driver for decisions and actions within the workflow.This variable becomes crucial when a supervisor's decision (accept or reject) alters the course of the workflow, triggering different activities or decisions.
Here is a screenshot from a sample app showing a process builder and workflow variable initialization.
Figure 1: Process Builder and Workflow Variable
Form Fields and Workflow Variables in Joget
...
Scope: The data entered or displayed in form fields is specific to that form instance.It's mainly used for capturing and displaying information relevant to a single step or part of the process. For advanced usage, the form data can be used within the App using the Form Data Hash Variable which increases the scope to a global level (allowing usage in other parts of the App).
Storage: Data from form fields is typically stored in the application's database and is associated with the specific instance of the form. It's accessible whenever the form is loaded or referenced (using Form Hash Variables).
Workflow Variables in Joget
...
Influence on Process Flow: Workflow variables are often used to control process routing, conditions, and decision points within a workflow. Their values can determine which path a process takes, or which activities are triggered next.
| Info | ||
|---|---|---|
| ||
In Joget, a form field and a workflow variable, even if named similarly (e.g., both called "status"), are distinct entities. A form field is specific to a form and is used to capture user input, while a workflow variable is a broader process-level variable that can influence and guide the workflow's progression and routes taken. So in this case, the 'status' variable |
...
is also stored in different database tables. |
Storage: Stored on a database table separate from the form data. These variables are stored in the "shkactivitydata" database table and are not to be tampered with for reasons mentioned below in the section Storage mechanisms for form data variables and workflow variables.
Key Concepts
Hash Variables
In Joget, a Hash Variable is a specialized, hash-escaped keyword that has a wide range of applications across different components of the platform. It can be used in the Form Builder, List Builder, and UI Builder to dynamically retrieve and display the values of runtime variables. Beyond these builders, Hash Variables are also utilized in configuring properties for supported plugins, naming activities within the Process Builder, and specifying external form URLs when mapping activities to external forms.
Example- #date.D-MMM-yyyy# (date hash variable).
This versatile functionality allows Hash Variables to effectively pull and display relevant runtime information from the application's variables, enhancing the dynamic interaction and responsiveness of the application to real-time data changes.
Here is a list of hash variables offered by Joget:
- Workflow Assignment Hash Variable
- Workflow Process Hash Variable
- Current User Hash Variable
- Date Hash Variable
- Environment Variable Hash Variable
- App Variable Hash Variable
- Form Data Hash Variable
- Form Binder Hash Variable
- App Definition Hash Variable
- App Message Hash Variable (Internationalization)
- Performer Hash Variable
- Request Parameter Hash Variable
- User Hash Variable
- Userview Key Hash Variable
- Workflow Variable Hash Variable
- Request Hash Variable
- Platform Hash Variable
- Users Hash Variable
- Bean Shell Hash Variable
- Datalist Hash Variable
- Expression Hash Variable
- Report Builder Hash Variable
- Code Builder Hash Variable
This list categorizes the types of Hash Variables that can be utilized within Joget DX for various purposes, such as accessing specific data, internationalizing applications, managing user information, and more. Each type of Hash Variable serves a specific function in retrieving and displaying data dynamically within the Joget application platform.
...
It is recommended to read this article to have a clearer understanding of what hash variables are.
Populate Data Dynamically
For functionalities like populating an email body, both form data (accessed via #form.table.status#) and workflow variables (#variable.status#) can be utilized, offering flexibility in how data is referenced within the workflow.
Please do keep in mind that it is important to not confuse the form data with workflow variables. As explained before, they are separate entities but both entities can be used as hash variables for use inside, for example, an email body.
Scope of Use
Please note that every hash variable has its scope of use. This dictates where the hash variable can be used. Workflow variable hash variable(#variable.variableName#), can only be used by elements within and part of a Process.
Additionally, these values are being parsed on the server side, not the client side. If there is a need to parse it, you will need to use workflowutil.processVariable method to do so.
Update Mechanisms
Form Data Update Tool: This plugin built-in tool is used to update values directly in the database. To use this go to Process Builder > Tools > Mapping > Select Update Form Data > Update Fields.
The changes made using this tool affect the data stored in form fields. It is an efficient way to ensure that the data entered or modified in form fields is accurately This tool ensures that any changes or entries made to form fields are correctly reflected in the database, without needing manual input, directly within the workflow process.
Figure 2: Form Data Update Tool in Process Builder
Workflow Variable Update Tool: Available at the marketplace, the Workflow Variable Update Tool updates the value of workflow variables. To use this go to Process Builder > Tools > Mapping > Select Workflow Variable Update Tool > Workflow Variable Mapping.
It's used when there's a need to modify the values of variables that control or influence the workflow process.
Figure 3: Workflow Variable Update Tool in Process Builder
Besides the Workflow Variable Update pluginBesides this tool, BeanShell scripting can also be used to update workflow variables. BeanShell is a lightweight scripting language that offers a flexible way to write scripts for various purposes, including updating workflow variables. While BeanShell scripting provides a powerful and flexible way to manage workflow variables, the Workflow Variable Update Tool is often preferred for its user-friendliness and ease of use, especially for users who might not be comfortable with scripting.
...
While workflow variables are essential for process routing, other elements like form data and hash variables can also be used for similar purposes. For example, using a form hash variable in a transition condition e.g., ((# form.f1.TextField # #form.Approval_Form.status# === "trueApproved")) is a viable alternative to check for conditions and make decisions in the process workflow.
Both form hash and workflow hash will work. For exampleApart from routing, a workflow hash can also be used within the application for dynamic data referencing, such as in custom scripts or email bodies, where they can be called upon using syntax like # variable.status #.#variable.status#.
Figure 4: Making a routing decision using a Workflow Variable in Process Builder
Figure 5: Making the same routing decision using a Form Hash Variable in Process Builder
For this example, this status field is present in a form named Approval Form. In Figure 5, we are simply checking if the value in this form is "Approved" or other than approved ("Rejected"), and then we proceed to route to the correct decision.
Figure 6: Status Field options
A key feature of workflow variables is their ability to create an audit trail. As the process progresses, every change in the value of a workflow variable is recorded. This provides a detailed history of how the process has evolved over time, which is essential for review and monitoring purposes. This tracking ability enhances transparency and accountability in the workflow. By having a clear record of all changes, administrators and users can understand the decision-making process and the flow of activities more comprehensively, In the monitor section, the variable list efficiently tracks a record's progress through the workflow.
Figure 7: Viewing a Completed Activity Instance
In this view, one can see the state and statistical data of a particular completed activity instance.
Choosing the Right Tool
The decision to use workflow variables, form data, or hash variables depends on the specific needs of the process. For simpler decision-making where an audit trail is not critical, form data or hash variables might suffice. However, for complex processes where tracking the history of decisions is important, workflow variables become indispensable.
Dynamic Data Utilization
Storage Mechanisms for Form Data Variables and Workflow Variables
Workflow variables in Joget play a crucial role in guiding the process flow and making decisions, but they are different from form data, which users directly input into forms. These workflow variables are not inherently visible in forms or datalists as they operate behind the scenes.
The storage and display of workflow variables pose certain challenges. These variables are stored in the "shkactivitydata" database table. Displaying them in a datalist typically requires an SQL JOIN with this table. However, this can lead to performance issues, particularly in large-scale applications. For example, a process with numerous variables and activities can result in a substantial number of records in the database, escalating rapidly with the number of transactions. This increase in data can significantly impact the performance of datalists. For example, if your process has 10 workflow variables and 10 activities, the total records stored in the DB table is 100 records, and if the total number of process transactions reaches 1,000, you will generate 100,000 records in the "shkactivitydata" table for just one process. If the combined total of processes in all your Joget app is 100 processes, this table will grow to 10 million.
As a best practice, it's recommended to map workflow variables to form fields. This mapping ensures the values of workflow variables are 'copied' to corresponding form fields at each activity, making them visible and accessible for later viewing in forms and datalists. This approach avoids the direct querying of the large "shkactivitydata" table, optimizing performance.Apart from routing, workflow variables are versatile in their application.