Using Report Filters

On the Report Filters page, you can view, edit, and create report filters, which you can use to limit report results according to a set of pre-defined conditions in one or more reports (and feeds). With report filters, you can define search criteria once, and then reuse the same criteria across several different reports and feeds. This means when you create or edit reports, you can select an existing report filter on the Search Filter tab instead of having to define the same report conditions multiple times in multiple reports. This also applies to the field specification when you create a feed in Work Center.

Report filters also simplify report maintenance. For example, if a user leaves the company, you can remove the user's name from a single report filter instead of editing each report that uses a similar Search Filter with the user's name and removing the name multiple times.

Business rules that designers create in SBM Composer can be reused as report filters throughout your reports in SBM. Report filters that are tied to rules defined in SBM Composer do not have an Author, and cannot be edited or deleted like other report filters in Work Center.

Each report filter is assigned an Access level that determines who can view, edit, and delete the report filter. Note the following about each access level:

Creating a Report Filter

To create a new report filter:

  1. In the side menu, click Reports.
  2. Click Report Filters.
  3. Click Create Filter. The New filter dialog box appears.
  4. In the Filter name field, enter a name for the new filter that clearly identifies the filter that you are creating. For example, if you intend to use the filter to limit report results to active items that are assigned to the development team, you might call the report filter Active Items with Development.
  5. In the Filter description field, enter a description that summarizes or explains the filter's conditions.
  6. In the Access drop-down list, set the access level for the report filter. Public filters are available to all users; Private filters are only available to the current user.
  7. In the Filter Conditions group box, define the conditions that the filter will use to limit report results. For guidance on working with basic search conditions, refer to "Using Basic Conditions in SBM Reports" in the SBM Reporting Guide.
  8. Click Save filter. The new filter appears and it is now available to use when you select (Filters) from the Fields drop-down list in the Field Specification portion of a report's search filter or a feed's search criteria.

Editing Report Filters

To edit an a report filter:

  1. In the side menu, click Reports.
  2. Click Report Filters. A list of available report filters appears in the right pane.
  3. Use the Search field to find a report filter by name. Use the Author, Application, and Access facets to refine the list of report filters that are displayed.
  4. Click anywhere on a report filter row to open a read-only view. Click the pencil icon to edit the report filter. The Edit filter dialog box appears.
  5. Make any necessary changes to the report filter. When you change an existing report filter, lists of reports and feeds that currently use the filter are displayed at the bottom of the dialog box. These provide an immediate view into the impact of changing the filter. Click a report name to launch an impacted report.
  6. Click Save filter to save your changes. The filter is updated and any report or feed that uses the filter will now use the new search criteria.

Removing Report Filters

To remove a report filter:

  1. In the side menu, click Reports.
  2. Click Report Filters. Your report filters are listed in the right pane.
  3. Use the Search field to find a report filter by name. Use the Author, Application, and Access facets to refine the list of report filters that are displayed.
  4. Click anywhere on a report filter row to open a read-only view. Click the trash icon to delete the report filter. The Delete filter dialog box appears.
  5. Lists of reports and feeds that currently use the filter are displayed at the bottom of the dialog box. These provides an immediate view into the impact of changing the filter. Click a report name to launch an impacted report. Otherwise, if you are sure you want to delete the filter, click Delete filter. The filter is deleted. Associated reports and feeds will no longer use the filter as part of their search criteria.