Hello All,
Scenario:
Change request A is submitted for service "Application Management" for 11/9/2017 at 20:00 by Joe Snow. At the time this change is created no other change requests are in the system for the same service or schedule so no conflicts are detected.
Change request B is submitted for service "Application Management" for 11/9/2017 at 20:00 by Mike Smith. Since Change A is for the same service and same window this triggers a conflict that needs justification to be filled out before they can proceed.
Mike Smith then populates the justification on why these 2 change requests can be done at the same time.
What I would like to do:
Since change request A now has a conflict due to change request B I would like to send an email notification to Joe Snow to let him know a conflict has occurred on his change request so he can investigate the conflict and fill out the justification before going to CAB meeting.
What I have done so far:
I have created a notification on the change_request table that has the below conditions. This does send a notification to Joe Snow but sends same notification more then once. I have tried to do on inserted and not updated but then this notification won't send at all.
What I am trying to solve: I would like to make sure that only one notification is send to Joe Snow to let them know that they now have a conflict that needs to be justified because a change request by someone else has caused it. This gives Joe Snow creator of change request A a chance to look into this and fill out the mandatory conflict justification field before it is brought up in our CAB meeting and looks like it was missed.
Thanks for your help and if my approach is wrong, I am open to other ideas.
