...
- Application
- Form Variable
- Participant
- Activity Tool
What
...
is it for?
BeanShell is a small, embeddable Java source interpreter with object scripting language features, written in Java. BeanShell dynamically executes standard Java syntax. So, by using BeanShell Plugin, you can type in valid Java codes in plugin configuration, and the statements will be executed when the plugin is triggered. No compilation cycle is needed.
...
Set value to a workflow variable:
| Code Block |
|---|
import org.joget.workflow.model.service.*;
WorkflowManager wm = (WorkflowManager) pluginManager.getBean("workflowManager");
wm.activityVariable(workflowAssignment.getActivityId(), "variableId", "variableValue");
|
Execute SQL statement through JDBC:
| Code Block |
|---|
import java.sql.*;
import javax.sql.DataSource;
import org.joget.apps.app.service.AppUtil;
Connection con = null;
try {
// retrieve connection from the default datasource
DataSource ds = (DataSource)AppUtil.getApplicationContext().getBean("setupDataSource");
con = ds.getConnection();
// execute SQL query
if(!con.isClosed()) {
PreparedStatement stmt = con.createStatement();
stmt.executeUpdate("UPDATE formdata_simpleflow set c_status='#assignment.activityId#' WHERE processId='#assignment.processId#'");
}
} catch(Exception e) {
System.err.println("Exception: " + e.getMessage());
} finally {
try {
if(con != null) {
con.close();
}
} catch(SQLException e) {
}
}
|
...
A participant type plugin should return a collection of usernames. In the participant plugin, there are two context variables available for the script to use :
- pluginManager
- workflowActivity
A Beanshell Participant Type Plugin participant type plugin returning one Participantparticipant:
| Code Block |
|---|
import java.util.ArrayList;
a = new ArrayList();
a.add("jack"); // one username
return a;
|
...
Activity Tool Type Plugin
Activity tool type plugin Tool Type Plugin is a plugin that will be executed when the workflow reached reaches a System Tool activity. System Tool activities must be placed in the workflow diagram , and then the Beanshell plugin configured in the Process's Activity Mapping for this to work. In this plugin there , there are two context variables available for the script to use :
- pluginManager
- workflowAssignment
A Beanshell
...
activity tool type plugin that sets a form data:
| Code Block |
|---|
import java.util.ArrayList;
import java.util.logging.Logger;
import org.joget.plugin.base.PluginManager;
import java.util.logging.FileHandler;
import org.joget.workflow.model.service.WorkflowManager;
import org.joget.form.model.service.FormManager;
import org.joget.form.model.Form;
FormManager formManager = (FormManager) pluginManager.getBean("formManager");
processId = workflowAssignment.getProcessId();
Form form = formManager.loadDynamicFormByProcessId("T01", processId); // in this example, form's table is T01
formData = form.getCustomProperties();
formData.put("c_columnname","new value"); // the form data field to be set is columnname
form.setCustomProperties(formData);
formManager.saveForm(form);
|
Increment a workflow variable value:
| Code Block |
|---|
import org.joget.workflow.model.service.WorkflowManager;
WorkflowManager workflowManager = (WorkflowManager) pluginManager.getBean("workflowManager");
String approvalLvl = workflowManager.getProcessVariable(workflowAssignment.getProcessId(), "ApprovalLevel");
String newApprovalLvl = String.valueOf(Integer.parseInt(approvalLvl)+1);
workflowManager.activityVariable(workflowAssignment.getActivityId(), "ApprovalLevel", newApprovalLvl);
|
This beanshell script retrieves workflow variable 'ApprovalLevel', convert converts it into to an integer, add adds 1, and stores it back as the same workflow variable.