Page History

 Variables|KB:v3 Hash Variables]
----
h3. Example

*Set value to a workflow variable{*}import org.joget.workflow.model.service.*;

WorkflowManager wm = (WorkflowManager) pluginManager.getBean("workflowManager");

wm.activityVariable(workflowAssignment.getActivityId(), "variableId", "variableValue");

*

 JDBC{*}import java.sql.*Connection;

Connection con = null;

try {

Class.forName("com.mysql.jdbc.Driver").newInstance();

con = DriverManager.getConnection("jdbc:mysql://localhost/wflowdb?useUnicode=true&characterEncoding=UTF-8", "root", "root");

if(\!con.isClosed()){

        System.out.println("Successfully connected to MySQL server using TCP/IP..."import java.sql.PreparedStatement;
import java.sql.SQLException;
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
 PreparedStatement stmt = if(!con.createStatementisClosed();) {

        PreparedStatement stmt = con.executeUpdateprepareStatement("UPDATE formdata_simpleflowtable1 setSET c_statuscolumn1='#assignment.activityId#' WHERE processId='#assignment.processId#'"value1'");
        stmt.executeUpdate();

    }

} catch(Exception e) {

    System.err.println("Exception: " + e.getMessage());

} finally {

    try {

        if(con != null) {

            con.close();
        }
    } catch(SQLException e) {
    }

}


h2. Participant Type Plugin

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 returning one Participant{*}

import java.util.ArrayList;

a = new ArrayList();

a.add("jack"); // one username

return a;
\\

h2. Activity

import java.util.Collection;
import java.util.ArrayList;
import org.joget.apps.app.service.AppUtil;
import org.joget.directory.model.service.ExtDirectoryManager;
import org.joget.directory.model.User;
import org.springframework.context.ApplicationContext;

ApplicationContext ac = AppUtil.getApplicationContext();
ExtDirectoryManager directoryManager = (ExtDirectoryManager) ac.getBean("directoryManager");

Collection results = new ArrayList();

Collection userList = directoryManager.getUserList();

for (User u : userList) {
	results.add(u.getUsername());
}
return results;

import java.util.HashMap;
import java.util.Map;
import org.joget.apps.app.model.AppDefinition Tool Type Plugin

Activity tool type plugin is a plugin that will be executed when  workflow reached 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 are two context variables available for the script to use :
* pluginManager
* workflowAssignment

h4. A Beanshell Activity Tool type plugin that sets a form dataimport java.util.ArrayList;

import java.util.logging.Logger;
import org.joget.pluginapps.app.baseservice.PluginManagerAppService;
import java.util.logging.FileHandlerorg.joget.apps.app.service.AppUtil;
import org.joget.workflowapps.form.model.service.WorkflowManagerFormRow;
import org.joget.apps.form.model.FormRowSet;
import org.joget.apps.form.service.FormManagerFormUtil;
import org.joget.formworkflow.model.Form.WorkflowAssignment;
import org.joget.workflow.util.WorkflowUtil;

//Constant variable
String formDefId = "approvalForm";

//Service bean
FormManagerAppService formManagerappService = (FormManagerAppService) pluginManagerAppUtil.getApplicationContext().getBean("formManagerappService");
processId

//Get primary key
String id = appService.getOriginProcessId(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);

\\

//Get existing data
FormRowSet rowSet = appService.loadFormData(appDef.getAppId(), appDef.getVersion().toString(), formDefId, id);
FormRow row = null;
if (rowSet == null || rowSet.isEmpty()) {
    rowSet = new FormRowSet();
    row = new FormRow();
    row.setId(id);
    rowSet.add(row);
} else {
    row = rowSet.get(0);
}

//Set values
row.setProperty("field1", "value 1");
row.setProperty("field2", "value 2");
row.setProperty("field3", "value 3");

//Save
appService.storeFormData(appDef.getAppId(), appDef.getVersion().toString(), formDefId, rowSet, id);

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);