Setting Up E-mail Notification Conditions

Set up e-mail notifications to send e-mail whenever a specific condition is met.

To set up e-mail notification conditions:

Select Administration > E-Mail Messenger > E-mail Notification Setup.
Specify the table for which to setup e-mail notification conditions.
Select the record for which you want to set up conditions.
Click Create Conditions.
Click Add Condition.

In the Condition Details section, specify this information:

Column

Specify the name of the column on the system table that applies to the e-mail notification.

Condition

Specify the criteria for the e-mail notification.

Value

Specify the value of the e-mail notification condition.

Date: To_date (‘23-OCT-2003’,’DD-MON-YYYY’). For example, if you are entering a date value for a condition that is equal to a specific date, enter the value according to this exact format:


Column	Condition	Value 1
Name of column	Is equal to	To_date (‘23-OCT-2012’,’DD-MON-YYYY’)

Numbers: To_Number (10). For example, if you are entering a number value for a condition that is greater than a specific number, enter the value according to this exact format:


Column	Condition	Value 1
Name of column	Is greater than	To_number (10)

Characters: engine
Contains: %pump%
Note: You must enter a Value 1. The system protects both Value 1 and Value 2 if you enter "is blank" or "is not blank" in Condition. Value 2 is required if you enter "is between" or "is not between" in Condition.
If you update Column or Condition after you enter Value 1 or Value 2, the system clears both of the value fields.

Click Save. The system saves the record and updates the Conditions list.

Note: The system clears Active on the associated E-mail Notification record.
To delete a condition, select the condition to delete, and then click Delete Condition. The system deletes the record and updates the Conditions list.
Click Close. The system closes the E-mail Conditions popup.