Cancel event

[Eli Guttman]

Hi,

We have set some business rules in incident table that schedule an event to be triggered in a few more days.

According to the changes in the incident state, we may need to cancel the triggered event.

How can i find the event related to the incident the cancel it?

Thank you

[cwilker10]

At the bare minimum you could pass the sys_id of the incident as one of the event.parms and you could query on that.   Once you find the event you want to cancel you can change the state to "processed" and that will keep it from being affected by any other logic.

[Eli Guttman]

Hi,

That was my initial thoght, but i already use 2 parameters in the event and i prefer to leave it as is, if i can find another solution.

Is there any other way i can find the relation between the event and the incident it was created from?

[tltoulson]

Hi Eli,

Here are some fields of interest for you on the sysevent table:

Instance: Seems to carry the sys_id of the record from which the event was fired which is what you requested

State: You will want to find those events in the Ready state

Process On:   The Date/Time the event should be processed, you may be able to change this value rather than just deleting and rescheduling

Events are queued by the gs.eventQueue and gs.eventQueueScheduled functions but they appear to be fired by the "events process" scheduled job which I would assume processes any events whose Process On is prior to Now, with Now being the moment the scheduled job is run.