Which tables do I use? I found the PFIWORKUNIT and can filter on Req Approval with Statuse codes, but how can I link the Approvers for Approver 1 and Approver 2 and who approved these or denied?
My SQL novice query uses PFIMETRICS. Hope this helps
SELECT PFIMETRICS.PFIWORKUNIT, PFIMETRICS.PMPFIUSERPROFILE, PFIMETRICS.PMPTTASKNAME, PFIMETRICS.ACTIONDATE, PFIMETRICS.ACTIONTAKEN, PFIWORKUNIT.WORKTITLE, PFIWORKUNIT.FLOWDEFINITION, PFIWORKUNIT.STARTDATE FROM PFIMETRICS INNER JOIN PFIWORKUNIT ON PFIMETRICS.PFIWORKUNIT = PFIWORKUNIT.PFIWORKUNIT WHERE (((PFIMETRICS.PFIWORKUNIT)>14700000) AND ((PFIWORKUNIT.FLOWDEFINITION) Like "*ReqApp*" AND ((PFIWORKUNIT.STARTDATE)>#8/30/2022#)) ORDER BY PFIWORKUNIT.WORKTITLE;