Pitney Bowes MapInfo Stratus - Manual (Page 25)

To build a query, follow the steps given below:
1. Select the Query Builder tab.
2. From the Query In drop-down list, select the geographic area to be queried. You can choose to see
all the data, data within the current map view or choose one of the annotations you have drawn to
search for data that is inside or touches it.
3. From the From drop-down list, select the name of the map layer you wish to search.
4. From the Sort By drop-down list select which column of data to sort the results by. You can also
re-sort the data once the results are shown.
5. Select Custom Filter from Filter drop-down list to customize search. The Filter Criteria section is
displayed.
6. From the Where drop-down list select the column that is to be queried.
If there are less than 50 records associated with selected column then criteria is shown as
drop down list with multiselect option and if records are more than 50 then criteria is shown
as text box. Note:
7. Select the search operator from the drop-down list. It provides following search operators.
Description Name Operator
This function only retrieves records that exactly match the
text or value entered in the criteria text box. equal to =
This function looks for all values that are different from the
value entered in the criteria text box. not equal to <>
This function looks for all values lower than the value entered
in the criteria text box. less than <
This function look for all values higher than the value entered
in the criteria text box. greater than >
This function looks for all values higher than or at the same
level as the value entered in the criteria text box. greater than or
equal to >=
This function looks for all values lower than or at the same
level as the value entered in the criteria text box. less than or equal
to <=
It looks for records in the chosen field that contain the criteria
entered in any way. Like Like
Multiselect pick list is supported for {equal, not-equal and like} operators. For others, simple
pick list is displayed. Note:
8. Enter a value in the Criteria text box and click Go.
9. Click sign to add AND conditions to the query filter. If you want to delete a query condition click
the button to delete the current row.
You can add up-to 5 search criteria. Note:
Query Results View
On the results table you can:
• Re-order the results by clicking the column headings.
• Navigate from page to page.
• Export all of the results as a CSV file (or choose to export one page at a time). A maximum of 1000
results can be exported at any one time.
• Click each result to zoom to and highlight the record on the map.
• The highlighted feature can be used to make a second query inside its area.
25 MapInfo Stratus User's Guide
Chapter 3: Search and Query Builder