Table IWA_TaskSignalEventReceiver

Tasks that are or have been waiting for a signal event as well as the tasks that were triggered by such an event

Columns

Primary Key Name Type Length Precision Can Be Null Default References Action Hints Comment
true TaskSignalEventId BIGINT false
false WaitingTaskId BIGINT false IWA_Task(TaskId) ON DELETE CASCADE Java , MsSqlServer , MySql Identifies the task, the entity belongs to. This task will be destroyed if a signal is received that matches the pattern.
false SignalCodePattern VARCHAR 200 false Oracle The pattern the task is waiting for
false SignaledTaskTaskStartId BIGINT false IWA_TaskStart(TaskStartId) ON DELETE CASCADE Task start on which the signaled task has to be started if the signal is received.
false StartedSignaledTaskId BIGINT true IWA_SignaledTask(SignaledTaskId) ON DELETE SET NULL MsSqlServer , MySql Id of the signaled task that has been started after the signal was received

Indexes

Name Columns Hints Comment
IWA_TskSigEvntRcvr_WtingTaskId WaitingTaskId
IWA_TskSigEvntRcvr_SgTskTskId SignaledTaskTaskStartId
IWA_TskSigEvntRcvr_StrtSgTskId StartedSignaledTaskId

Java

Object AsParent BusinessClass ClassName
IWA_TaskSignalEventReceiver ch.ivyteam.ivy.workflow.signal.ITaskBoundarySignalEventReceiver TaskBoundarySignalEventReceiver
WaitingTaskId true

Cache

Object Strategy
IWA_TaskSignalEventReceiver ALL_REMOVE_UNUSED

MySql

Object NoReferenceUseTrigger
WaitingTaskId true
StartedSignaledTaskId true

MsSqlServer

Object NoReferenceUseTrigger
WaitingTaskId true
StartedSignaledTaskId true

Oracle

Object ConvertEmptyStringToNull
SignalCodePattern true