PowerExchange for Email Server User Guide for PowerCenter

PowerExchange for Email Server User Guide for PowerCenter

Filtering Source Data

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.