Announcing the Saviynt Knowledge Exchange unifying the Saviynt forums, documentation, training,
and more in a single search tool across platforms. Read the announcement here.

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

Debankita
New Contributor III
New Contributor III

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

2 REPLIES 2

sk
All-Star
All-Star

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


Regards,
Saathvik
If this reply answered your question, please Accept As Solution and give Kudos to help others facing similar issue.

rushikeshvartak
All-Star
All-Star

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


Regards,
Rushikesh Vartak
If you find the response useful, kindly consider selecting Accept As Solution and clicking on the kudos button.