New post
0

Event based schedule query

Hello,

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

1 comment

  • Avatar
    Johnathan Lucky Official comment

    andyw,
    I assume you have parsed that query through the database and returned data in CRD, correct? If not, you may need to redesign the query.
    Also, to confirm the setup of this schedule, your desire is to have an event occur whenever a new result is added to records that fulfill your query? Because that is what seems indicated by your settings.

    In any event, to increase the timeout quality of your queries, this change would have to be made at the database level: editing the database properties in MS SQL management (or your choice DB management client) -> Open the connection properties of your database/table and view the connection Timeout value. You will need to write a query to change this value.

    I hope this information is helpful. If you have further issues setting up the desired schedule, we may need to schedule a consultancy.

    Regards,
    CSS Support

Please sign in to leave a comment.