How to use Advanced Filter?
Advanced Filter tool in Events Reports allows you to filter report data based on complex filter conditions. Unlike Quick Filter, Advanced Filter gives the user the ability to create filter conditions that include one or more fields in the report and is also capable of reporting fields with empty values in the report.
The Advanced Filter tool is available below the report grid in the right pane as shown below:
 
   
 
To apply a filter to the current report, select the filter from the Advanced Filters drop-down and click on button.
 
To remove a filter applied to the current report, select No Filter Applied from the Advanced Filters drop-down and click on button.
 
Create a new filter
 
Click on to create a new advanced filter for the current report.
 
The Filter window will appear as shown below:
  
 
  
To set a filter condition, perform the following steps.
  1. Specify a name for the filter.

  2. Choose a field name, an operator and a possible value from the respective drop-downs.

  3. Click the button to add the filter condition.

  4. The Add to Filter button will change to AND to Filter. OR to Filter button will be enabled. The selected condition will be added as shown below.

   
  
 
  1. Click Save to apply the filter to the current report. Also, the filter will be saved to the filter database for future use.
The report status label above the grid, shows the filter status "Filter:" followed by its current status.
For a normal view, the filter status will appear as
For a filtered view, the filter status will appear as
Note:
  • Click to clear all the filter conditions in the list.

  • Use   and   to build enhanced filter condition as shown below:

  • ([Change Type]= 'Modified (Value Added)' AND [Property Name] = 'Telephone Number') OR ([Object Name] = 'Alex' AND [Property Name]= 'E-mail')

  • Use    to remove the parenthesis

  • Use to delete a condition from the list of filter conditions. This will remove the currently selected filter condition from the list.

Edit an existing filter
 
To edit an existing saved filter, select the filter from the advanced filters drop-down and then click the button. The filter window will appear on the screen. You may edit the fields-list and filter conditions. Also, you can choose to save the filter in a different name, retaining the original filter, or overwrite the existing filter with the new filter conditions and fields-list.
 
Delete an existing filter
 
To delete an existing filter, select the filter from the advanced filters drop-down list and click the button.
However, if the filter is already applied to a report, ADChangeTracker clears the filter in the report and deletes the selected filter.