Filters
Filters let an editor define a precise table view and decide how much control readers have over it. They use the same bar as Search, but filters are saved rules applied to the table data.
Three ways to use filters
- Create a filter interactively from the Filter mode in the table bar.
- Save a preconfigured filter as the table's default view.
- Hide the saved filter from readers so it cannot be changed without page-edit permission.
Create a filter
- Enable Filter bar in Display settings.
- Switch the bar to Filter, then select Add filter….
- Choose a column, an operator, and the value or values to match.
- Select Apply filter. The rule appears as a chip; select the chip to edit it or remove it with its close button.
Operators depend on the column type: text supports contains and empty checks; enum and boolean fields support selecting values; numbers support comparisons and ranges; dates support on, before, after, and ranges with suggestions such as Today and Last 7 days.
Build a preconfigured filter
In Display settings, enable Filter bar and choose Filter as the Default filter view. Build the rules in the live table preview, then save the macro. Those rules are loaded with the table and become the default result for every viewer.
New rows are evaluated against the saved rules whenever the table data loads. A reader can adjust visible controls for their current session, but cannot change the saved default. To update the default filter, reopen the macro settings, change the rules in the preview, and save again.
Hide a filter from readers
After choosing Filter as the default view and saving at least one rule, Hide filter bar for viewers becomes available in Display settings. Turn it on to apply the saved filter without showing its chips or controls in page view, edit mode, or full screen.
The filter continues to run in every view, but readers see only the filtered rows and cannot modify or remove the saved conditions. Editors still see the full filter bar in macro settings, where they can update and save the default view.
The published view keeps a compact search field for searching within the already-filtered results. That search is temporary: it does not remove, alter, or reveal the saved filter.
Incognito columns are unavailable when editors build filters, so a saved filter cannot expose data intended only for editors.
Combine conditions with AND and OR
Inside each group, choose All to require every rule or Any to match at least one rule. Add another group for a separate set of rules and choose AND or OR between groups.
All / AND
Status is Open AND Due date is in the next reporting period. A row must satisfy both rules.
Any / OR
Priority is High OR Priority is Critical. A row matching either value is included.
Use groups when the logic needs parentheses, such as “(Team is Support OR Team is Success) AND Status is Open”.
Search and filters are different
Search looks for text across visible columns and is intended for quick lookups. Filters are typed, saved rules that control which rows are included. Both modes live in the same table bar, but only filters define the preconfigured reader view.
See Search for the global search workflow.
Want to try it in your site? InstallSimple Tables for Confluence from the Atlassian Marketplace.