Filter Dialog Box - MapInfo_Pro - 2023

MapInfo Pro Help
Product type
Software
Portfolio
Locate
Product family
MapInfo
Product
MapInfo > MapInfo Pro
Version
2023
Language
English
Product name
MapInfo Pro
Title
MapInfo Pro Help
First publish date
1985
ft:lastEdition
2023-09-12
ft:lastPublication
2023-09-12T16:39:16.995549

This dialog allows you to specify filtering conditions, so that the browser will only show the rows that satisfy the conditions. Please make note of:

  • When typing in a filter for a character column, you do not need to enter quotation marks.
  • You cannot type function calls or other expressions into the Filter dialog box.

    TIP: If you need to apply a filter to an expression, first use the Pick Fields dialog box to add the expression column to the Browser window, and then right-click on the expression column to apply a simple filter.

The first item that displays at the top of this dialog box is the column that you selected in the Browser window to filter.

CAUTION:
Hiding a row does not fully protect the row from being selected, edited, or even deleted. Although filters let you hide rows in a Browser window, editing operations may still affect the hidden rows. As an example, on the TABLE tab, in the Edit group, click Update Column to update every row in a table, even rows that are hidden. Also, after filtering a Browser window, you can still select the hidden rows by executing SQL queries or by performing a mouse selection in a Map window. To limit an editing operation, so that it affects only the visible rows in a Browser window, on the TABLE tab, click SQL Select. This command creates a named query that represents the Browser window's visible rows. When you perform other commands on that query table, such as Update Column, those commands affect only the visible rows.
Note: The query table is a snapshot of the current Browser window contents. Modifying your filter conditions does not regenerate the query table.

First drop-down list

Select the filter type to apply, such as Equals, Does not Equal, Contains, Does Not Contain, Begins With, Ends With, and Is Empty.

First textbox

Enter the text to use for this filter. You do not require quotation marks or wildcard operators.

And, Or

Select an operator to apply to the filter: And the next selections, Or the next selections.

Second drop-down list

Select the filter type to apply, such as Equals, Does not Equal, Contains, Does Not Contain, Begins With, Ends With, and Is Empty.

Second textbox

Enter the text to use for this filter. You do not require quotation marks or wildcard operators.

Apply

Applies the filter conditions and updates the browser window. The dialog remains open so that you can modify your filter conditions if needed.

Close

Cancels the settings and closes the dialog box.

Clear Filter

Clears the column filter (the filter for the column that you right-clicked), and updates the browser window. The dialog remains open so that you can create new filter conditions if needed.

Reset

Clears all selections and text entered in the dialog box, so that you can re-enter new ones.