Hi ,
1. I want to set up an email notification when a particular opportunity (oppo_description) is being lost.(oppo_stage = 'Lost').
I am not able to get through the 'Escl_xxx' variables.( Escl_WorkflowRuleId, Escl_EscalationId etc.. - their usage) . Can someone help me with the SQL trigger clause for this please?
2. Also, there was an email notification being set up whenever a high value opportunity(based on forecast) was being created. Unfortunately, the email notifications are going uncontrolled. They keep on coming after 5-10 minutes rather than just notifying once in the mailbox.
The trigger used here was:
#U=1 and oppo_forecast > '100000' and oppo_status='In Progress' and ((Escl_EscalationId is NULL ) OR (Escl_WorkflowRuleId <> 10167) OR ((Escl_WorkFlowRuleId = 10167) and Escl_Datetime
I tried checking the Administration -> Advanced Customization -> Workflow & Escalation Configuration : Notify interval (sec) field but that didnt work out, nor Notification Display Count field.
Can someone help me on this?
Thanks