The below is the SQL statement to create a user defined trigger that will send an email to the appropriate individual(s) notifying them that an ECO has been approved by all the departments.
SELECT Econo, ChangeType, EcStatus FROM Ecmain WHERE EcStatus = "Approved"
In Trigger setup, User defined trigger, there is a required field "Enter Single Field Name", please enter "Econo" in it.
|