I have BPM that create email notifications when requisitions are send to dispatchers for approval.
The BPM itself works as it should. The issue I have is that for some reason the ReqHead.ReqNum and the ReqHead.CommentText fields duplicate. I used the “field query” option to get the data.
Below are the Output and template definition for the email.
Output
Template Definition
In your field query you probably have all 4 options ticked - unchanged, added, changed, deleted? It’s picking that value from the updated and unchanged row.
Change the options to added, changed and you should only get 1.
Also look at the setting that says “with rule” - if there are multiple rows flowing through the BPM the default is “run once for all rows”. Change that setting to “row once for each row”.
The one titled “for each matching” - test it and see what you get. If you get 2 copies of the same email instead, then you can control what rows are processed in the Standard (post processing) directive by creating an In-Trans (pre processing) directive which contains a condition block (looking for where the row in table tt has been added or updated) and then if true an “Enabled Standard Directive”.
In your Standard directive you then start with a condition block saying (this directive has been enabled by the following xx directive). That will filter out the unchanged row and you’ll be back to a single email.
