Drop-Down Filters
  • 04 Dec 2023
  • 2 Minutes to read
  • Contributors
  • Dark
    Light
  • PDF

Drop-Down Filters

  • Dark
    Light
  • PDF

Article summary

To refine the data displayed, most screens have drop-down filters at the top of the screen as indicated in the example below.

Filter Drop Down

Filter Note

Filter options will vary per screen, they are related to the information available in the module.

  • Click on a filter category or drop-down next to it to display a scrollable list of options with a search bar above the list.
    Filter%20Drop%20Down1

  • The search bar will narrow the choices available for the filter based on the characters entered. It is not case sensitive and will match the character string provided.
    Filter%20Search

  • A chosen filter will persist as you navigate to different screens, if available on the new screen.

  • When navigating to a Details screen from an Overview, it is required to select an Instance, Host, and/or Database, depending on the module, to view detailed data.

  • Some filters will only allow a single selection, but most filters allow multiple selections. There are 3 choices available for each object in the drop-down, unchecked, checked, or an [X].

    • A checkmark is used to note the selection(s) for a filtering.
      • Click on an unchecked selection to select it for filtering, a checkmark will display to the left of the selection.
      • Only the selections displaying a checkmark will have data displayed.
      • There may be 1 or more selections with a checkmark.
    • An [X] indicates a selection(s) that is(are) excluded from the data displayed.
      • To select an choice for exclusion, the selection must be clicked twice. First to display a checkmark (inclusion), second to display the [X] for exclusion.
      • More than 1 selection may be excluded from the filter.
    • No mark next to a choice indicates it has not been selected.
      • Any selected filters, include or exclude, will always be displayed at the top of the selection list.
      • No selected filters results in an unfilter view of the data being displayed.
        Include_Exclude_Filters
  • Multiple drop-down filters may be selections.

    • All selections are included in the data displayed
      Multiple%20Filters
  • Filters may be modified via other methods. On some charts or tables, and Slicers, a Host, Instance, Database, Wait Type, Program Name, and/or Logins can be quickly added or removed (excluded) to or from filters.

    • When the pointer hovers over a name, a down arrow will appear to indicate the ability to click on the name to display the options to add [+], remove [-], or copy the name.
      • The add and remove options will add the selection to the filter as either include with the [+] or exclude with the [-].
        Slicer%20Filter%20Options
  • The blue Reset button next to the drop-down filters will reset all filters on the screen, resulting in an unfilter view of the data.
    Reset


Was this article helpful?