Page History

...

Figure 1: Viewing submitted application through DatalistList

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 DatalistList.

1. Create a new Datalist.

   Thai
   สร้างดาต้าลิสต์ใหม่

2. Choose JDBC Datalist Database Binder.

   Thai
   เลือกตัวยึดฐานข้อมูล JDBC Datalist

3. In "Configure JDBC Datalist Database Binder", choose "Default Datasource" in "Datasource".

   Thai
   ใน "กำหนดค่า JDBC Datalist Binder ฐานข้อมูล" เลือก "Default Datasource" ใน "Datasource"

4. Apply the following query in "SQL SELECT Query"

   Thai
   ใช้แบบสอบถามต่อไปนี้ใน "SQL SELECT Query"

   Code Block
   lang sql
   SELECT a.*, sact.Name AS activityName, GROUP_CONCAT(DISTINCT sass.ResourceId SEPARATOR ', ') AS assignee FROM app_fd_j_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

   Note: Please replace the code "app_fd_hr_expense_claim" with your own table name if you intend to use it for other application.

   Thai
   หมายเหตุ: โปรดแทนที่รหัส "app_fd_hr_expense_claim" ด้วยชื่อตารางของคุณเองหากคุณตั้งใจจะใช้สำหรับแอปพลิเคชันอื่น

5.  Set "Primary Key" to "a.id"

   Thai
   ตั้งค่า "คีย์หลัก" เป็น "a.id"

6.  Click OK.

   Thai
   คลิกตกลง

Image AddedImage Removed
Figure 2: Adding the columns into the DatalistList

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

Figure 3: Datalist List showing the pending activity and assignees

The Datalist List will now list all the pending activities of everyone. Next, we are going filter the list such that user will only see what they submitted.

Image AddedImage Removed
Figure 4: Retrieving the requester information

...