I am just wondering if there is way to have qliview watch data for changes and then trigger a task when the data does change. For example I am interested only in running some qvd generators when a value max(extract_datetime) in my database changes. Is there any efficient way to achieve this??
If you go to QEMC --> System --> Supporting Tasks --> Database Command, you can define a query there. You can then trigger a task off this Database Command. That's probably the place to start; the tricky part is writing the query in such a way as to make the task wait until the query returns positive...or you could run the query every X minutes until it does.
Looks like this could be a possibility. One thing I am feeling very frustrated with regards to qlik is documentation....is there a reference manual for the publisher anywhere??? I wonder if it would cover how to use this database command.
At the end I used the combination of java scheduler, some java code to check and update a table on the db, Cron4J and EDX with qlikview tasks that are in witing status on the server.
