Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 
shrusrkt
Contributor III
Contributor III

Trigger in qliksense after db is refreshed

Hi All,

I want to reload my applications only after db tables are refreshed.

Is there any trigger where my code will check if db tables are refreshed then my qlik applications will run, if db tables are not refreshed then qlik application won't start.

Can anybody help to get this.

 

Thanks in advance!

 

Labels (1)
2 Replies
Lauri
Specialist
Specialist

Can you query your DB for a date or some data point that tells you if it was refreshed? If so, add an IF statement at the beginning of your application -- if the query shows the DB was refreshed, THEN proceed to rest of script, ELSE exit the script.

Since you have multiple applications, it might be more efficient to do this in just one application and save the query result to a QVD, and use that in subsequent applications.

Lech_Miszkiewicz
Partner Ambassador/MVP
Partner Ambassador/MVP

Hi,

If your DB can run scripts you may want to look at Qlik Cli. Reload could be triggered from command like the one below: 

Start-QlikTask "Reload Operations Monitor" -wait | Wait-QlikExecution

https://developer.qlik.com/garden/58b83eb68bc22ec70e8788f3

 

cheers Lech, When applicable please mark the correct/appropriate replies as "solution" (you can mark up to 3 "solutions". Please LIKE threads if the provided solution is helpful to the problem.