View - Filter

Appears with tables.   Provides commands to manage filters.


 When filters are active in a table window, press the Filter button in the main toolbar to re-apply a filter to account for any changes in a table.  For example, if we have the Selected filter active to show only selected records in a table, and then we change the selection using the Select pane or by clicking associated records in a map window or other window, pressing the Filter button will update the table to show the new selection.



 Reapply Filter

Reapply the current filter settings.   Used to refresh filters when the data in tables may have changed.   This is not a command to restore previous filters that may have been cleared.    Same as pressing the Filter button in the main toolbar.

Clear Filter

Clear any filters applied.


Show records regardless of selected or unselected status.


Show only selected records.


Show only records that are not selected.

<filters list>

A list of all filters that have been applied.  

Filter Fetched Records Only

When checked (the default) only those records currently fetched for display in the table window will be filtered.  Unchecking this box filters all records in the table up to the display limit.

Filter using Query

Open the Command Window loaded with a query which performs the current filter settings.


See the Filters topic for details and examples.


See Also

Sorting Columns










View - Order


Command Window


Table Windows and Big Data



Manifold Future - Five Minute Filters Quickstart - This five minute video shows how, using points of interest in Monaco to show how to combine filters on two different fields, and then we switch gears to show how two filters on the same field can be applied in seconds to get exactly the records we want.