Interactive filters on database views and table hierarchies

When you create an interactive filter on an extended table, you can also apply the filter to database views and to the other tables in the hierarchy. The hierarchy includes all parent, child, and sibling tables.

When you create an interactive filter, you can:

Select All tables in the hierarchy.

If the source table is incident, then the interactive filter applies to incident; its parent table, task; and to all of its sibling tables, including problem and change.

Specify any possible targets in the Interactive Filter References section for this selection to be respected.

Select Apply filter to both database views and tables.

If the source table is incident, then the interactive filter applies to both incident and, for example, the [incident_sla] database view.

Specify any possible targets in the Interactive Filter References section for this selection to be respected.

Select both check boxes.

The interactive filter applies to all tables in the hierarchy and to database views.

Select neither check box.

Interactive filters apply only to the source table, such as incident.

Note:

This is the default setting when you create an interactive filter.

Interactive filters applied to extended tables also apply to the other tables in the hierarchy.

Note:

Interactive filters on a database view do not apply automatically to the siblings of the database view's source table. For example, [problem_sla] is a database view created on the table [task_problem]. Interactive filters applied to [problem_sla] do not apply automatically to widgets based on the [task_change] table, a sibling of [task_problem], even if you have selected both options.