topic Re: Trigger in qliksense after db is refreshed in App Development

Trigger in qliksense after db is refreshed

shrusrkt — Sat, 16 Nov 2024 00:39:16 GMT

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!

Re: Trigger in qliksense after db is refreshed

Lauri — Tue, 16 Feb 2021 21:34:14 GMT

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.

Re: Trigger in qliksense after db is refreshed

Lech_Miszkiewicz — Tue, 16 Feb 2021 22:08:38 GMT

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