Since we do not have supervisor approval delegation ability on the version of L&G that we are running, I am trying to create a report that will run daily and generate for specific users who we know are out of office and have pending supervisor approval activities outstanding. This way my team doesn't have to monitor the approvals activities page.
Thanks!
Assuming you have some kind of an indicator on the identity level if the user is out of office, you can consider using the query below.
You might need to tweak it a bit, but it's a start
select distinct CRWU.ASSIGNED_TO, CRWU.WORKITEM_ID , CRA.STATE, PVU.FULL_NAME, CRA.CHANGE_REQUEST_ID
from PV_CHANGE_REQUEST_WORK_USER CRWU
JOIN PV_CHANGE_REQUEST_ACTIVITY CRA
on CRWU.WORKITEM_ID = CRA.WORKITEM_ID
JOIN PV_USERS PVU
on CRWU.ASSIGNED_TO = PVU.ID
WHERE CRA.STATE = 'PendingApprovals'
AND PVU.OUT_OF_OFFICE_INDICATOR='TRUE'Thank you Boris! That got me what I needed!
Assuming you have some kind of an indicator on the identity level if the user is out of office, you can consider using the query below.
You might need to tweak it a bit, but it's a start