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.

All

Show records regardless of selected or unselected status.

Selected

Show only selected records.

Unselected

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

 

Filters

 

Tables

 

Selection

 

Queries

 

View - Order

 

Command Window

 

Table Windows and Big Data

 

Videos

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.