About the User's Recent Operations on the Processes
With the following query, your users can see the approval dates, transactions, etc. of your processes in eBA. You can sort
SELECT
O.FIRSTNAME,
O.LASTNAME,
FR2. USERID,
FR2. REQUESTDATE AS DATE,
FR2. DESCRIPTION
FR2. PROCESSID
FROM OSUSERS O
JOIN (
SELECT
FR. USERID,
MAX(FR. APPROVER) AS MAX_APPROVER
FROM FLOWREQUESTS FR
WHERE FR. RESPONSEDATE IS NOT NULL
GROUP BY FR. USERID
) AS Sub ON (Sub.USERID = O.ID)
JOIN FLOWREQUESTS FR2
ON FR2. USERID = Sub.USERID AND FR2. APPROVER = Sub.MAX_APPROVER
With "F2.", you can access information such as Reason, Trycount, etc