Filter an interactive grid by column, row, or both, with text strings and using operators such as contains and equals.
Parent topic: Customizing an Interactive Grid with the Actions Menu
You can narrow the contents of an interactive grid by applying a filter to it. Once applied, filters can be temporarily enabled or disabled or removed permanently directly in the interactive grid. You can also click the filter name for quick reconfiguration.
Existing filters display between the search bar and the grid.
Rather than deleting a filter, you can disable it by deselecting the adjacent checkbox. You can leave a filter disabled and save your report to preserve it for future usage.
To edit a filter, you can click its name or open the Filters dialog and select it in the list.
You can permanently remove a filter by clicking the adjacent Remove Filter icon (X) or by removing it from the list in the Filters dialog.
Create a row filter to limit the number of rows returned in an interactive grid. Filtering by row filters for a term in any filterable column.
To add a filter to the rows in an interactive grid:
Filter a column in an interactive grid with a specified operator and value.
To add a filter to a column in an interactive grid:
Edit a filter by clicking the name of a filter to open the Filters dialog. The Filters dialog enables you to edit properties of any filter.
To edit an existing filter:
Editable parameters include:
the filter type (row, column, complex)
the name of the row or column the filter applies to
the filter operator
the filtered value
Other filters can also be added, edited, enabled, and removed in this dialog.
Disable a filter by clicking the check box adjacent to the name of the filter.
To disable a filter in an interactive grid:
Remove a filter by deleting it in the Filters dialog or by clicking the adjacent Remove Filter icon (X).
Tip:To temporarily disable a filter, deselect the adjacent check box either within the Filters dialog or above the interactive grid.
To remove a filter, do one of the following: