SELECT DISTINCT RA.request_accesskey AS REQACCKEY,
RA.startdate AS STDATE,
AREQ.jbpmprocessinstanceid AS REQID,
RA.enddate AS EDATE,
RA.status AS STTS,
EP.endpointname AS EPNAME,
EP.displayname AS EPDISPNAME,
U.username AS USERNAME,
A.NAME AS NAME,
arstasks.status AS TASKSTATUS
FROM request_access RA
JOIN arstasks
ON RA.request_accesskey = arstasks.requestaccesskey
JOIN ars_requests AREQ
ON RA.requestkey = AREQ.requestkey
JOIN users U
ON RA.userkey = U.userkey
JOIN accounts A
ON RA.accesskey = A.accountkey
JOIN endpoints EP
ON A.endpointkey = EP.endpointkey
WHERE RA.accesstype = 8
AND RA.requesttype = 24
AND EP.status = 1
AND RA.status NOT IN ( 4, 7, 6 )
ORDER BY RA.request_accesskey DESC;
Regards,
Rushikesh Vartak
If this helped you move forward, click 'Kudos'. If it solved your query, select 'Accept As Solution'.
