Common Filter questions on macOS usually fall into 3 areas: missing records, saved filter settings, and clearing conditions; this FAQ includes 3 common answers.
FAQ
Are records deleted if some of them disappear after filtering?
- First, check whether the current view has active filter conditions.
- Open the Filter panel and review the active filter name or conditions.
- Remove the related condition or clear all conditions, then check the records again.
- If the records appear again, they were hidden rather than deleted.
How do I keep the filter conditions I already set?
- Finish setting the filter conditions in the current view.
- Keep the view as it is and exit the current operation.
- The next time you return to the same view, the saved view configuration will be applied automatically.
- If you need different ways to review the same data, maintain separate views for different scenarios.
How can I clear all filter conditions quickly?
- Click Filter on the toolbar.
- Review the conditions that are currently listed in the filter panel.
- Click the delete button next to each condition and remove them one by one.
- After all conditions are removed, the table shows all records again.
Glossary
| Term | Definition |
|---|---|
| Filter condition | A rule that limits which records are shown, based on a field, comparison method, and value. |
| Match all conditions | A logic mode in which a record is shown only when every condition is true. |
| Match any condition | A logic mode in which a record is shown when at least one condition is true. |
| View configuration | The set of display settings used by the current view, which can include filter rules. |