I am struggling with event based schedules.
I have the following query I have written and assigned it to 'database record exists'.
SELECT Pat.* FROM Pat WHERE (Pat.Ward NOT LIKE '%HOS%' AND Pat.Ward NOT LIKE '%VL%' AND P_TYPE='I' AND DORDER=1 AND CAUTH='Y')
There is a unique identifier for each line in the database which I have selected and told it to detect 'new records only'.
Basically the 'CAUTH field' changes and I need to know when it goes to 'Y', I do need it to detect lines of data currently in the database also. So not sure if I need to be writing a 'database record has been modified' query? But I have tried and failed.
The table is huge talking 10,000s of lines of data. So not sure if CRD can’t handle the amount of data, I am getting timeout errors and have tried changing the auto-calculate etc. Or am I just not doing it correctly?
Any advice or guides would be great, I have watched the youtube videos but I think my queries are slightly more complex.
Many thanks, Andy