If this can't be done via trackit, what others option have I got?
I'm thinking about implementing a trigger to monitor the workorder table and tigger an event...
Any help or suggestions would be greatly appreciated.
Bahh Foiled.. damnit..
I just spent 2 days developing and implementing a database trigger which would send an email if it detected a change in the priority on the tasks table. The prototype and proof of concept worked perfectly...
However... when I tested this on a live trackit system it immediately threw an error. An existing trigger was expecting a certain number of events and it now gets a different number. (because of the additional trigger firing..)
Back to the drawing board...