How to Setup a Trigger for when ALL Depts have Signed Off an ECO
The below is the SQL statement to create a user defined triggerthat 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.
Article ID: 3208
ManEx, Inc. Content intended for information only. Do not redistribute without written consent.
