We need to fetch the attribure "Requested for" for pending request in an analytics report

[Debankita]

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".

[Saathvik]

@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.

[rushikeshvartak]

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