The requested page is not available for the requested platform. You are viewing the content for Default platform.

Filter Editor

  • 2 min to read

This document describes the Filter Editor available in the End-User Report Designer.

Filter Editor Overview

The Filter Editor provides a visual interface for constructing filter criteria of varying complexity with an unlimited number of filter conditions combined by logical operators.

web-rd-filter-editor

A filter condition consists of three parts:

  • A field of a data source to which a report is bound.
  • Criteria operator, such as Equals, Is less than, Is between, etc.
  • A static operand value, another data field or a report parameter.

You can arrange specific conditions into groups with And, Or, Not And, and Not Or operators.

Invoking the Filter Editor

You can invoke the Filter Editor in one of the following ways:

Tree-Like Filtering

The Filter Editor displays filter criteria as a tree where individual nodes specify simple filter conditions. The root node is the logical operator combining all the conditions.

Click the plus button next to the operator to add a new condition or group.

web-rd-filter-editor-add-condition

You can select the required data field and comparison operator from the corresponding drop-down lists and enter an operand value in the dedicated value box.

web-rd-filter-editor-simple-condition

Expand the drop-down menu for a value placeholder and select Property or Parameter to compare a data field with another data field or a report parameter. Then, click the converted placeholder and select the required item.

web-rd-filter-editor-value-parameter

You can change the logical operator by clicking it and selecting the desired type.

web-rd-filter-editor-change-logical-operator

Click the filter condition's web-rd-filter-editor-remove-button button to delete it.

Text-Based Filtering

In the advanced mode, the Filter Editor allows you to type a filter string manually.

web-rd-filter-editor-advanced-mode

Refer to the Expression Constants, Operators, and Functions topic for the list of available operators and functions and for details on their usage.

This editor supports intelligent code completion (suggesting functions and available data columns as you type).

web-rd-filter-code-completion

The expression-editor-error-icon icon appears if a condition contains any errors.