Chasing up Pending Approvals

[hong_cheung]

Hello,

We have a workflow in Change Management whereby email approvals are sent to various approvers.   However, sometimes an approver does not reply and causes the change to not progress.

Is it possible for an automated rule or task to resend the initial email notification every day until they respond?

Thanks you in advance,

Hong

[James Hammond]

Hi Tony,

This looks like an issue with the Encoded Query; my suggestion would be to use the following;

state=requested^sys_created_onRELATIVELE@dayofweek@ago@5

The RELATIVELE rather than RELATIVEGE represents 'on or before'; that way it will give you all approvals older than 5 days.

If you go to the table itself, you can use the query builder to get the exact results you want, then after you have run the query you can right click and select 'Copy Query' to get the string for use in the addEncodedQuery function.

[TSP666]

James, thanks for the very quick reply, I have changed the code and will see what happens when the job runs tonight.

[solutioningnow]

Hi Hong,

I have implemented this for one of the customer. Previously we thought to have scheduled job after every 24 hours but scheduled job is not reliable since we may miss 23.59 hours if approval send just after job executed.

Best way for this is to write a workflow on the sys_approval record and put timer as mentioned in the below screenshot,

Please mark answer as correct/helpful, if it was really helpful 🙂

Regards,

Solutioner

Enhance Knowledge NOW@ www.solutioningnow.com

http://www.solutioningnow.com/