PowerExchange for Email Server User Guide for PowerCenter

10.5
- 10.5.4
- 10.5.1
- 10.4.0

Back Next

Filtering Source Data

You can filter data that you want to extract from an email source. You can define filter criteria for the source definitions that are based on the email data.

The following table describes the filter conditions for the fields in email folders:

Field Name	Filter Condition	Description
Msg_No	less than	Retrieves emails with message number less than a specified number.
Msg_No	greater than	Retrieves emails with message number greater than a specified number.
Msg_No	equals	Retrieves an email with a particular message number.
Msg_No	between	Retrieves emails with message numbers within a specified range.
Size	less than	Retrieves emails of a size less than a specified number.
Size	greater than	Retrieves emails of a size greater than a specified number.
Size	equals	Retrieves emails of a size within 1 KB range of a specified number.
Size	between	Retrieves emails of a size within a specified range.
From	contains	Retrieves emails from a specified email ID.
To	contains all of	Retrieves emails that contain all the specified email IDs in the To field.
To	contains any of	Retrieves emails that contain any specified email ID in the To field.
CC	contains all of	Retrieves emails that contain all specified email IDs in the CC field.
CC	contains any of	Retrieves emails that contain any specified email ID in the CC field.
BCC	contains all of	Retrieves emails that contain all specified email IDs in the BCC field.
BCC	contains any of	Retrieves emails that contain any specified email ID in the BCC field.
Sent_Date	before	Retrieves emails sent on or before a specified date.
Sent_Date	after	Retrieves emails sent on or after a specified date.
Sent_Date	on	Retrieves emails sent on a particular date.
Sent_Date	between	Retrieves emails sent within a specified date range.
Recv_Date	before	Retrieves emails received on or before a specified date.
Recv_Date	after	Retrieves emails received on or after a specified date.
Recv_Date	on	Retrieves emails received on a particular date.
Subject	contains phrase	Retrieves emails with the exact phrase specified in the subject field.
Subject	contains all words	Retrieves emails that contain all the words specified in the subject field.
Subject	contains any word	Retrieves emails that contain any word specified in the subject field.
Content	contains phrase	Retrieves emails with the exact phrase specified in the content field.
Content	contains all words	Retrieves emails that contain all the words specified in the content field.
Content	contains any word	Retrieves emails that contain any word specified in the content field.

Use the following guidelines when specifying a filter condition:

To filter emails based on the To, CC, and BCC fields, separate multiple email addresses with commas. For example:

abc@yahoo.com,def@yahoo.com

You can specify the following email address types:

SMTP. For example:

abc@yahoo.com

Exchange-based email address. For example:

/O=P S P L/OU=FIRST ADMINISTRATIVE GROUP/CN=RECIPIENTS/CN=Administrator

To filter emails based on the Sent_Date or Recv_Date fields, specify the date in the MM/DD/YYYY format.

To filter emails based on the Msg_No, Size, Sent_Date, and Recv_Date fields, use the “between” condition. For example, use the following filter condition to retrieve emails which are of size between 2000 and 3000, including 2000 and 3000:

Size between 2000,3000

To filter emails based on the Subject or Content field, specify the “contains all words” or “contains any word” condition as value1,value2,value3. For example:

abc,def,xyz

You can define one condition for each field. All the email messages that match the condition are retrieved.

Rename Saved Search

Table of Contents

PowerExchange for Email Server User Guide for PowerCenter

PowerExchange for Email Server User Guide for PowerCenter

Filtering Source Data

Filtering Source Data