topic Re: Last Modified Date Trigger in QMC in QlikView

Last Modified Date Trigger in QMC

Anonymous — Wed, 25 Nov 2020 16:16:04 GMT

Hi All,

Can we create a task in QMC, which will get triggered, whenever the data gets updated in database.

Please provide your inputs.

Thanks & Regards,

Re: Last Modified Date Trigger in QMC

adamdavi3s — Mon, 17 Oct 2016 06:52:49 GMT

There is quite a good doc on here which *might* be useful but it depends what you can do database side really:

https://community.qlik.com/docs/DOC-9221

A "Qlik" Way of doing it is to have a very simple qvw scan for changes, let it fail the reload if there aren't any, and then schedule your main app to run if this one is successful.

No new data- reload fail - main app doesn't reload

new data- reload works- main app reloads

Re: Last Modified Date Trigger in QMC

Peter_Cammaert — Mon, 17 Oct 2016 11:04:02 GMT

Most database systems provide a mechanism to trigger (external) actions whenever a certain event (change, condition, etc.) occurs. For example, in SQL Server, you have the SQL Server Agent that monitor the DB and acts upon configurable conditions.

If your DBMS supports such a mechanism, it is very easy to make the Database run QMSEDX Enhanced to trigger a task in QMC. The big advantage of this method vs. polling or looping is that no cpu cycles are wasted by monitoring processes or remaining in a wait.loop to consistently check whether a condition has been fulfilled. Something only happens when it needs to happen. Not before, not afterwards.

Best,

Peter

Re: Last Modified Date Trigger in QMC

Anonymous — Mon, 17 Oct 2016 12:25:08 GMT

Thanks for the replies...

The reson I need to Reload the application is, when I trie direct discovery, BUNDLE INFO load was not working