Define Report Filters Panel

AdminStudio 2023 | 25.0 | Reports

Edition:This panel is available in Workflow Manager only.

On the Define Report Filters panel of the Reports Wizard, enter a filter to define the data that you want to include in this report.

The Define Report Filters panel includes the following properties:

Select Report Filters Panel of the Reports Wizard

Option

Description

Available Fields

Select a field from this tree to use to create a filter. When you click on a field to select it, all of its values populate the Select a value for this filter list.

Set Filter Area

Use the following fields to create a filter to apply to this report:

•

Select a value for this filter—All of the values of the selected field are listed. Select the one that you want to use to create this filter.

•

or alternatively type in a value for this filter—If you want to use a value that does not appear in the list, type the value in this text box.

•

Operator list box—Select an operator from this list box to specify how you want the value in the selected field of each record to be selected, such as Equal, Greater Than, Less Than, etc.

•

Add—After you have set a filter, click Add to add the filter to the current filter conditions. It will be added to the Test Query box below, and a query is automatically run to determine if this filter generates any records.

•

Conjunction Express List (AND, OR)—After you have set one filter, and want to add another, select a conjunction from this box before you click Add to specify whether the record must meet both filter conditions (AND) or only one filter condition (OR).

•

Test Query—Click to run the specified query to determine if the filter combination generates any records. If no records are found, you are prompted to change the filters.

•

Reset All—Click to remove all filter conditions.

When you have finished defining filters, click Next to continue with the Reports Wizard.