Skip to main content

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