Runtime Analytics : Request Pending for approval for logged in User

[Manu269]

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

[rushikeshvartak]

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