DEV Community: Explorer

🔎 Build Dynamic SQL Filters for Joget Reports with BeanShell

Explorer — Fri, 29 May 2026 14:44:49 +0000

Overview

Sometimes a Joget report needs to be rebuilt from filter fields before a datalist or chart displays the result. This BeanShell pattern reads filter values from a form, builds a safe parameterized SQL query, groups records by status, and writes the summarized result into a reporting table.

This is useful when a chart, datalist, or report plugin expects data from a simple table.

How It Works

Read filter values from a Joget form.
Build the WHERE clause only for filters that have values.
Use PreparedStatement parameters instead of SQL string concatenation.
Group records by status and count them.
Rebuild the report summary table.
Close all database resources in inally.

Where to Use in Joget

Use this in Workflow Builder, Form Builder post-processing, Userview actions, or a BeanShell tool that runs before opening a dashboard/report.

Full Code

import java.sql.Connection;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import javax.sql.DataSource;
import org.joget.apps.app.service.AppUtil;
import org.joget.commons.util.LogUtil;
import org.joget.commons.util.UuidGenerator;

public void rebuildReportSummary() {
    Connection con = null;
    PreparedStatement selectPs = null;
    PreparedStatement insertPs = null;
    ResultSet rs = null;

    String requester = "#form.report_filter.requester#";
    String status = "#form.report_filter.status#";

    try {
        DataSource ds = (DataSource) AppUtil.getApplicationContext().getBean("setupDataSource");
        con = ds.getConnection();

        con.prepareStatement("delete from app_fd_report_summary").executeUpdate();

        StringBuilder sql = new StringBuilder();
        sql.append("select count(*) as total_count, ");
        sql.append("case when c_status is null or c_status = '' then 'Blank Record' else c_status end as status_label ");
        sql.append("from app_fd_request_data ");

        boolean hasRequester = requester != null && !requester.trim().isEmpty();
        boolean hasStatus = status != null && !status.trim().isEmpty();

        if (hasRequester || hasStatus) {
            sql.append("where ");
        }
        if (hasRequester) {
            sql.append("c_requester = ? ");
        }
        if (hasStatus) {
            sql.append(hasRequester ? "and " : "");
            sql.append("c_status = ? ");
        }

        sql.append("group by case when c_status is null or c_status = '' then 'Blank Record' else c_status end ");
        sql.append("order by status_label");

        selectPs = con.prepareStatement(sql.toString());
        int index = 1;
        if (hasRequester) {
            selectPs.setString(index++, requester);
        }
        if (hasStatus) {
            selectPs.setString(index++, status);
        }

        rs = selectPs.executeQuery();
        insertPs = con.prepareStatement("insert into app_fd_report_summary (id, c_count, c_status) values (?, ?, ?)");

        UuidGenerator uuid = UuidGenerator.getInstance();
        while (rs.next()) {
            insertPs.setString(1, uuid.getUuid());
            insertPs.setInt(2, rs.getInt("total_count"));
            insertPs.setString(3, rs.getString("status_label"));
            insertPs.executeUpdate();
        }
    } catch (Exception e) {
        LogUtil.error("dynamic-filter-report", e, "Failed to rebuild report summary.");
    } finally {
        try { if (rs != null) rs.close(); } catch (Exception e) { }
        try { if (selectPs != null) selectPs.close(); } catch (Exception e) { }
        try { if (insertPs != null) insertPs.close(); } catch (Exception e) { }
        try { if (con != null) con.close(); } catch (Exception e) { }
    }
}

rebuildReportSummary();

Example Use Cases

Build dashboard summary rows from dynamic filters.
Refresh chart data before a report page opens.
Group workflow records by status, category, department, or requester.
Prepare a lightweight reporting table for datalists.

Customization Tips

Replace pp_fd_request_data with your source form table.
Replace pp_fd_report_summary with your reporting table.
Add more optional filters by following the same hasFilter pattern.
Avoid TRUNCATE when database permissions are limited; DELETE is easier to run in most Joget setups.
For multi-user reports, add a session/user key so one user does not overwrite another user's summary data.

Key Benefits

Keeps report filtering server-side.
Uses safer SQL parameters.
Makes chart/datalist data easier to consume.
Avoids hard-coded filter combinations.

Security Note

Do not publish real table names, field IDs, requester names, or SQL tied to a private business process. Keep public examples generic and map them privately in your Joget app.

Final Thoughts

Dynamic filtering is easier to maintain when the SQL is built carefully and parameters are used consistently. This pattern keeps the report logic flexible without turning the query into unsafe string concatenation.

📎 Send Joget Emails with File Attachments Using BeanShell

Explorer — Fri, 29 May 2026 14:44:48 +0000

Overview

Joget can send notification emails through its built-in email tool, but some projects need to call an external email API and include files uploaded or generated inside Joget. This pattern reads a Joget-managed file, converts it to Base64, builds a JSON payload, and sends it to an email API.

The example below is sanitized with generic field IDs, form table names, API variables, and recipient logic.

How It Works

Resolve recipients from a Joget participant or direct email list.
Read an uploaded/generated file using FileUtil.getFile.
Validate the file extension before attaching it.
Convert the file bytes to Base64.
Send the email payload to an external API using HttpURLConnection.
Close streams and disconnect the HTTP connection in inally.

Where to Use in Joget

Use this in Workflow Builder as a BeanShell Tool after a document is generated, a request is approved, or a certificate/report is ready to send.

Full Code

import java.io.BufferedReader;
import java.io.File;
import java.io.InputStreamReader;
import java.io.OutputStream;
import java.net.HttpURLConnection;
import java.net.URL;
import java.nio.charset.StandardCharsets;
import java.nio.file.Files;
import java.util.Base64;
import org.joget.apps.app.model.AppDefinition;
import org.joget.apps.app.service.AppUtil;
import org.joget.apps.form.service.FileUtil;
import org.joget.commons.util.LogUtil;
import org.joget.workflow.model.WorkflowAssignment;
import org.json.JSONArray;
import org.json.JSONObject;

public boolean isSupportedFileType(String fileName) {
    String[] allowedExtensions = {".pdf", ".png", ".jpg", ".jpeg"};
    String lowerName = fileName == null ? "" : fileName.toLowerCase();
    for (String ext : allowedExtensions) {
        if (lowerName.endsWith(ext)) {
            return true;
        }
    }
    return false;
}

public void addAttachment(JSONArray attachments, String fileName, String formTableName, String recordId) {
    try {
        if (!isSupportedFileType(fileName)) {
            LogUtil.warn("email-attachment", "Skipped unsupported file type: " + fileName);
            return;
        }

        File file = FileUtil.getFile(fileName, formTableName, recordId);
        if (file == null || !file.exists() || !file.isFile()) {
            LogUtil.warn("email-attachment", "File not found: " + fileName);
            return;
        }

        byte[] fileBytes = Files.readAllBytes(file.toPath());
        String base64 = Base64.getEncoder().encodeToString(fileBytes);

        JSONObject attachment = new JSONObject();
        attachment.put("name", fileName);
        attachment.put("bytes", base64);
        attachment.put("type", fileName.toLowerCase().endsWith(".pdf") ? "application/pdf" : "application/octet-stream");
        attachments.put(attachment);
    } catch (Exception e) {
        LogUtil.error("email-attachment", e, "Failed to process attachment: " + fileName);
    }
}

public Object execute(WorkflowAssignment assignment, AppDefinition appDef) {
    String apiUrl = "#appVariable.email_api_url#";
    String toParticipantId = "requester";
    String toSpecific = "";
    String cc = "";
    String bcc = "";

    String subject = "Request Completed - #form.service_request.request_no#";
    String htmlContent = "<p>Dear User,</p>"
            + "<p>Your request <strong>#form.service_request.request_no#</strong> has been completed.</p>"
            + "<p>Please find the generated document attached.</p>";

    JSONArray recipients = new JSONArray();
    Object emailObject = AppUtil.getEmailList(toParticipantId, toSpecific, assignment, appDef);
    String[] emailArray = emailObject.toString().replace("[", "").replace("]", "").split(",");
    for (String email : emailArray) {
        email = email.trim();
        if (!email.isEmpty()) {
            recipients.put(email);
        }
    }

    JSONArray attachments = new JSONArray();
    addAttachment(attachments, "Generated Document.pdf", "service_request", "#form.service_request.id#");

    JSONObject payloadJson = new JSONObject();
    payloadJson.put("recipients", recipients);
    payloadJson.put("cc", new JSONArray());
    payloadJson.put("bcc", new JSONArray());
    payloadJson.put("subject", subject);
    payloadJson.put("content", htmlContent);
    payloadJson.put("attachments", attachments);

    HttpURLConnection conn = null;
    OutputStream os = null;
    BufferedReader br = null;
    try {
        URL url = new URL(apiUrl);
        conn = (HttpURLConnection) url.openConnection();
        conn.setRequestMethod("POST");
        conn.setRequestProperty("Content-Type", "application/json; charset=UTF-8");
        conn.setDoOutput(true);

        os = conn.getOutputStream();
        byte[] input = payloadJson.toString().getBytes(StandardCharsets.UTF_8);
        os.write(input, 0, input.length);
        os.flush();

        br = new BufferedReader(new InputStreamReader(conn.getInputStream(), "UTF-8"));
        StringBuilder response = new StringBuilder();
        String line;
        while ((line = br.readLine()) != null) {
            response.append(line);
        }
        LogUtil.info("email-api", "Response: " + response.toString());
    } catch (Exception e) {
        LogUtil.error("email-api", e, "Failed to send email with attachment.");
    } finally {
        try { if (br != null) br.close(); } catch (Exception e) { }
        try { if (os != null) os.close(); } catch (Exception e) { }
        if (conn != null) conn.disconnect();
    }
    return null;
}

return execute(workflowAssignment, appDef);

Example Use Cases

Send generated PDFs after workflow approval.
Attach uploaded documents to a notification email.
Send service-completion certificates through a central email API.
Add images or PDFs to escalation emails.

Customization Tips

Store the API endpoint in an app variable like email_api_url.
Keep allowed extensions strict and small.
Avoid logging full payloads because attachments are Base64 encoded.
Use generic form table names in public examples and real table names only inside your private environment.
Add API authentication headers if your email service requires a token.

Key Benefits

Works with Joget-managed uploaded files.
Keeps attachment handling reusable.
Avoids hard-coded file-system paths.
Sends structured JSON to a central email service.

Security Note

Never publish real email addresses, API URLs, tokens, table names, record IDs, or generated Base64 payloads. Treat attachment payloads as sensitive because they may contain private documents.

Final Thoughts

This approach is useful when Joget needs to integrate with a shared notification service while still using files stored in Joget forms.

⬇️ Download Joget Enterprise Versions Safely

Explorer — Fri, 29 May 2026 13:29:22 +0000

Overview

Joget Enterprise installers and archives are available from official Joget download locations. For most users, the main Download page is the safest starting point. For older versions or exact enterprise builds, the public enterprise download index can help you locate a specific installer.

Official references checked on 2026-05-29:

Joget Download page: https://www.joget.org/download/
Enterprise download index: https://download.joget.org/enterprise/

How It Works

Use the official Joget Download page for the normal supported download flow.
Use the Enterprise index only when you need a specific version or platform archive.
Pick the correct platform: Windows installer or Linux/Mac archive.
Prefer stable release builds over beta, preview, or RC builds for production.
Keep the downloaded filename and version in your deployment notes.

Where to Use in Joget

This is an installation and upgrade planning topic for administrators, DevOps engineers, and developers maintaining Joget environments.

Full Code

There is no application code for this topic. The useful part is the version-selection checklist.

1. Open https://www.joget.org/download/
2. Choose Community or Enterprise Edition.
3. Choose Windows or Linux/Mac.
4. For a specific Enterprise build, open https://download.joget.org/enterprise/
5. Search for the required major/minor version.
6. Avoid BETA, PREVIEW, and RC builds for production unless you are testing.
7. Record the filename, version, date, and target server before installing.

At the time this guide was checked, the Enterprise index listed these recent stable Joget DX 9 files:

Linux/Mac: joget-enterprise-linux-9.0.7.tar.gz    2026-05-14 04:59    390M
Windows:   joget-enterprise-setup-9.0.7.exe       2026-05-14 05:00    472M

The same index also contains older 7.x, 8.x, and 8.2.x builds, plus preview builds for testing.

Example Use Cases

Downloading a matching version for a staging server.
Finding an older installer for rollback testing.
Preparing an upgrade path from Joget DX 7 or DX 8 to DX 9.
Recording exact installer filenames for audit or support tickets.

Customization Tips

Keep installers in an internal artifact repository after download.
Record checksums if your organization requires release verification.
Test upgrades on staging before touching production.
Read change logs before upgrading major versions.
Use stable builds for production and preview builds only for evaluation.

Key Benefits

Helps avoid downloading from unofficial mirrors.
Makes version selection more deliberate.
Supports repeatable installation and rollback planning.
Gives developers and administrators one clear place to start.

Security Note

Only download Joget installers from official Joget domains. Do not share Enterprise license files, private plugins, database backups, or production configuration while documenting installation steps.

Final Thoughts

A good Joget installation starts before the installer runs. Pick the right edition, version, and platform, then document the exact file used so future upgrades and support work are easier.

🐳 Advanced Joget Docker Setup with MariaDB, Custom Ports, and Volumes

Explorer — Fri, 29 May 2026 13:29:19 +0000

Overview

Docker is one of the quickest ways to run Joget for development, testing, demos, and repeatable local environments. This guide starts with a simple MySQL setup, then adds a practical advanced example using Joget Enterprise, MariaDB, custom ports, SSL-related mounts, health checks, memory limits, and persistent volumes.

Official references used for this guide:

Docker Engine install docs: https://docs.docker.com/engine/install/
Joget Community image: https://hub.docker.com/r/jogetworkflow/joget-community
Joget Enterprise image: https://hub.docker.com/r/jogetworkflow/joget-enterprise
Joget download/get-started page: https://www.joget.org/download/

How It Works

Docker runs MySQL or MariaDB in one container.
Joget runs in another container.
Joget connects to MySQL using container networking.
Docker volumes preserve the database and Joget wflow files.
Port 8080 exposes Joget in the browser.

Where to Use in Joget

This is an installation and DevOps topic. Use it when preparing a local developer environment, test server, demo machine, or repeatable sandbox.

Full Code

Create a .env file:

MYSQL_ROOT_PASSWORD=change-this-root-password
MYSQL_DATABASE=jwdb
MYSQL_USER=joget
MYSQL_PASSWORD=change-this-joget-password

Create docker-compose.yml:

services:
  jogetdb:
    image: mysql:8.0
    container_name: jogetdb
    restart: unless-stopped
    environment:
      MYSQL_ROOT_PASSWORD: ${MYSQL_ROOT_PASSWORD}
      MYSQL_DATABASE: ${MYSQL_DATABASE}
      MYSQL_USER: ${MYSQL_USER}
      MYSQL_PASSWORD: ${MYSQL_PASSWORD}
    command: --character-set-server=utf8mb4 --collation-server=utf8mb4_unicode_ci
    volumes:
      - jogetdb_data:/var/lib/mysql

  joget:
    image: jogetworkflow/joget-community
    container_name: joget
    restart: unless-stopped
    depends_on:
      - jogetdb
    ports:
      - "8080:8080"
    environment:
      MYSQL_HOST: jogetdb
      MYSQL_PORT: 3306
      MYSQL_DATABASE: ${MYSQL_DATABASE}
      MYSQL_USER: ${MYSQL_USER}
      MYSQL_PASSWORD: ${MYSQL_PASSWORD}
    volumes:
      - joget_wflow:/opt/joget/wflow

volumes:
  jogetdb_data:
  joget_wflow:

Start Joget:

docker compose up -d

Open Joget:

http://localhost:8080/jw

Check logs:

docker compose logs -f joget

Stop the environment:

docker compose down

Advanced Example: Joget Enterprise on Custom Ports

For a more practical server-style setup, you may want Joget Enterprise running on HTTPS port 8443, MariaDB running on a custom internal port like 3309, persistent volumes, custom Tomcat configuration, and a database health check before Joget starts.

Create a .env file:

JOGET_IMAGE_TAG=your-joget-version
MYSQL_ROOT_PASSWORD=change-this-root-password
MYSQL_DATABASE=jwdb
MYSQL_USER=joget
MYSQL_PASSWORD=change-this-joget-password
JOGET_XMS=14G
JOGET_XMX=14G

Create an advanced docker-compose.yml:

version: "2.4"

services:
  joget:
    container_name: jogetapp
    image: jogetworkflow/joget-enterprise:${JOGET_IMAGE_TAG}
    restart: unless-stopped
    environment:
      - MYSQL_HOST=jogetdb
      - MYSQL_DATABASE=${MYSQL_DATABASE}
      - MYSQL_PORT=3309
      - MYSQL_USER=${MYSQL_USER}
      - MYSQL_PASSWORD=${MYSQL_PASSWORD}
      - CATALINA_OPTS=-Xms${JOGET_XMS} -Xmx${JOGET_XMX}
    volumes:
      - jogetdata:/opt/joget/wflow
      - ./server.xml:/opt/joget/apache-tomcat/conf/server.xml:ro
      - ./tomcat.sh:/opt/joget/tomcat.sh:ro
      - ./joget-keystore.keystore:/opt/joget/joget-keystore.keystore:ro
      - ./host.conf:/etc/host.conf:ro
      - ./web.xml:/opt/joget/apache-tomcat/webapps/jw/WEB-INF/web.xml:ro
    networks:
      - joget-backend
    ports:
      - "8443:8443"
    depends_on:
      jogetdb:
        condition: service_healthy
    mem_limit: 17g

  jogetdb:
    container_name: jogetdb
    image: mariadb:10.11
    restart: unless-stopped
    environment:
      - MYSQL_ROOT_PASSWORD=${MYSQL_ROOT_PASSWORD}
      - MYSQL_DATABASE=${MYSQL_DATABASE}
      - MYSQL_USER=${MYSQL_USER}
      - MYSQL_PASSWORD=${MYSQL_PASSWORD}
    ports:
      - "3309:3309"
    command: --port=3309
    volumes:
      - mysqldata:/var/lib/mysql
      - ./my.cnf:/etc/mysql/conf.d/my.cnf:ro
    networks:
      - joget-backend
    healthcheck:
      test: ["CMD", "mariadb-admin", "ping", "-h", "localhost", "-P", "3309"]
      start_period: 30s
      timeout: 20s
      retries: 10

volumes:
  jogetdata:
  mysqldata:

networks:
  joget-backend:

Run it:

docker compose up -d

Open Joget:

https://localhost:8443/jw

In this example, the MariaDB container listens internally on 3309, so Joget also uses MYSQL_PORT=3309. The host port mapping "3309:3309" is useful when you need to connect from a database client on the host machine. If only Joget needs database access, you can remove that ports block and keep the database private inside the Docker network.

For production-like setups, avoid latest, pin a tested Joget image tag, use strong secrets, keep mounted config files under source control only when they do not contain secrets, and confirm your Enterprise licensing requirements.

Example Use Cases

Local Joget development environment.
Demo instance for testing apps before importing to a server.
Temporary sandbox for plugin testing.
Repeatable onboarding setup for new developers.

Customization Tips

Use jogetworkflow/joget-enterprise when you have Enterprise licensing and need Enterprise features.
Check Docker Hub for available image tags before pinning a production version.
Keep database passwords in .env or your deployment secret manager.
Back up both the database volume and the Joget wflow volume.
Use read-only mounts (:ro) for config files that the container should not modify.
Expose the database port only when host tools need to connect to it.
For production, review networking, TLS, database backup, monitoring, and license requirements properly.

Key Benefits

Fast setup compared to manual installation.
Easy reset and rebuild for development.
Persistent volumes protect local data between restarts.
Simple migration from local testing to managed container platforms.

Security Note

Do not commit real .env files. Do not expose ports like 8080 or 8443 publicly without a reverse proxy, TLS, authentication hardening, and server-level access controls.

Final Thoughts

Docker is a clean way to keep Joget installation steps repeatable. For production, treat this compose file as a starting point, then harden secrets, backups, TLS, and monitoring for your environment.

🧹 Prevent Memory Leaks in Joget BeanShell Scripts

Explorer — Fri, 29 May 2026 13:27:04 +0000

Overview

When a Joget BeanShell script runs once, a small resource leak may not look serious. When the same script runs inside workflow tools, schedulers, post-processing scripts, or high-traffic forms, unclosed resources can slowly exhaust database connections, mail sessions, streams, memory, or thread context.

This article focuses on practical leak prevention for Joget developers writing BeanShell scripts.

How It Works

Most issues are not classic Java heap leaks. They are usually resource leaks:

Database connections not closed.
ResultSet or PreparedStatement objects left open.
Mail folders, stores, files, streams, or HTTP responses not closed.
Workflow thread user changed and not restored.
Large result sets loaded into memory without paging.
Service/plugin lookups repeated inside loops.

The fix is to keep resource scope small and always clean up in inally.

Where to Use in Joget

Use this pattern in Workflow Builder, Form Builder, Userview actions, schedulers, BeanShell tools, validators, and post-processing scripts.

Full Code

import java.sql.Connection;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import javax.sql.DataSource;
import org.joget.apps.app.service.AppUtil;
import org.joget.commons.util.LogUtil;
import org.joget.workflow.model.service.WorkflowUserManager;

Connection con = null;
PreparedStatement ps = null;
ResultSet rs = null;
String originalUser = null;

try {
    WorkflowUserManager workflowUserManager = (WorkflowUserManager) AppUtil.getApplicationContext().getBean("workflowUserManager");
    originalUser = workflowUserManager.getCurrentUsername();

    // Use a service account only when the script really needs elevated access.
    workflowUserManager.setCurrentThreadUser("system");

    DataSource ds = (DataSource) AppUtil.getApplicationContext().getBean("setupDataSource");
    con = ds.getConnection();

    ps = con.prepareStatement(
        "select id, c_request_no, c_status " +
        "from app_fd_request " +
        "where c_status = ?"
    );
    ps.setString(1, "Pending");

    rs = ps.executeQuery();
    while (rs.next()) {
        String requestId = rs.getString("id");
        String requestNo = rs.getString("c_request_no");
        String status = rs.getString("c_status");

        LogUtil.info("cleanup-example", requestId + " | " + requestNo + " | " + status);
    }
} catch (Exception e) {
    LogUtil.error("cleanup-example", e, "Error while running BeanShell script.");
} finally {
    try { if (rs != null) rs.close(); } catch (Exception e) { LogUtil.warn("cleanup-example", "Could not close ResultSet."); }
    try { if (ps != null) ps.close(); } catch (Exception e) { LogUtil.warn("cleanup-example", "Could not close PreparedStatement."); }
    try { if (con != null) con.close(); } catch (Exception e) { LogUtil.warn("cleanup-example", "Could not close Connection."); }

    try {
        WorkflowUserManager workflowUserManager = (WorkflowUserManager) AppUtil.getApplicationContext().getBean("workflowUserManager");
        workflowUserManager.setCurrentThreadUser(originalUser);
    } catch (Exception e) {
        LogUtil.warn("cleanup-example", "Could not restore workflow user context.");
    }
}

Example Use Cases

Workflow tools that read or update many form rows.
Validators that query related records.
Email polling scripts.
Scheduled cleanup jobs.
Integration scripts that call HTTP APIs.
Approval-history or audit-log insert scripts.

Customization Tips

Prefer Joget's setupDataSource over hard-coded JDBC credentials.
Use PreparedStatement instead of string-concatenated SQL.
Close ResultSet, PreparedStatement, and Connection in reverse order.
Restore WorkflowUserManager current thread user in inally.
Avoid storing large lists in memory when the script can process rows one at a time.
For big jobs, process records in batches and log progress.
Do not keep static collections or cached row data inside BeanShell scripts unless you fully understand the lifecycle.

Key Benefits

Reduces database connection exhaustion.
Keeps workflow tools more stable under load.
Makes scripts easier to debug when errors happen.
Prevents user-context leakage between script executions.
Helps avoid unnecessary heap growth from large in-memory objects.

Security Note

Memory safety and security often overlap. Avoid hard-coded database credentials, tokens, URLs, and private table names in scripts that may be shared. Keep examples generic and use platform-managed configuration wherever possible.

Final Thoughts

Increasing heap memory can hide a problem for a while, but it does not fix leaking resources. In Joget BeanShell scripts, the best habit is simple: open late, close early, and always clean up in inally.

🏦 Generate Bank Payment Text Files in Joget with BeanShell

Explorer — Fri, 29 May 2026 13:25:30 +0000

Overview

Generating a bank payment text file from Joget is a common enterprise workflow requirement. A form captures the payment details, the BeanShell tool validates the values, pulls invoice rows from the Joget database, and writes a text file to a secure shared folder for the bank or finance integration team.

This version uses generic field IDs, table names, paths, and placeholders so the pattern is safe to reuse publicly.

How It Works

Read payment fields from Joget hash variables.
Validate important values before creating the file.
Query invoice rows using a parameterized SQL statement.
Write header, transaction, and invoice lines into a text file.
Close the database, result set, and writer in inally to avoid resource leaks.

Where to Use in Joget

Use this in Workflow Builder as a BeanShell Tool after the payment request is approved and ready for export.

Full Code

import java.io.File;
import java.io.PrintWriter;
import java.sql.Connection;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.time.LocalDateTime;
import java.time.format.DateTimeFormatter;
import java.util.regex.Pattern;
import javax.sql.DataSource;
import org.joget.apps.app.service.AppUtil;
import org.joget.commons.util.LogUtil;

public void createPaymentTextFile() {
    DateTimeFormatter fileDate = DateTimeFormatter.ofPattern("yyyyMMdd");
    DateTimeFormatter fileTime = DateTimeFormatter.ofPattern("HHmmss");
    LocalDateTime now = LocalDateTime.now();

    String organizationCode = "#form.payment_request.organization_code#";
    String fileReference = "#form.payment_request.file_reference#";
    String notificationEmail = "#form.payment_request.notification_email#";
    String debitAccount = "#form.payment_request.debit_account#";
    String debitCurrency = "#form.payment_request.currency_code#";
    String debitCountry = "#form.payment_request.debit_country#";
    String orderingPartyName = cleanText("#form.payment_request.ordering_party_name#");
    String orderingPartyAddress = cleanAddress("#form.payment_request.ordering_party_address#");
    String orderingPartyBic = "#form.payment_request.ordering_party_bic#";

    String beneficiaryEmail = "#form.payment_request.beneficiary_email#";
    String beneficiaryIban = "#form.payment_request.beneficiary_iban#";
    String beneficiaryName = cleanText("#form.payment_request.beneficiary_name#");
    String beneficiaryAddress = cleanAddress("#form.payment_request.beneficiary_address#");
    String beneficiaryBankAddress = cleanAddress("#form.payment_request.beneficiary_bank_address#");
    String beneficiaryBic = "#form.payment_request.beneficiary_bic#";
    String beneficiaryCountry = "#form.payment_request.beneficiary_country#";
    String beneficiaryCity = cleanText("#form.payment_request.beneficiary_city#");

    String paymentMode = "#form.payment_request.payment_mode#";
    String paymentAmount = "#form.payment_request.payment_amount#";
    String paymentDetails = cleanPaymentDetails("#form.payment_request.payment_details#");
    String chargeType = "#form.payment_request.charge_type#";
    String purposeCode = "#form.payment_request.purpose_code#";
    String paymentType = "#form.payment_request.payment_type#";
    String invoiceReference = "#form.payment_request.invoice_reference#";
    String voucherNumber = "#form.payment_request.voucher_number#";

    if (!isValidEmail(beneficiaryEmail)
            || !isValidEmail(notificationEmail)
            || !isAlphaNumeric(fileReference, 15)
            || !isAlphaNumeric(debitAccount, 23)
            || !isCode(debitCurrency, 3)
            || !isCode(debitCountry, 3)
            || !isCode(paymentMode, 2)
            || !isAlphaNumeric(beneficiaryIban, 40)
            || !isCode(beneficiaryCountry, 3)
            || !isNumeric(invoiceReference, 10)) {
        LogUtil.warn("payment-export", "Payment text file was not created because validation failed.");
        return;
    }

    String fileName = organizationCode + "_PAYMENT_" + fileDate.format(now) + "_" + fileTime.format(now) + ".txt";
    File outputFile = new File("\\\\your-file-server\\secure-payment-output\\" + fileName);

    Connection con = null;
    PreparedStatement ps = null;
    ResultSet rs = null;
    PrintWriter writer = null;

    try {
        DataSource ds = (DataSource) AppUtil.getApplicationContext().getBean("setupDataSource");
        con = ds.getConnection();

        ps = con.prepareStatement(
            "select c_invoice_number, c_invoice_date, c_description, c_invoice_id, c_amount " +
            "from app_fd_payment_invoice where c_payment_request_id = ?"
        );
        ps.setString(1, invoiceReference);
        rs = ps.executeQuery();

        writer = new PrintWriter(outputFile, "UTF-8");

        writer.println("FILE_HEADER," + fileReference + "," + fileDate.format(now) + "," + notificationEmail);
        writer.println("TRANSACTION_HEADER," + fileReference + "," + debitAccount + "," + debitCurrency + "," + debitCountry + "," + orderingPartyName + "," + orderingPartyAddress + "," + orderingPartyBic);
        writer.println("TRANSACTION_DETAIL," + fileReference + "," + beneficiaryName + "," + beneficiaryEmail + "," + beneficiaryIban + "," + paymentMode + "," + paymentAmount + "," + beneficiaryAddress + "," + beneficiaryCountry + "," + beneficiaryBankAddress + "," + beneficiaryBic + "," + beneficiaryCity + "," + paymentDetails + "," + chargeType + "," + purposeCode + "," + paymentType + "," + invoiceReference);

        while (rs.next()) {
            writer.println("INVOICE_INFO," + invoiceReference + "," + rs.getString("c_amount") + "," + rs.getString("c_invoice_number") + "," + rs.getString("c_invoice_date") + "," + cleanPaymentDetails(rs.getString("c_description")) + "," + rs.getString("c_invoice_id") + "," + voucherNumber);
        }

        LogUtil.info("payment-export", "Payment text file created: " + fileName);
    } catch (Exception e) {
        LogUtil.error("payment-export", e, "Unable to create payment text file.");
    } finally {
        try { if (writer != null) writer.close(); } catch (Exception e) { }
        try { if (rs != null) rs.close(); } catch (Exception e) { }
        try { if (ps != null) ps.close(); } catch (Exception e) { }
        try { if (con != null) con.close(); } catch (Exception e) { }
    }
}

public String cleanText(String value) {
    return value == null ? "" : value.replaceAll("[^a-zA-Z0-9\\s]", "").trim();
}

public String cleanAddress(String value) {
    return value == null ? "" : value.replaceAll("[^\\w\\-\\s:+_]", " ").trim();
}

public String cleanPaymentDetails(String value) {
    return value == null ? "" : value.replaceAll("[^a-zA-Z0-9 _-]", " ").trim();
}

public boolean isValidEmail(String value) {
    return value != null && Pattern.compile("^[\\w!#$%&'*+/=?`{|}~^-]+(?:\\.[\\w!#$%&'*+/=?`{|}~^-]+)*@(?:[a-zA-Z0-9-]+\\.)+[a-zA-Z]{2,6}$").matcher(value.trim()).matches();
}

public boolean isAlphaNumeric(String value, int maxLength) {
    return value != null && Pattern.compile("^[a-zA-Z0-9]{1," + maxLength + "}$").matcher(value.trim()).matches();
}

public boolean isCode(String value, int maxLength) {
    return value != null && Pattern.compile("^[A-Z]{1," + maxLength + "}$").matcher(value.trim()).matches();
}

public boolean isNumeric(String value, int maxLength) {
    return value != null && Pattern.compile("^[0-9]{1," + maxLength + "}$").matcher(value.trim()).matches();
}

createPaymentTextFile();

Example Use Cases

Export approved payment requests to a secured network folder.
Generate bank-upload text files from Joget form data.
Create finance integration files with header, detail, and invoice sections.
Validate payment fields before file generation.

Customization Tips

Replace pp_fd_payment_invoice with your sanitized Joget child-table name.
Replace the form hash variable IDs with your own form field IDs.
Update the output line format to match your bank or middleware specification.
Store file locations and connection settings outside the script when possible.
Keep the output folder restricted to the finance or integration service account.

Key Benefits

Keeps payment export logic inside the workflow.
Prevents invalid data from reaching the bank file.
Uses prepared statements for safer SQL.
Separates header, transaction, and invoice lines clearly.
Closes resources properly after the file is generated.

Security Note

Do not publish or hard-code real server paths, IP addresses, database usernames, passwords, table names, account numbers, bank identifiers, or organization-specific field IDs. Use Joget-managed data sources, environment variables, credentials managed by your platform, or protected plugin properties.

Final Thoughts

This approach is useful when Joget must prepare a structured payment file for another system. Keep the public example generic, then map the placeholders to your real finance fields only inside your private environment.

📥 Customize Joget Inbox Lists with JavaScript

Explorer — Fri, 29 May 2026 13:17:01 +0000

1. Overview

This article shows how to customize a Joget inbox or datalist using JavaScript. The script moves row action columns, localizes filter labels and buttons, adds clear icons to text filters, and formats status cells with CSS-friendly labels.

2. How It Works

Move action columns to the first position for easier access.
Update filter placeholders using Joget hash variables.
Rename inbox action links such as approve/reject or resubmission.
Add clear buttons beside text filters.
Convert status text into styled HTML labels.
Prevent browser context-menu actions where the UI requires a locked-down experience.

3. Where to Use in Joget

Userview: Inbox menu or datalist menu custom JavaScript.
Datalist Builder: list UI customization for filters and row actions.
Workflow Inbox: approval list screens that need clearer actions and translated labels.

4. Full Code

<script>
  $(document).ready(function () {

    //$('.row_action:odd').addClass('sticky-important');
    //$('.row_action:even').addClass('sticky-important-first');

    $('.row_action,.column_inboxAction ').each(function () {
      $(this).insertBefore($(this).parent().children().eq(0));
    });

    $("input[name$='-fn_c_request_id']").attr("placeholder", "#beanshell.locale_messages[key=id]#");
    $("input[name$='-fn_c_request_creator']").attr("placeholder", "#beanshell.locale_messages[key=applicant]#");
    $("input[name$='-fn_requester_name']").attr("placeholder", "#beanshell.locale_messages[key=applicant]#");
    $("input[name$='assignmentComplete']").attr("value", "#beanshell.locale_messages[key=submit]#");
    $("input[name$='-fn_id']").attr("placeholder", "#beanshell.locale_messages[key=id]#");
    $("input[name$='-fn_request_comment']").attr("placeholder", "#beanshell.locale_messages[key=request_comment]#");

    $("select[name$='-fn_company'] option.label").text("#beanshell.locale_messages[key=company]#");
    $('select[name$=-fn_business_unit] option.label').text("#beanshell.locale_messages[key=business_unit]#");
    $('select[name$=-fn_target_unit] option.label').text("#beanshell.locale_messages[key=target_unit]#");
    $('select[name$=-fn_request_status] option.label').text("#beanshell.locale_messages[key=request_status]#");
    $('select[name$=-fn_request_type] option.label').text("#beanshell.locale_messages[key=request_type]#");
    $('select[name$=-fn_request_department] option.label').text("#beanshell.locale_messages[key=request_department]#");

    $('select[name$=fn_department_approver] option.label').text("#beanshell.locale_messages[key=department_approver]#");

    $('select[name$=fn_reviewer_user] option.label').text("#beanshell.locale_messages[key=reviewer_user_name]#");

    $('select[name$=-fn_next_approver] option.label').text("#beanshell.locale_messages[key=approver_name]#");

    $('input[name$=-fn_completed_date].from').closest('.filter-cell').find('.dateRangeLabel').text('#beanshell.locale_messages[key=completed_date]#');
    $('input[name$=-fn_target_date].from').closest('.filter-cell').find('.dateRangeLabel').text('#beanshell.locale_messages[key=target_date]#');
    $('input[name$=-fn_created_date].from').closest('.filter-cell').find('.dateRangeLabel').text('#beanshell.locale_messages[key=created_date]#');
    $('input[name$=-fn_dateCreated].from').closest('.filter-cell').find('.dateRangeLabel').text('#beanshell.locale_messages[key=created_date]#');
    //  $('input.datepicker.from.hasDatepicker').attr('placeholder',"#beanshell.locale_messages[key=from]#");
    //  $('input.datepicker.to.hasDatepicker').attr('placeholder',"#beanshell.locale_messages[key=to]#");

    $("input[name$='customSaveAsDraft']").attr("value", "#beanshell.locale_messages[key=save_as_draft]#");
    $("input[value=Show]").val("#beanshell.locale_messages[key=show]#");
    $('button.CRUD_New').text("#beanshell.locale_messages[key=new]#");
    $('button.CRUD_DELETE').text("#beanshell.locale_messages[key=delete]#");
    $('input#submit').val("#beanshell.locale_messages[key=save]#");
    $('button#cancel').text("#beanshell.locale_messages[key=cancel]#");

    $('form#request_approval_form input#assignmentComplete').val("#beanshell.locale_messages[key=decision]#");

    $('table tbody td.column_inboxAction a').each(function () {
      if ($(this).text() != 'Resubmission') {
        $(this).text("#beanshell.locale_messages[key=approve_reject]#")
      } else if ($(this).text() == 'Resubmission') {
        $(this).text("#beanshell.locale_messages[key=resubmission]#")
      }
    });

    $('.filter-cell').each(function () {
      if ($(this).find('input[type=text]').length > 0 && !$(this).find('input[type=text]').hasClass('datepicker')) {
        $(this).append(`
                    <span class="clear" style="
                        position: absolute;
                        top: 6px;
                        width: 0;    
                        height: 0;
                        right: 23px;
                        cursor: pointer;
                    ">
                        <svg xmlns="http://www.w3.org/2000/svg" xmlns:xlink="http://www.w3.org/1999/xlink" xmlns:sketch="http://www.bohemiancoding.com/sketch/ns" width="64px" height="64px" viewBox="0 0 32 32" version="1.1" fill="#000000" style="
                            width: 13px;
                            height: auto;
                        ">
                            <g id="SVGRepo_bgCarrier" stroke-width="0"></g>
                            <g id="SVGRepo_tracerCarrier" stroke-linecap="round" stroke-linejoin="round"></g>
                            <g id="SVGRepo_iconCarrier">
                                <title>cross-circle</title>
                                <desc>Created with Sketch Beta.</desc>
                                <defs></defs>
                                <g id="Page-1" stroke="none" stroke-width="1" fill="none" fill-rule="evenodd" sketch:type="MSPage">
                                    <g id="Icon-Set-Filled" sketch:type="MSLayerGroup" transform="translate(-570.000000, -1089.000000)" fill="#878787">
                                        <path d="M591.657,1109.24 C592.048,1109.63 592.048,1110.27 591.657,1110.66 C591.267,1111.05 590.633,1111.05 590.242,1110.66 L586.006,1106.42 L581.74,1110.69 C581.346,1111.08 580.708,1111.08 580.314,1110.69 C579.921,1110.29 579.921,1109.65 580.314,1109.26 L584.58,1104.99 L580.344,1100.76 C579.953,1100.37 579.953,1099.73 580.344,1099.34 C580.733,1098.95 581.367,1098.95 581.758,1099.34 L585.994,1103.58 L590.292,1099.28 C590.686,1098.89 591.323,1098.89 591.717,1099.28 C592.11,1099.68 592.11,1100.31 591.717,1100.71 L587.42,1105.01 L591.657,1109.24 L591.657,1109.24 Z M586,1089 C577.163,1089 570,1096.16 570,1105 C570,1113.84 577.163,1121 586,1121 C594.837,1121 602,1113.84 602,1105 C602,1096.16 594.837,1089 586,1089 L586,1089 Z" id="cross-circle" sketch:type="MSShapeGroup"></path>
                                    </g>
                                </g>
                            </g>
                        </svg>
                    </span>
                `);
      }
    });

    $('.clear').each(function () {
      $(this).click(function () {
        $(this).siblings('input').val('');
        $('input[type=submit]').trigger('click');
      });
    });

    document.addEventListener('contextmenu', function (event) {
      event.preventDefault();
    });

    let master_object = {
      'Pending External Posting': '#beanshell.locale_messages[key=pending_external_posting]#',
      'Pending with Additional Approver': '#beanshell.locale_messages[key=pending_with_additional_approver]#',
      'Pending with Department Reviewer': '#beanshell.locale_messages[key=pending_with_department_supervisor]#',
      'Pending with Reviewer': '#beanshell.locale_messages[key=pending_with_reviewer_user]#',
      'Pending with Final Approver': '#beanshell.locale_messages[key=pending_with_accounting_approver]#',
      'Reviewer Rejected': '#beanshell.locale_messages[key=reviewer_user_rejected]#',
      'Additional Approver Rejected': '#beanshell.locale_messages[key=additional_approver_rejected]#',
      'External Posting Errors Rejected': '#beanshell.locale_messages[key=external_posting_errors_rejected]#',
      'Department Reviewer Rejected': '#beanshell.locale_messages[key=department_supervisor_rejected]#',
      'Final Approver Rejected': '#beanshell.locale_messages[key=accounting_approver_rejected]#',
      'Approved': '#beanshell.locale_messages[key=approved]#',
      'Withdrawn': '#beanshell.locale_messages[key=withdrawn]#',
      'Re-Apply': '#beanshell.locale_messages[key=re_apply]#',
      'Draft': '#beanshell.locale_messages[key=draft]#'
    };

    $("table tbody td.column_request_status").each(function () {
      let lowerCase_cellText = $(this).text().trim();
      let translated_text = master_object[lowerCase_cellText];

      var cellText = lowerCase_cellText.toLowerCase(); // Convert text to lowercase for case-insensitive comparison
      if (cellText.indexOf("pending") !== -1) {
        $(this).html(`<p class='pending status-css'>${translated_text}</p>`);
      } else if (cellText.indexOf("rejected") !== -1) {
        $(this).html(`<p class='rejected status-css'>${translated_text}</p>`);
      } else if (cellText.indexOf("approved") !== -1) {
        $(this).html(`<p class='approved status-css'>${translated_text}</p>`);
      } else if (cellText.indexOf("draft") !== -1) {
        $(this).html(`<p class='draft status-css'>${translated_text}</p>`);
      } else if (cellText.indexOf("withdrawn") !== -1) {
        $(this).html(`<p class='withdrawn status-css'>${translated_text}</p>`);
      }
    });
  });
</script>

5. Example Use Cases

Moving inbox actions to the left side of the list.
Translating filter placeholders dynamically.
Styling status values such as pending, approved, rejected, withdrawn, and draft.
Adding clear-filter controls to improve usability.

6. Customization Tips

Replace field suffixes with your own datalist filter names.
Add your own status-to-label mapping in the master_object object.
Keep CSS classes such as pending, pproved, and ejected aligned with your theme.
Test the script after datalist column changes because generated column class names can change.

7. Key Benefits

Makes inbox actions easier to find.
Improves multilingual list usability.
Reduces clicks when clearing filters.
Gives workflow statuses a more readable visual style.

8. Security Note

Client-side UI customization should not replace server-side permissions. Use Joget permissions to control who can see or execute inbox actions.

9. Final Thoughts

Small inbox improvements can make repeated approval work much smoother. Keep the JavaScript generic, use locale messages for labels, and avoid hardcoding organization-specific field names in public examples.

🔀 Implement Item-Level Task Delegation in Joget with BeanShell

Explorer — Fri, 29 May 2026 13:16:55 +0000

1. Overview

This article shows a Joget BeanShell pattern for item-level task delegation. Instead of reassigning an entire process blindly, the script reads selected delegation rows, updates workflow variables, reassigns the active activity, and writes an audit trail.

2. How It Works

Read selected delegation rows from a grid or hidden JSON field.
Resolve the current assignee, target user, activity ID, and parent record ID.
Update routing variables for the selected activity.
Reassign the activity with workflowManager.assignmentReassign(...).
Remove extra assignees when the activity currently has multiple users.
Insert an audit row so reassignment history is traceable.

3. Where to Use in Joget

Workflow Builder: Tool or store binder logic for reassignment forms.
Form Builder: item-level delegation screen with a grid of selected activities.
Userview: admin-only reassignment pages.

4. Full Code

import org.joget.apps.form.model.FormRowSet;
import org.joget.apps.form.model.FormRow;
import org.joget.apps.app.service.AppUtil;
import java.sql.Connection;
import java.sql.Statement;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import javax.sql.DataSource;
import org.joget.commons.util.LogUtil;
import org.joget.workflow.model.service.WorkflowManager;
import org.joget.workflow.model.WorkflowAssignment;
import org.joget.workflow.model.service.WorkflowUserManager;
import org.json.JSONArray;
import org.json.JSONObject;
import java.util.Collection;
import java.util.ArrayList;




public void insertAuditTrail(
        String recordId,
        String processName,
        String activityName,
        String assignedUsers,
        String activityId) {

    Connection con = null;
    PreparedStatement stmt = null;

    try {
        DataSource ds = (DataSource) AppUtil.getApplicationContext().getBean("setupDataSource");
        con = ds.getConnection();

        if (!con.isClosed()) {

            String id = java.util.UUID.randomUUID().toString();
            String now = new java.text.SimpleDateFormat("yyyy-MM-dd HH:mm:ss")
                    .format(new java.util.Date());

            // String sql =
            //     "INSERT INTO app_fd_assignment_audit " +
            //     "(id, c_generic_field, c_generic_field, c_generic_field, dateCreated, c_generic_field) " +
            //     "VALUES (?, ?, ?, ?, ?, ?)";

            String sql =
                "INSERT INTO app_fd_assignment_audit " +
                "(id, c_generic_field, c_generic_field, c_generic_field, " +
                "dateCreated, c_generic_field, " +
                "c_generic_field, c_generic_field, c_generic_field, c_generic_field) " +
                "VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?)";

            stmt = con.prepareStatement(sql);

            FormRow row = rows.get(0);
            String doneByUsername = row.get("requesting_user");
            String doneByFullName = row.get("requesting_user_name");
            String notes = row.get("notes");


            String actionDetails  = "Reassigned";

            int i = 1;
            stmt.setString(i++, id);
            stmt.setString(i++, recordId);
            stmt.setString(i++, processName);
            stmt.setString(i++, activityName);
            stmt.setString(i++, now);
            stmt.setString(i++, assignedUsers);
            stmt.setString(i++, actionDetails);      // Reassigned
            stmt.setString(i++, doneByUsername);     // Done by (username)
            stmt.setString(i++, doneByFullName);     // Done by (full name)
            stmt.setString(i++, notes);  


            stmt.executeUpdate();

            WorkflowManager wm =
                (WorkflowManager) AppUtil.getApplicationContext().getBean("workflowManager");

            wm.activityVariable(activityId, "history_uuid", id);
        }

    } catch (Exception e) {
        LogUtil.error("Bulk Reassign Audit", e, "Error inserting audit trail");
    } finally {
        try { if (stmt != null) stmt.close(); } catch (Exception e) {}
        try { if (con != null) con.close(); } catch (Exception e) {}
    }
}

public String getActivityName(String activityId) {
    try {
        WorkflowManager wm =
            (WorkflowManager) AppUtil.getApplicationContext().getBean("workflowManager");

        return wm.getActivityById(activityId).getName();
    } catch (Exception e) {
        LogUtil.error("Bulk Reassign Audit", e, "Unable to fetch activity name");
        return activityId;
    }
}



public void removeAssignee(String activityId, String username) {
   Connection con = null;
   Statement stmt = null;

   try {
      DataSource ds = (DataSource) AppUtil.getApplicationContext().getBean("setupDataSource");
      con = ds.getConnection();

      if (!con.isClosed()) {
         LogUtil.info("ExecuteSQL", "Connection to database established successfully.");
         stmt = con.createStatement();

         stmt.executeUpdate("DELETE FROM SHKAssignmentsTable where ActivityId = '" + activityId + "' and ResourceId = '" + username + "'");

         LogUtil.info("Remove Assignee", "SQL statements executed successfully.");
      } else {
         LogUtil.warn("Remove Assignee", "Connection to database failed.");
      }
   } catch (Exception e) {
      LogUtil.error("Remove Assignee", e, "Error executing SQL statements");
   } finally {
      try {
         if (stmt != null) {
            stmt.close();
         }
         if (con != null && !con.isClosed()) {
            con.close();
         }
      } catch (Exception e) {
         LogUtil.error("Remove Assignee", e, "Error closing DB connection");
      }
   }
}

public FormRowSet storeData() {
   WorkflowManager wm = (WorkflowManager) AppUtil.getApplicationContext().getBean("workflowManager");
   WorkflowUserManager wum = (WorkflowUserManager) AppUtil.getApplicationContext().getBean("workflowUserManager");
   FormRow row = rows.get(0);

   String branchCode = row.get("routing_group_code");
   String selectedUser = row.get("target_user");
   String selectedTargetUnit = row.get("target_unit_id");

   try {
      String allReassignJsonArray = row.get("delegation_rows");
      //LogUtil.info("Multiple Reassign", "allReassignJson: " + allReassignJsonArray);

      if (allReassignJsonArray == null || allReassignJsonArray.isEmpty()) {
         //LogUtil.info("Multiple Reassign", "No reassign rows found");
         return null;
      }

      JSONArray allReassignJson = new JSONArray(allReassignJsonArray);

      //LogUtil.info("Multiple Reassign", "allReassignJson: " + allReassignJson.length());

      for (int i = 0; i < allReassignJson.length(); i++) {
         JSONObject reassignJson = allReassignJson.getJSONObject(i);
         String currentAssignee = reassignJson.getString("current_assignee");
         String activityId = reassignJson.getString("activity_id");
         String recordId = reassignJson.getString("record_id");


         // ************************ code for historical data *****************************************

         boolean isRequestProcess = activityId != null && activityId.contains("main_process_key");

         boolean isSecondary RequestProcess = activityId != null && activityId.contains("secondary_process_key");

         String processName = isRequestProcess ? "Main Process" : (isSecondary RequestProcess ? "Secondary Process" : null);

         // *******************************************************************************************

         String currentUser = wum.getCurrentThreadUser();
         wum.setCurrentThreadUser(currentAssignee);
         wum.setCurrentThreadUser(currentUser);



         // 2. Newly added for :: Main Process :: Muscat (Section or Department Changing)
         if (activityId != null && activityId.contains("main_process_key")) {
            wm.activityVariable(activityId, "target_section_code", selectedTargetUnit);
            wm.activityVariable(activityId, "target_unit_id", selectedTargetUnit);
            wm.activityVariable(activityId, "routing_group_code", branchCode);
         }

         //3. newly added for Complain Resercher :: Main Process
         if (activityId != null && activityId.contains("main_process_key") && (activityId.contains("activity_key_1") ||
               activityId.contains("activity_key_2") || activityId.contains("activity_key_3") ||
               activityId.contains("activity_key_4") || activityId.contains("activity_key_5") ||
               activityId.contains("activity_key_6") || activityId.contains("activity_key_7") ||
               activityId.contains("activity_key_8") || activityId.contains("activity_key_9"))) {
            wm.activityVariable(activityId, "assigned_handler", selectedUser);
         }

         // 2. Newly added for :: Secondary Process :: Muscat (Section or Department Changing)
         if (activityId != null && activityId.contains("secondary_process_key")) {
            wm.activityVariable(activityId, "request_type_code", selectedTargetUnit);
            wm.activityVariable(activityId, "routing_group_code", branchCode);
         }

         //newly added for Judicial Officer :: Secondary Process
         if (activityId != null && activityId.contains("secondary_process_key") && (activityId.contains("review_activity_1") ||
               activityId.contains("review_activity_2") || activityId.contains("remarks_after_review_activity_2") ||
               activityId.contains("review_activity_4") || activityId.contains("review_activity_5") ||
               activityId.contains("review_activity_6") || activityId.contains("review_activity_2_and_verification") ||
               activityId.contains("review_activity_8") || activityId.contains("review_activity_5_arrest_2") ||
               activityId.contains("review_activity_5_absent") || activityId.contains("review_activity_11"))) {
            Connection con = null;
            PreparedStatement ps = null;

            try {
               con = AppUtil.getApplicationContext().getBean("setupDataSource", javax.sql.DataSource.class).getConnection();

               if (!con.isClosed()) {

                  String updateQuery = "UPDATE app_fd_related_request SET c_generic_field=? WHERE id=?";

                  ps = con.prepareStatement(updateQuery);
                  ps.setString(1, selectedUser);
                  ps.setString(2, recordId);
                  ps.executeUpdate();
               }

            } catch (SQLException e) {
               LogUtil.info("Error updating inspector handler", e);

            } finally {
               try {
                  if (ps != null) ps.close();
               } catch (Exception e) {}

               try {
                  if (con != null) con.close();
               } catch (Exception e) {}
            }
         }

         if (currentAssignee.contains(",")) {
            String[] users = currentAssignee.split(", ");
            for (int i = 0; i < users.length; i++) {
               if (i == 0) {
                  wm.assignmentReassign("", "", activityId, selectedUser, users[i]);

                  // ** for historical data creation *************
                    if (processName != null) {
                         String activityName = getActivityName(activityId);
                        insertAuditTrail(
                            recordId,
                            processName,
                            activityName,     // activity name (same pattern you already use)
                            selectedUser,   // new current_assignee
                            activityId
                        );
                    }
                    // **********************************************


               } else {
                  removeAssignee(activityId, users[i]); // remove other current_assignees from the activity
               }
            }

         } else {
            wm.assignmentReassign("", "", activityId, selectedUser, currentAssignee);

            // ** for historical data creation *************
            if (processName != null) {

                String activityName = getActivityName(activityId);

                insertAuditTrail(
                    recordId,
                    processName,
                    activityName,     // activity name (same pattern you already use)
                    selectedUser,   // new current_assignee
                    activityId
                );
            }
            // **********************************************

         }
      }

   } catch (Exception e) {
      LogUtil.error("Multiple Reassign", e, "Error executing multiple reassign");
   }

   return rows;
}

return storeData();

5. Example Use Cases

Delegating a specific task item to another user.
Bulk reassignment when an employee is unavailable.
Updating department or section routing for an active activity.
Maintaining a custom reassignment audit trail.

6. Customization Tips

Replace the audit table and field names with your own generic table.
Keep direct workflow table updates limited and well-tested.
Store reassignment reason or notes for audit requirements.
Restrict this action to admin or process-owner roles.

7. Key Benefits

Reassigns only the selected activity items.
Supports multiple current assignees.
Updates workflow variables during reassignment.
Keeps a traceable audit record.

8. Security Note

Task reassignment can change workflow ownership. Protect the form with permissions, avoid exposing internal process keys publicly, and log who performed the delegation.

9. Final Thoughts

This pattern is useful for operational teams that need controlled task delegation. Start with a test activity, verify the audit trail, and only then enable the action for production users.

🧮 Update Joget Form Grid Cells with JavaScript

Explorer — Fri, 29 May 2026 13:12:14 +0000

1. Overview

This article shows how to add rows to a Joget Enterprise Form Grid and update a specific cell value with JavaScript. The example also recalculates a row number after grid changes.

2. How It Works

Read selected form values when the button is clicked.
Validate required values before adding a row.
Call the grid's generated add function.
Store row data as JSON.
On grid change, loop through rows and update a target cell.
Use enterpriseformgrid("fillValue", ...) to write the updated JSON back into the grid row.

3. Where to Use in Joget

Form Builder: custom HTML element beside an Enterprise Form Grid.
Userview: request forms that need controlled grid row insertion.
Workflow Builder: approval forms where grid data must stay ordered.

4. Full Code

<input type='button' value='Add Row' class="add-row-button">

<script>
  $(document).ready(function () {

    $('#optional_section').css("display", "none");

    $('.add-row-button').click(function () {
      let source_field_chosen = $('[name=source_field]').val();
      let first_user_field_chosen = $('#first_user_field').val();
      let second_user_field_chosen = $('#second_user_field').val();

      if (
        !source_field_chosen ||
        !first_user_field_chosen ||
        !second_user_field_chosen
      ) {
        alert("Value cannot be Null");
        return;
      }
      if (first_user_field_chosen == second_user_field_chosen) {
        alert("Users cannot Be Same");
        return;
      }
      let RowsCount = $('[name=target_grid] table tbody tr:not(:first)').length;
      if (RowsCount < 10) {
        var field = FormUtil.getField("target_grid");
        var functionName = window[field.attr("id") + "_add"];
        if (typeof functionName === 'function') {
          var args = new Object();
          args['result'] = JSON.stringify({
            "selected_value": source_field_chosen,
            "first_user_label": $('#first_user_field_chosen a span').text(),
            "second_user_label": $('#second_user_field_chosen a span').text(),
            "unique_row_key": source_field_chosen + first_user_field_chosen,
            "row_number": RowsCount + 1
          });
          functionName(args);
          let isPushed = $('[name=target_grid] table tbody tr:not(:first)').length;
          if (RowsCount == isPushed) {
            alert("Duplicate Value Not Allowed");
          }
        }
      } else {
        alert("Only 10 Rows Are Allowed");
      }
    })

    $('[name=target_grid]').change(function () {
      $('[name=target_grid] table tbody tr').not(':first').each(function (index, row) {
        updateCell("target_grid", "row_number", index + 1, row);
      })

    })

    function updateCell(fieldId, cellId, value, row) {
      var data = JSON.parse($(row).find("textarea").val() || "{}");
      data[cellId] = value;
      $(FormUtil.getField(fieldId)).enterpriseformgrid("fillValue", FormUtil.getField(fieldId), row, JSON.stringify(data));
    }
  })
</script>

5. Example Use Cases

Adding selected users into a review grid.
Maintaining row numbers after grid changes.
Preventing duplicate grid rows.
Limiting the number of rows users can add.

6. Customization Tips

Replace arget_grid with your Enterprise Form Grid ID.
Replace field IDs with your own select-box or user-picker fields.
Adjust the row limit based on your process rule.
Use clear validation messages for missing or duplicate values.

7. Key Benefits

Gives users a controlled add-row button.
Keeps grid row data consistent.
Updates a specific cell without manual user input.
Reduces mistakes in repeated grid rows.

8. Security Note

Client-side validation is helpful, but important uniqueness and authorization rules should also be checked on the server side before final submission.

9. Final Thoughts

This pattern is useful when a Joget grid needs guided row creation. Keep the field IDs generic in public examples and test row add, duplicate, and delete flows together.

🔁 Trigger a New Joget Workflow from BeanShell

Explorer — Fri, 29 May 2026 13:11:37 +0000

1. Overview

This article shows how to trigger a new Joget workflow process from BeanShell. The script finds a target process definition, reads related records, passes workflow variables, and starts a child process for each matching row.

2. How It Works

Define the process key to start.
Resolve the full process definition ID for the current app version.
Read the parent record ID and creator.
Query child records related to the parent request.
Build a variables map for each child process.
Start the process with workflowManager.processStart(...).

3. Where to Use in Joget

Workflow Builder: Tool activity after a parent request is submitted.
Form Builder: post-processing script for parent-child workflow creation.
Scheduler Plugin: batch process creation from pending records.

4. Full Code

import org.joget.workflow.model.service.WorkflowManager;
import org.joget.apps.app.service.AppUtil;
import org.joget.apps.app.service.AppService;
import org.joget.workflow.model.WorkflowAssignment;
import org.joget.workflow.util.WorkflowUtil;
import java.util.Collection;
import java.util.HashMap;
import java.util.Map;
import org.joget.workflow.model.WorkflowProcess;
import org.joget.workflow.model.WorkflowProcessResult;
import java.sql.Connection;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;
import javax.sql.DataSource;
import org.joget.commons.util.LogUtil;

//define process to start
String processDefKey = "child_process_key";

//utility bean
WorkflowManager workflowManager = (WorkflowManager) AppUtil.getApplicationContext().getBean("workflowManager");
AppService appService = (AppService) AppUtil.getApplicationContext().getBean("appService");

//get processDefId
WorkflowProcess processDef = appService.getWorkflowProcessForApp(appDef.getId(), appDef.getVersion().toString(), processDefKey);
String processDefId = processDef.getId();

//get foreign key
String planId = "#form.parent_request.id#";
String createdBy = "#form.parent_request.createdBy#";

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.prepareStatement("SELECT * FROM app_fd_child_records WHERE c_parent_id = ?");
        stmt.setObject(1, planId);
        ResultSet rs = stmt.executeQuery();
        while (rs.next()) {
            LogUtil.info(appDef.toString(), "Processing parent request " + planId + " - Record: " + rs.getObject("id"));
            Map variables = new HashMap();
            variables.put("assignedTeam", rs.getObject("c_assigned_team"));
            variables.put("targetPeriod", rs.getObject("c_target_date"));
            LogUtil.info("Visit Monthhhhhh from 1st Process", rs.getObject("c_target_date"));
            WorkflowProcessResult result = workflowManager.processStart(processDefId, null, variables, createdBy, rs.getObject("id"), false);
            LogUtil.info(appDef.toString(), "Processing parent request " + planId + " - Record: " + rs.getObject("id") + " - Status: " + result.getProcess().getInstanceId());
        }
    }
} catch(Exception e) {
    LogUtil.error(appDef.toString(), e, "Error in creating parent request " + planId);
} finally {
    //always close the connection after used
    try {
        if(con != null) {
            con.close();
        }
    } catch(SQLException e) {/* ignored */}
}

5. Example Use Cases

Starting one child workflow per selected item.
Creating follow-up inspection or review processes.
Triggering approval workflows from a parent planning record.
Splitting one request into multiple workflow instances.

6. Customization Tips

Replace child_process_key with your process key.
Replace child table and field names with your app's generic fields.
Pass only the variables required by the child process.
Log both parent ID and new child instance ID for support tracing.

7. Key Benefits

Automates child workflow creation.
Keeps parent and child records linked.
Supports batch process creation.
Uses Joget's built-in workflow APIs.

8. Security Note

Validate that the current user or workflow state is allowed to trigger child processes. Avoid exposing internal process keys and table names in public articles.

9. Final Thoughts

This is a practical pattern for parent-child workflows in Joget. Start with one child record in testing, confirm the variables are received correctly, and then enable batch creation.

📊 Generate Dynamic HTML Reports in Joget with BeanShell

Explorer — Fri, 29 May 2026 13:11:31 +0000

1. Overview

This article shows how to generate a dynamic HTML report in Joget using BeanShell. The script reads an HTML template, loads related records from form tables, replaces placeholders, appends repeating sections, and returns the final report content.

2. How It Works

Load the report template from a database table.
Query the main request and related child records.
Store placeholder values in maps.
Replace template placeholders with form values.
Use Jsoup to append repeating HTML sections.
Return the final HTML through a FormRowSet.

3. Where to Use in Joget

Form Builder: load binder or custom binder for report preview fields.
Datalist/Reports: dynamic report generation from form records.
Workflow Builder: generate printable HTML before approval or archival.

4. Full Code

import org.joget.apps.form.model.*;
import java.sql.Connection;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;
import javax.sql.DataSource;
import org.joget.apps.app.service.AppUtil;
import org.joget.commons.util.LogUtil;
import org.jsoup.Jsoup;
import org.jsoup.nodes.Document;
import org.jsoup.nodes.Element;

 Connection conn = null;
 FormRowSet f = new FormRowSet();
 String Result;
 String AssetForeignKey;
 String guarantorForeignKey;
 String AssetHTML;
 String guarantorHTML;
 String OtherIncomeHTML;
 String employmentForeignKey;


  try {
   LogUtil.info("", "Loading Form Data");
DataSource ds = (DataSource) AppUtil.getApplicationContext().getBean("setupDataSource");
Connection conn = ds.getConnection();
String query = "SELECT html,assethtml,guarantorhtml,otherincomehtml FROM report_template where id=1";
PreparedStatement Stmt = conn.prepareStatement(query);
ResultSet resultSet = Stmt.executeQuery();

if (resultSet.next()) {
    Result = resultSet.getString("html");
    AssetHTML=resultSet.getString("assethtml");
    guarantorHTML=resultSet.getString("guarantorhtml");
    OtherIncomeHTML=resultSet.getString("otherincomehtml");
}
Stmt.close();

   Map data = new HashMap();
   Map asset= new HashMap();
   Map guarantor=new HashMap();
   Map OtherIncome=new HashMap();

        String query1="SELECT * FROM app_fd_main_request vla JOIN app_fd_request_profile bi ON vla.id = bi.c_generic_field JOIN "+
    "app_fd_income_details ei ON vla.id = ei.c_generic_field JOIN "+
    "app_fd_request_details li ON vla.id = li.c_generic_field where bi.c_generic_field='#reportParam.recordId#'";
       // String query1="select * from app_fd_request_profile where c_generic_field='e8ecc6a8-e541-472a-a846-2e88cd9fb7ce'";
        PreparedStatement Stmt1 = conn.prepareStatement(query1);

    ResultSet rs = Stmt1.executeQuery();
        if (rs.next()) {
            AssetForeignKey=rs.getString("c_generic_field");
            guarantorForeignKey=rs.getString("c_generic_field");
            employmentForeignKey=rs.getString("c_generic_field");

 //------Borrower Details
    data.put("~template_placeholder~", rs.getString("c_generic_field") != null ? rs.getString("c_generic_field") : "");
    data.put("~template_placeholder~", rs.getString("c_generic_field") != null ? rs.getString("c_generic_field") : "");
    data.put("~template_placeholder~", rs.getString("c_generic_field") != null ? (rs.getString("c_generic_field").equals("1") ? "Male" : "Female") : "");
    data.put("~template_placeholder~", rs.getString("c_generic_field") != null ? rs.getString("c_generic_field") : "");
    data.put("~template_placeholder~", "");
    data.put("~template_placeholder~", rs.getString("c_generic_field") != null ? rs.getString("c_generic_field") : "");
    data.put("~template_placeholder~", rs.getString("c_generic_field") != null ? rs.getString("c_generic_field") : "");
    data.put("~template_placeholder~", "");
    data.put("~template_placeholder~", rs.getString("c_generic_field") != null && rs.getString("c_generic_field") != null ? "+" + rs.getString("c_generic_field") + rs.getString("c_generic_field") : "");
    data.put("~template_placeholder~", rs.getString("c_generic_field") != null && !rs.getString("c_generic_field").isEmpty() ? "+" + rs.getString("c_generic_field") + rs.getString("c_generic_field") : "");
    data.put("~template_placeholder~", rs.getString("c_generic_field") != null ? rs.getString("c_generic_field") : "");
    data.put("~template_placeholder~", rs.getString("c_generic_field") != null ? rs.getString("c_generic_field") : "");

    // Resident Address
    data.put("~template_placeholder~", rs.getString("c_generic_field") != null ? rs.getString("c_generic_field") : "");
    data.put("~~template_placeholder~", "");
    data.put("~template_placeholder~", rs.getString("c_generic_field") != null ? rs.getString("c_generic_field") : "");
    data.put("~template_placeholder~", rs.getString("c_generic_field") != null ? rs.getString("c_generic_field") : "");
    data.put("~template_placeholder~", "");
    data.put("~template_placeholder~ /~template_placeholder~", "");

    // Loan Info
    data.put("~template_placeholder~", rs.getString("c_generic_field") != null ? rs.getString("c_generic_field") : "");
    data.put("~template_placeholder~", "");
    data.put("~template_placeholder~", rs.getString("c_generic_field") != null ? rs.getString("c_generic_field") : "");
    data.put("~template_placeholder~", rs.getString("c_generic_field") != null ? rs.getString("c_generic_field") : "");
    data.put("~template_placeholder~", rs.getString("c_generic_field") != null ? rs.getString("c_generic_field") : "");
    data.put("~template_placeholder~", rs.getString("c_generic_field") != null ? rs.getString("c_generic_field") : "");
    data.put("~template_placeholder~", rs.getString("c_generic_field") != null ? rs.getString("c_generic_field") : "");
    data.put("~template_placeholder~", rs.getString("c_generic_field") != null ? rs.getString("c_generic_field") : "");
    data.put("~template_placeholder~", rs.getString("c_generic_field") != null ? rs.getString("c_generic_field") : "");
    data.put("~template_placeholder~", rs.getString("c_generic_field") != null ? rs.getString("c_generic_field") : "");

    // Employment Info
    data.put("~template_placeholder~", rs.getString("c_generic_field") != null ? rs.getString("c_generic_field") : "");
    data.put("~template_placeholder~", rs.getString("c_generic_field") != null ? rs.getString("c_generic_field") : "");
    data.put("~template_placeholder~", rs.getString("c_generic_field") != null ? rs.getString("c_generic_field") : "");
    data.put("~template_placeholder~", rs.getString("c_generic_field") != null ? rs.getString("c_generic_field") : "");
    data.put("~template_placeholder~", rs.getString("c_generic_field") != null ? rs.getString("c_generic_field") : "");
    data.put("~template_placeholder~", "");
    data.put("~template_placeholder~", "");
    data.put("~template_placeholder~", "");
        }

        for (Map.Entry entry : data.entrySet()) {
            Result = Result.replace(entry.getKey(), entry.getValue());
            LogUtil.info("", entry.getValue());
          }
    String AssetQuery="select * from app_fd_item_details where c_generic_field='"+AssetForeignKey+"'";
    Stmt1 = conn.prepareStatement(AssetQuery);
    rs = Stmt1.executeQuery();
    StringBuilder multiAssetHTML=new StringBuilder();

        while (rs.next()) {
            String initalizeHTML=AssetHTML;
            asset.put("~template_placeholder~", rs.getString("c_generic_field") != null ? rs.getString("c_generic_field") : "");
            asset.put("~template_placeholder~", rs.getString("c_generic_field") != null ? rs.getString("c_generic_field") : "");
            asset.put("~template_placeholder~", rs.getString("c_generic_field") != null ? rs.getString("c_generic_field"): "");
            asset.put("~template_placeholder~", rs.getString("c_generic_field") != null ? rs.getString("c_generic_field") : "");
            asset.put("~template_placeholder~", rs.getString("c_generic_field") != null ? rs.getString("c_generic_field") : "");

            asset.put("~template_placeholder~", rs.getString("c_generic_field") != null ? rs.getString("c_generic_field") : "");
            asset.put("~template_placeholder~", rs.getString("c_generic_field") != null ? rs.getString("c_generic_field"): "");
            asset.put("~template_placeholder~", rs.getString("c_generic_field") != null ? rs.getString("c_generic_field") : "");
            asset.put("~template_placeholder~", rs.getString("c_generic_field") != null ? rs.getString("c_generic_field") : "");
            asset.put("~template_placeholder~", rs.getString("c_generic_field") != null ? rs.getString("c_generic_field") : "");
            asset.put("~template_placeholder~", rs.getString("c_generic_field") != null ? rs.getString("c_generic_field") : "");
            asset.put("~template_placeholder~", rs.getString("c_generic_field") != null ? rs.getString("c_generic_field"): "");
            asset.put("~template_placeholder~", rs.getString("c_generic_field") != null ? rs.getString("c_generic_field") : "");

            for (Map.Entry entry : asset.entrySet()) {
                initalizeHTML = initalizeHTML.replace(entry.getKey(), entry.getValue());
                LogUtil.info("", entry.getValue());
              }
               LogUtil.info("", initalizeHTML);
              multiAssetHTML.append(initalizeHTML);
            LogUtil.info("", "Finished");
        }
        Document doc = Jsoup.parse(Result);
        Element div = doc.getElementById("sectionAsset");

        div.append(multiAssetHTML.toString());
        Result=doc.toString();

 //OtherIncome

 String otherIncomeQuery="select * from app_fd_additional_income where c_generic_field='"+employmentForeignKey+"'";
 Stmt1 = conn.prepareStatement(otherIncomeQuery);
 rs = Stmt1.executeQuery();
 StringBuilder multiIncomeHTMl=new StringBuilder();



     while (rs.next()) {
         String initalizeHTML=OtherIncomeHTML;
         OtherIncome.put("~template_placeholder~", rs.getString("c_generic_field") != null ? rs.getString("c_generic_field") : "");
         OtherIncome.put("~template_placeholder~", rs.getString("c_generic_field") != null ? rs.getString("c_generic_field") : "");

         for (Map.Entry entry : OtherIncome.entrySet()) {
             initalizeHTML = initalizeHTML.replace(entry.getKey(), entry.getValue());
             LogUtil.info("", entry.getValue());
           }
           multiIncomeHTMl.append(initalizeHTML);
     }
     Document doc = Jsoup.parse(Result);
     Element div = doc.getElementById("otherIncomeSection");

     div.append(multiIncomeHTMl.toString());
      Result=doc.toString();

  //guarantor

  String guarantorQuery="select * from app_fd_related_party where c_generic_field='"+guarantorForeignKey+"'";
 Stmt1 = conn.prepareStatement(guarantorQuery);
 rs = Stmt1.executeQuery();
 StringBuilder multiguarantorHTMl=new StringBuilder();



     while (rs.next()) {
         String initalizeHTML=guarantorHTML;
         guarantor.put("~template_placeholder~", rs.getString("c_generic_field") != null ? rs.getString("c_generic_field") : "");
         guarantor.put("~template_placeholder~", rs.getString("c_generic_field") != null ? rs.getString("c_generic_field"): "");
         guarantor.put("~template_placeholder~", rs.getString("c_generic_field") != null ? rs.getString("c_generic_field") : "");
         guarantor.put("~template_placeholder~",  "");
         guarantor.put("~template_placeholder~", rs.getString("c_generic_field") != null && rs.getString("c_generic_field") != null ? "+" + rs.getString("c_generic_field") + rs.getString("c_generic_field") : "");
         guarantor.put("~template_placeholder~", "");
         guarantor.put("~template_placeholder~", rs.getString("c_generic_field") != null ? rs.getString("c_generic_field"): "");
         guarantor.put("~template_placeholder~", "");

         for (Map.Entry entry : guarantor.entrySet()) {
             initalizeHTML = initalizeHTML.replace(entry.getKey(), entry.getValue());
             LogUtil.info("", entry.getValue());
           }
           multiguarantorHTMl.append(initalizeHTML);
     }
     Document doc = Jsoup.parse(Result);
     Element div = doc.getElementById("sectionGuarantor");

     div.append(multiguarantorHTMl.toString());
      Result=doc.toString();



        Stmt1.close();
        conn.close();
FormRow r1 = new FormRow();
r1.put("report",Result);
f.add(r1);
  } catch (Exception e) {
       LogUtil.info("", "Error Binding Data: " + e.getMessage());

    } finally {
        try {
            if (conn != null && !conn.isClosed()) {
                conn.close();
            }
        } catch (SQLException e) {
            LogUtil.info("", "Error closing connection: " + e.getMessage());
        }
    }


return f;

5. Example Use Cases

Generating agreement or request reports.
Building printable summaries from parent and child forms.
Rendering repeating table sections into an HTML template.
Preparing HTML content for PDF generation.

6. Customization Tips

Replace template table and form table names with your own generic app tables.
Keep placeholders consistent between your HTML template and BeanShell maps.
Use separate maps for parent, child, and repeating-section data.
Close database resources in inally blocks.

7. Key Benefits

Keeps report layout separate from data retrieval.
Supports repeating child-record sections.
Works inside Joget without an external report server.
Easy to extend for additional sections.

8. Security Note

Do not publish real table names, customer fields, IDs, or personal data. Escape or validate values before rendering them into HTML if the data can contain user-provided content.

9. Final Thoughts

This pattern is useful when a Joget app needs a custom, printable report from multiple related tables. Keep the template clean, keep the mappings explicit, and sanitize public examples before sharing.

🛑 Abort a Running Joget Workflow Process with BeanShell

Explorer — Fri, 29 May 2026 12:40:21 +0000

1. Overview

Sometimes a Joget process must be ended from a custom action, for example when a request is withdrawn or cancelled. This article shows a BeanShell pattern for updating the related form record and aborting the active workflow process.

2. How It Works

Read the selected row key from a datalist action.
Load the matching form record.
Update the approval status and modifier fields.
Find the active workflow process ID from wf_process_link.
Call workflowManager.processAbort(process_id) to abort the process.

3. Where to Use in Joget

Datalist Builder: custom row action for withdraw/cancel buttons.
Workflow Builder: administrative actions that terminate active requests.
Userview: controlled self-service cancellation flows.

4. Full Code

import java.util.HashMap;
import org.joget.apps.form.dao.FormDataDao;
import org.joget.apps.form.model.FormRow;
import org.joget.apps.form.model.FormRowSet;
import org.joget.commons.util.LogUtil;
import org.joget.apps.app.service.AppUtil;
import org.joget.commons.util.UuidGenerator;
import org.joget.apps.datalist.model.DataListActionResult;
import org.joget.workflow.model.WorkflowProcessResult;
import org.joget.workflow.model.service.WorkflowManager;
import java.sql.Connection;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;
import javax.sql.DataSource;
import org.joget.apps.form.model.Element;
import java.io.*;  
import java.io.IOException;   
import java.util.Map;

String id="";
String active="";
if (rowKeys.length>0) {
    id=rowKeys[0];
}

if(!id.isEmpty()){
    //delete record
    FormDataDao formDataDao = (FormDataDao) AppUtil.getApplicationContext().getBean("formDataDao");

    FormRowSet form_rows = new FormRowSet();
    form_rows.setMultiRow(true);
    FormRow form_row=formDataDao.load("request_form","request_form",id);
    form_row.setProperty("request_status","Withdrawn");
    form_row.setProperty("modifiedBy","#currentUser.username#");
    form_row.setProperty("modifiedByName","#currentUser.fullName#");
    form_row.setDateModified(new Date());
    form_rows.add(form_row);
    formDataDao.saveOrUpdate("request_form","request_form",form_rows);

    //formDataDao.delete("request_form","request_form",form_rows);

    //terminate process
    WorkflowManager workflowManager = (WorkflowManager) AppUtil.getApplicationContext().getBean("workflowManager");

    try{
        String process_id="";
        DataSource ds = (DataSource)AppUtil.getApplicationContext().getBean("setupDataSource");
        con = ds.getConnection();
        if(!con.isClosed()) {
            PreparedStatement stmt = con.prepareStatement("select * from wf_process_link where originProcessId=?");
            stmt.setObject(1, id);
            ResultSet rs = stmt.executeQuery();
            while (rs.next()) {
                process_id=rs.getString("processId");
            }
            con.close();
        }

        if(!process_id.isEmpty()){
            LogUtil.info("Aborting Process for ProcessID: ", process_id);
            workflowManager.processAbort(process_id);
        }
    } 
    catch (Exception e) {
        con.close();
        LogUtil.info("Catch Block","Exception Found "+e.toString());
    } 
}

5. Example Use Cases

Withdraw asset registration requests.
Cancel pending approval workflows.
End duplicate or invalid requests.
Build admin-only terminate actions from a datalist.

6. Customization Tips

Replace form ID, table ID, and status value with your app's values.
Restrict this action to authorized users only.
Add a confirmation dialog before running the action.
Log the reason for termination in a history table if auditability is required.

7. Key Benefits

Updates business status and workflow status together.
Gives users or admins a controlled cancellation action.
Uses Joget's built-in WorkflowManager.
Keeps termination logic close to the datalist action.

8. Security Note

Only allow trusted roles to abort processes. Terminating a workflow can bypass normal approval paths, so protect the datalist action with permission checks and audit logs.

9. Final Thoughts

This pattern is useful for controlled cancellation flows. Keep it permission-protected, record the reason for termination, and test with active and already-completed process instances.