Need to expiry only specific Requests

[userr]

Hi,

we have a request to expiry only specific requests like, Request created to modify user profile attributes through UI.

where the Request will go Manager and If manager has not taken any action after 14 days the request should be expired.

we can not use the Global configuration because we do not need to expire the rest of the requests like request submitted for account or access.

Thanks in advance
 

[NM]

@userr you can use enhanced query to expire the specific request.

[userr]

@NM Thanks for the prompt response, appreciated!

Can you please share sample query, thanks again

[Raghu]

@userr  use below EQ query based on your requirement you can modify it

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

https://forums.saviynt.com/t5/identity-governance/volume-of-access-requests-not-completed-due-to-no-...

select requestkey as ars_Requests__primarykey ,4 as ars_Requests__status
from ars_requests
where SUBSTR(JBPMPROCESSINSTANCEID, INSTR(JBPMPROCESSINSTANCEID, '.') + 1, LENGTH(JBPMPROCESSINSTANCEID))='123174' limit 1;

[rushikeshvartak]

• Use workflow to auto escalate the request and expire instead of enhanced query

[userr]

@Raghu Thanks.

@rushikeshvartak  Request rejection and Expiration can be consider as same? 

For request expiry we need to execute the "Expiry Old Requests" job. 
 

[rushikeshvartak]

• If you auto escalate then request will be considered as auto rejected and email can be sent.
• With Enhanced query email will not be sent. and respective JBPM tables we can't update