Row Picker 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
Last updated
2023-09-12
Published on
2023-09-12T16:39:16.995549
Note: For WFS layers, the operators for geometry columns are available only if a map is open.

Conjunction

When rows are being filtered from more than one column, Conjunction becomes available. Choose one of these boolean operators: AND, OR, AND NOT, OR NOT.

Column

Choose the column(s) for which you want to filter rows.

Operator

If you are filtering rows for one column, select a column, operator, and value. If filtering rows on more than one column, select a column from the next drop-down list. This will also activate the Conjunction field.

The Operator list boxes contain all supported operator symbols for their corresponding selected column. The list of operators will vary depending on the type of the selected column. For example, the operators <, >, and = (among others) will be available for numeric columns, but object columns would have only the operator WITHIN.

Note: For WFS rows, the operators available will depend upon the values supported by the WFS server. These could include operators such as BBOX (bounding box), Within, Contains, and Overlaps. For a general discussion on geographic operators, see Using Geographic Operators in Expressions.
Note: For more information, refer to the documentation for the WFS service that you are using. For more information on WFS filters, refer to the OGC Filter Encoding standard at http://www.opengeospatial.org/standards/filter.

Value

The type of the Value control also varies depending on the column type. For object columns, this control will be a list box containing the values Current Mapper and Current Selection. For all other column types, this control will be an edit box, allowing the user to enter the proper type of data.

Numerical values are entered without any quotes. For example, for a numeric column, the user might select the operator >, and enter a value of 0. This would select only rows in which that column contained a value greater than 0.

There are two wildcard characters that can be used with the LIKE operator: '%' and '_'. The '%' wildcard character matches zero or more characters. The '_' wildcard character matches only one character.

Navigation Buttons

Cancel

Click the Cancel button to abort the wizard.

Note: The following buttons do not appear when this dialog box is accessed from the WFS Server Map Properties dialog box.

Next

Click the Next button to move to the next dialog box after completing this dialog box.

Expert

Click the Expert button to leave the wizard if you want to download a table by entering your own SQL query. If the Expert button is selected at this time, the selected filtered columns will be added to the default query presented.

Finish

The Finish button accepts the selected rows.