How to check if the target table got refreshed before triggering any workflow? | Community

Level 2

Solved

How to check if the target table got refreshed before triggering any workflow?

Forum|Forum|3 years ago
April 29, 2022
1 reply
1033 views

I need to set a dependency on the automated workflows. I want my workflow to go to backend table and see if the table got refreshed with today's date before triggering the workflow. If table didn't get refreshed, then it should send out an alert and re-trigger after some time may be 1 hour for an example. Can we achieve this? if yes how?

Thanks in advance!

This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.

Best answer by Marcel_Szimonisz

Hello @data_guy ,

if you use audit trail attribute you can check last modified date and then on workflow divert to loop retry with alert and wait activity.

Marcel

Marcel_Szimonisz

Community Advisor

Accepted solution

Community Advisor

Hello @data_guy ,

if you use audit trail attribute you can check last modified date and then on workflow divert to loop retry with alert and wait activity.

Marcel

Level 2

Thanks Marcel! Somehow I am not able to see Audit under Administration. Using 19.1 build

Community Advisor

Community Advisor

Audit trail started from Release 19.1 - Build 9026. You need to update your app server.

Thanks,

David

David Kangni