Qlik Community

Ask a Question

App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

Announcements
April 22, 2PM EST: Learn about GeoOperations in Qlik Sense SaaS READ MORE
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 (2)
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

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.