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

[Data_guy]

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!

[Marcel_Szimonisz · Accepted solution]

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

[Data_guy]

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

[DavidKangni]

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

Thanks,

David

[Data_guy]

Thanks, let me update and check.