Displaying Specific Processes in a List Inbox

Introduction

This article demonstrates how to filter the List Inbox in Joget so that specific processes are displayed into a single List Inbox. The solution leverages the Universal Datalist Inbox Audit Trail Plugin to capture assignment data and a custom SQL query to retrieve the relevant records.

Prerequisites

The Universal Datalist Inbox Audit Trail Plugin must be installed and configured. Please refer to the knowledge base article for proper setup. This plugin enables Joget to store assignment data in the assignment_formdata table. 

How does it work?

After installing the plugin, create a new Data List using Database SQL Query as the data source. Use the following SQL query to filter assignments for only the desired processes:

SELECT * FROM assignment_formdata
WHERE ActivityProcessId LIKE '%processId%' OR ActivityProcessId LIKE '%processId%'

This query ensures that only assignment records associated with the processId are retrieved. Ensure to replace them with the process IDs you wish to display in the list.

Next, map this new Data List to a List Inbox element in the Userview. The List Inbox will now display only the filtered assignments related to the specified processes, providing a streamlined view for the user.

Expected outcome

The List Inbox page will show only the selected processes. All unrelated assignments will be excluded, allowing users to focus only on relevant tasks.