Setting Up E-mail Trigger Conditions

> Setting Up E-mail Trigger Conditions

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

Create a new trigger or set up an existing trigger to include conditions. To set up an existing trigger to include conditions, click the Conditions tab after selecting the trigger event (Update, Insert, or Delete). Datastream 7i displays the Conditions page as well as the Table and Template selected for the trigger.

Follow these steps to set up e-mail trigger conditions.

Open the Messenger trigger definition form (BXMAIL).

Click the Conditions tab. Datastream 7i displays the Conditions page.

Table—Click to select the Datastream 7i table for which to create conditions.

Mail template—Click to select the e-mail template to be sent with the trigger.

Column—Enter the name of the column on the Datastream 7i table that applies to the trigger.

Condition—Click to select the criteria for this trigger.

Refer to the following table when entering conditions for e-mail triggers:

Condition

Definition

Is equal to

Select this condition if Column is equal to Value 1.

Is not equal to

Select this condition if Column is not equal to Value 1.

Is greater than

Select this condition if Column is greater than Value 1.

Is less than

Select this condition if Column is less than Value 1.

Is greater than or equal to

Select this condition if Column is greater than or equal to Value 1.

Is less than or equal to

Select this condition if Column is less than or equal to Value 1.

Is blank

Select this condition if Column is blank.

Is not blank

Select this condition if Column is not blank.

Is between

Select this condition if Column is between the values of Value 1 and Value 2.

Is not between

Select this condition if Column is not between the values of Value 1 and Value 2.

Contains

Select this condition if Column contains the value of Value 1.

Does not contain

Select this condition if Column does not contain the value of Value 1.

Value1 and Value2—Enter the value of the trigger condition.

Enter values according to the following formats:

Date—To_date (‘23-FEB-1999’,’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-FEB-1999’,’DD-MON-YYYY’)

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%’

Click the Record view tab. Datastream 7i displays the Record view page.

Table (in the lower section)—Click to select the table for this condition trigger.

Select Update, Insert, or Delete to receive e-mail when the condition is updated, inserted, or deleted.

If setting up conditions for an existing trigger, do not to select an event.

Click Create mail triggers. Datastream 7i generates the e-mail trigger.