Discontinue requests pending for manager approval

[Suresh1]

Hello Team,

How can i discontinue the requests which are waiting for manager approval ? I can do it from UI but the count is quite a lot. Is there a way to discontinue them from a query ? 

[Raghu]

@Suresh1  below script will help you

select requestkey as ars_Requests__primarykey ,4 as ars_Requests__status
from ars_requests where SUBSTR(JBPMPROCESSINSTANCEID, INSTR(JBPMPROCESSINSTANCEID, '.') + 1, LENGTH(JBPMPROCESSINSTANCEID)) in ('XXX',XXX)

Refrence below articles:

https://forums.saviynt.com/t5/privileged-access-management/removing-void-requests-from-approval-page...

https://forums.saviynt.com/t5/identity-governance/approval-request-not-clearing-after-approval/m-p/8...

[rushikeshvartak]

It’s advisable to perform from UI. As there will be always entries in dependent tables 

[dgandhi]

Execute below as custom query job in 5.5 instance:

[Suresh1]

I have the request numbers but not the request keys. Is there any table i can join to get the request keys of the requests ?

[dgandhi · Accepted solution]

If you have request id then you can use below:

[rushikeshvartak · Accepted solution]

select requestkey as ars_Requests__primarykey ,4 as ars_Requests__status
from ars_requests where SUBSTR(JBPMPROCESSINSTANCEID, INSTR(JBPMPROCESSINSTANCEID, '.') + 1, LENGTH(JBPMPROCESSINSTANCEID)) in ('XXX',XXX)

Custom query

update ars_requests set status=4 where SUBSTR(JBPMPROCESSINSTANCEID, INSTR(JBPMPROCESSINSTANCEID, '.') + 1, LENGTH(JBPMPROCESSINSTANCEID)) in ('REQ1',REQ2)

Update request id in above query

[NM]

Hi @Suresh1 , ars_requets table will provide you with requestkey