Need approach to automatically close Legal requests that were updated 6 days ago

[Hritik]

Hello Community,

Please find my requirement below:

All the legal requests that were last updated 6 days ago and state is "awaiting for user" should be automatically resolved by the system and then system should trigger notification to the requestor that request is resolved.

My approach:

So far I created a "After update" BR and wrote script to update status and trigger email from event.

But it's not working. As record would not be updated hence I guess this BR would not work here.

Could you suggest a better approach please? What's easier to handle this ? 

Scheduled script or job ? Or if I can update existing BR ?

thanks in advance,

Hritik.

[Mark Roethof]

Hi there,

A business rule won't work, since this is 6 days after update. What you could do, a Scheduled Flow with zero code. Once a day, or hourly, just depending on your requirement.

[Nuno Oliveira]

Hi Hritik,

You can do it in two way-

- Via Scheduled job running whenever you need with the logic you need to apply to close the requests

- Via Schedule flow -> It's pretty much the same thing but prettier.

Something like the prints I have attached. I have used the incident table but the logic must be more or less the same.

Let me know if you need more help 🙂 

Best regards,

Nuno Oliveira