extracting "real-time" data

amien — Mon, 04 Mar 2013 08:16:52 GMT

ok, it's not realtime .. not even near, but i runs every half hour.

QMC runs every 15 minutes, pulls out some data and publisher starts creating PDF's

i'm pulling out all the id's now, but i only need the id's of which no PDF is created yet. I do now a filelist check on the PDF destination. I just check which id's already have a PDF file. it works, but i think it can be more efficient.

I would like to work with the change_datetime field in the database.

So i would just create a SQL query, with a WHERE statement. WHERE change_datetime > $(vSomeVariable)

What would i use for $(vSomeVariable)? last reload time? putting NOW() in a variable just before triggering the SQL database? i think this i would be possible to miss some id's. Yes, it can be in a split second, but it would be possible that someone changes the state of the id, right between settings a variable NOW() and triggering the SQL statement

anyone got a better idea for this?

Re: extracting "real-time" data

Gysbert_Wassenaar — Mon, 04 Mar 2013 09:00:38 GMT

You can get the max value of change_datetime from the data you load with the select statement and put that in a variable at the end of the script. On the next reload you can read out the variable and use it for the where clause of the select statement.

topic Re: extracting "real-time" data in QlikView

extracting "real-time" data

Re: extracting "real-time" data