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
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.
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.
