cancel
Showing results for 
Search instead for 
Did you mean: 

Access Enforcer 5.2 open request details including stage.

Former Member
0 Kudos

Dear All,

We have requirement to pull the open requests in Access Enforcer 5.2, with the information of the stage at which the open request is.

We have a workflow with 5 stages. Now we have requirement to pull the information about open request along with the respective stage in which the request is. In AE 5.2, we can pull the information for open or closed request, but not with stage information for open request.

Please assist is there any alternate way to pull this information. or the java table in which the request details are stored. We have access to database.

Thanks & Regards,

GRC Team.

Accepted Solutions (1)

Accepted Solutions (1)

Former Member
0 Kudos

There is a query below that you need to list in the SQL box, but this address varies based upon your support pack. If you're up to date (or close to) on SPs, enter the following address into your web browser AFTER logging into AE: http://<server>:<port>/AE/opensql_test.jsp.

Paste the following query into the SQL box:

SELECT DISTINCT

WPHST.REQNO,

WPHST.REQPATHID,

WPHST.PATHNAME,

WPHST.STATUS AS REQUEST_STATUS,

TBLPATHSTAGE.STAGENAME

FROM

(VIRSA_AE_RQD_WPHST AS WPHST INNER JOIN VIRSA_AE_WF_PTSTG AS TBLPATHSTAGE ON (WPHST.PATHNAME = TBLPATHSTAGE.PATHNAME) AND (WPHST.CURRENTAPPRVRSEQ = TBLPATHSTAGE.STAGESEQ)) INNER JOIN VIRSA_AE_RQD_WPTRN AS WPTRN ON (TBLPATHSTAGE.STAGENAME = WPTRN.STAGE_NAME) AND (WPHST.REQNO = WPTRN.REQNO)WHERE

(WPHST.ISCURRENTFLAG = 1) AND ((WPHST.STATUS='OPEN') OR (WPHST.STATUS='HOLD'))

Answers (0)