VERIFIED SOLUTION i

How to display specific records in MapInfo Pro while accessing DBMS tables

Products affected: MapInfo Pro™
While accessing DBMS tables, MapInfo Pro users can decide to display specific records based on their requirement.

To achieve this, follow the below steps:

1. open any DBMS connection such as SQL or Oracle.

2. Choose the table where the records need to be filtered

3. Click on the option button as shown below
User-added image

4. Click on Row Filter button if specific records need to be selected (if specific columns are required, click on the Column Filter button)

5. Pick the columns, operator and value in the text field.
In case of multiple columns, choose the valid conjunction as shown in the drop down.
User-added image

For more details, refer to the help topics by clicking on Help button on each dialog.
UPDATED:  October 31, 2017