We have a custom event that executes on a change to APPROVAL_ROUTING_TAB. The problem for us is we don’t want that to execute when the reason the record changed in the Approval_ROUTING_TAB is that a prior step in the approval process was deleted. (Users are supposed to remove steps from the bottom up to avoid this but frequently forget.)
Is there a way I can tell that? Do other fields besides LINE_NO get updated when a prior step is deleted? Would it work to add an outer IF statement on the Event Action SQL code something like
If &NEW:LINE_NO<&OLD:LINE_NO AND (All other fields New = Old) then
--skip the action because prior step was deleted.
else
--insert the existing sql code here
end if;