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

Runtime Analytics : Request Pending for approval for logged in User

Manu269
All-Star
All-Star

Hi Team,

We are looking forward assistance for creating a dashboard to fetch the Request pending for approval.

I have created following analytics query :

SELECT DISTINCT
SUBSTR(jbpmprocessinstanceid,
INSTR(jbpmprocessinstanceid, '.') + 1,
LENGTH(jbpmprocessinstanceid)) REQUESTID,
us.username AS RequestedFor,
u.username AS ApproverName,
aa.JBPM_ACTIVITY_NAME AS ActivityName,
aa.SUBMITDATE AS StartDate,
CASE
WHEN ar.REQUESTTYPE = 24 THEN 'FIREFIGHTERID'
WHEN ar.REQUESTTYPE = 23 THEN 'FIREFIGHTERID ACCESS'
END 'Request Type'
FROM
access_approvers aa,
users u,
users us,
request_access ra,
ars_requests ar
WHERE
ra.request_accesskey = aa.request_access_key
AND ra.requestkey = ar.requestkey
AND u.userkey = aa.approverkey
AND us.userkey = ra.userkey
and ar.REQUESTTYPE in (23,24,11)
AND aa.status = 1;

But the report generated is altogether a complete list.

Can someone guide how we can tweak this query to fetch the report where he/she can get all the request pending for his/her approval?

 

Thanks

Manish

Regards
Manish Kumar
If the response answered your query, please Accept As Solution and Kudos
.
1 REPLY 1

rushikeshvartak
All-Star
All-Star

You can create normal analytics & user user context field (disadvantage is you need schedule report)

if you want runtime then instead of dashboard give access to analytics

https://saviynt.freshdesk.com/support/solutions/articles/43000431474-context-types-of-elasticsearch-... 

 

Select userkey as USERCONTEXT, username, firstname from userlimit 10


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