List Pending Activity and Assignees

Users may wonder on what is the state of their submitted process applications. We are going to attempt to address this issue by creating a list that will show the application information together with the pending activity and the pending user. This way, the requesters/users would be able to tell on the state of their applications/process instances.

In this exercise, we are using the HR Expenses Claim App that is bundled together in the Joget Enterprise edition.

Figure 1: Viewing submitted application through Datalist

By default, users would be able to see the submitted applications by going through the "Personal Expenses" listing but one will not be able to tell what is the next activity in line and who is supposed to attend to it. This can be solved by creating a new Datalist.

1. Create a new Datalist.
2. Choose JDBC Datalist Database Binder.
3. In "Configure JDBC Datalist Database Binder", choose "Default Datasource" in "Datasource".
4. Apply the following query in "SQL SELECT Query"

   SELECT a.*, sact.Name AS activityName, GROUP_CONCAT(DISTINCT sass.ResourceId SEPARATOR ', ') AS assignee
   FROM app_fd_hr_expense_claim a
   JOIN SHKActivities sact on a.id = sact.ProcessId
   JOIN SHKActivityStates ssta ON ssta.oid = sact.State
   INNER JOIN SHKAssignmentsTable sass ON sact.Id = sass.ActivityId
   WHERE ssta.KeyValue = 'open.not_running.not_started'
   GROUP BY a.id

5.  Set "Primary Key" to "a.id"
6.  Click OK.

Figure 2: Adding the columns into the Datalist

Next, add in the columns intended, and most importantly, add "activityName" and "assignee" to reveal the pending activity and assignees.