In the Sales Opportunites i have 5 stages.
As soon as new enquiry come i will enter the details in the sales opportunities module. In the Stage tab, i will enter the 1st stage as Lead. When i enter the second stage i need to send the alert message to design department user.
I need to send only the new lead number which i have entered. And when i have changed from "Design" to other stage. Alert message should not come to "Design department". For the i have used the below query.
SELECT T0.[OpprId], T0.[Line], T0.[SlpCode], T0.[Step_Id] FROM OPR1 T0 where Step_Id = 2 and OpprId = (select max(OpprId) FROM OPR1)
But when i used this query if i change the stage of the lead from "Design" to other, still alert message is forwarding to "Design" department.