How to use Filter?
You can filter the report data based on a filter condition. The filter criteria can be specified based on columns in the report to match certain values of the data.
 
You can apply a report filter condition by performing the following the steps:
 
  1.  
Click Filter button in the toolbar available in the report window or press F3 to launch Filter window. Filter window will be displayed as shown below:


 
  1.  
In the Filter window, select any column from the Field drop-down.
  1.  
Select an operator from the Operator drop-down.
  1.  
Select or enter a value in the Value drop-down.
  1.  
Click Add to Filter button to add the 'Time Stamp' field value to the filter list.
  1.  
Use 'AND to Filter' and 'OR to Filter' to build enhanced filter conditions. The 'AND to Filter' and 'OR to Filter' buttons will be visible for fields other than 'Time Stamp' field.


 
  1.  
The selected condition will be set as a filter and displayed (as shown below).  
  1.  
Click OK to apply the given filter settings and generate the filtered report output.
  1.  
Click Cancel to abort the filter action. .
  1.  
The various operators available in Filter window are given below:

Operator

Applicable Data types

Description

Example

=

String, Numeric, Boolean, Date

Column value matching exactly with the specified value data

[From] = '11/5/2011 12:00:00 AM'           [To]='11/20/2011 11:34:45 PM' 

<>

String, Numeric, Boolean

Column value not matching exactly with the specified value data

[Message Subject] <> 'Administrator'

>

Numeric

Column value greater than the specified value data

[Recipient Count] > 1024

>=

Numeric

Column value greater than or equal to the specified value data

[Recipient Count] >= 1024

<

Numeric

Column value lesser than the specified value data

[Total Bytes] < 5000

<=

Numeric

Column value lesser than or equal to the specified value data

[Total Bytes] <= 3000

starts with

String

Column value starts with the specified value data

[Message ID] starts with '<as@fd'

ends with

String

Column value ends with the specified value data

[Client IP] ends with '110'

does not start with

String

Column value does not start with the specified value data

[Recipients] does not start with 'Ela'

does not end with

String

Column value does not end with the specified value data

[Event ID] does not end with 'Bad Mail'

contains String Column value contains the specified value data [Internal Message ID] contains '12'
does not contains String Column value does not contain the specified value data [Sender] does not contains 'JoSwa'


The various operations that can be performed in the Filter window are given below:
 

Operation  Description
Add to Filter Click Add to Filter button to add a condition to filter list, if the filter list is empty.
AND to Filter Click AND to Filter button to add a condition with logical 'AND' operator to filter list.
OR to Filter Click OR to Filter button to add a condition with logical 'OR' operator to filter list.
Remove Select any condition in the filter list and Click button to delete the selected condition. [Time Stamp] values cannot deleted.
Reset Click button to delete all the conditions in the filter list and reset the [Time Stamp] values.