Wednesday, February 8, 2017

Refresh NPrinting report only Dashboard is refreshed in last X hours/minutes.

Some time, we face the requirement to run the Nprinting report only when QMC reload is in success and we have latest data in Report.
We can follow below steps to check whether QV document is refreshed in last n hours.



  • Create a variable in your Dashboard similar to below. Here N is number of  hours  to check - How many hours back dashboard was refreshed.

           Let V_RefreshTime = Timestamp(now() + N/24)  ,


  •     Go to Nprinting Report, Create a condition rule as below.




  • Select the option calculate for your rule.

Save the Nprinting report and task.

Now you have Nprinting report having logic to send the report only when dashboard is refreshed in last N hours. We Can manipulate the logic by just changing the value of N.

cheers,
Shiv

No comments:

Post a Comment