All,
I am trying to refine a BPM to send an email alert when the Required By Date changes from Any to Another. Currently I have two Data Directives; the first is an InTransaction directive on the OrderRel table.
The conditions are as follows:
If OrderRel.ReqDate has changed from Any to Another
If OrderRel.Part number of the updated row begins with “AA” There are additional conditions for part numbers.
This directive enables a standard directive that sends an email to users when the criteria are met.
A couple of issues that I have are that I had to add the conditions to the Standard Directive for the email to trigger off of the right records. If I ommit the conditions an email is sent for every order that gets a ReqByDate change.
First question: Does the standard directive not use the InTransaction conditions to send the email?
Second: When I add the conditions to both I get two emails per order change but only for one of the part number conditions. Should I expect that behavior? I am also getting emails for added records that contain no previous required date sense the records are new.
I have been trying to get this BPM working correctly for a little while and I am not sure how to move forward. I have also experimented with Pre and Post Method Directives. The problem that I encountered with Method Directives is not having access to the Previous Required by date, I saw some post saying that a query could get the previous date but I haven’t been able to figure that one out. Thank you for any help.