Leveraging Intelligent Recommendations for Operational Transformation. AMS Partners Click HERE | EMEA/APJ Click HERE |
12/07/2023 09:04 AM
Hi Team,
We have configured an analytics report to fetch the pending requests along the assignee name with whom it is pending. We want to include the "Requested for" field in that report. Can anyone please help with the binding variable which will allow us to fetch it.
Please note: The "Requested for" might not be same as "Requestor".
12/07/2023 09:08 AM
@Debankita : You can join with request_access table on requestkey and there you can find userkey column which represents for whom request is submitted for.
12/07/2023 10:31 AM
select
ar.requestkey,
(select u.username from users u where u.userkey=ar.requestor)requestor,
(select u.username from users u where u.userkey=ra.userkey)requestedfor
from ars_requests ar,request_Access ra
where ar.requestkey=ra.requestkey