Does anyone know if it is possible to create a scenario whereby a notification email is sent if an order with a duplicate CustomerOrderNbr is created?
I thought perhaps I could create a GI with aggregated results - grouped by the CustomerOrderNbr field - with an OrderNbr count, but according to this article GIs with Grouping are not supported by Business Events:
Anyone know of a different approach that would solve this?
Best answer by bryanb39
Try this:
Self join SO.SOOrder
CustomerID = CustomerID
CustomerOrderNbr = CustomerOrderNbr
OrderType = OrderType
OrderNbr <> OrderNbr
You may need to tweak it a bit if Order Type doesn’t always match, but you also don’t want to include CMs or RCs.
This would only return orders that are duplicates with no grouping or aggregation needed.
To do a self join, add the table again, you can give it an alias, I just called it SOOrder2 in this case.
Hi Mike,
Have you tried conditioning the GI so that it only shows orders which have a duplicate value?
Then the BE might work better to trigger only off Record Inserted instead of multiple conditions.
Hi
Hi
NOTE: In this case I’m checking the CustomerRefNbr field for duplicates.
+13hI
Do you want to stop duplicate order with same customer reference or you need just an email.
If you are looking for avoid order with duplicate customer order nbr please set below preference
Hi
+13Hi
Seems to it is critical to anaylse the duplicate customer order nbr and trigger an Business events, Use standard functionality or else we need to see other suggestions as well.
Thanks
+6Try this:
Self join SO.SOOrder
CustomerID = CustomerID
CustomerOrderNbr = CustomerOrderNbr
OrderType = OrderType
OrderNbr <> OrderNbr
You may need to tweak it a bit if Order Type doesn’t always match, but you also don’t want to include CMs or RCs.
This would only return orders that are duplicates with no grouping or aggregation needed.
To do a self join, add the table again, you can give it an alias, I just called it SOOrder2 in this case.
Thank you,
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.
