Docs Menu
Docs Home
/
Relational Migrator
/

Edit Table Filters

On this page

  • Before you Begin
  • Steps
  • Learn More

You can edit existing table filters. Editing table filters allows you to change the SQL where statement and row limits when pulling data from your table.

At least one table filter must be applied to your table. For details on how to apply a table filter, see Apply Table Filters.

1
  1. From the Schema model pane, click the table that has the table filter you want to edit.

  2. On the Mappings pane in the Table Filter section, click the icon.

2
  1. On the Edit Filter pane, under the SQL Query header, enter the updated SQL where statement for your table filter.

  2. (Optional) You can also add or remove row limits when editing a table filter:

    • To add a row limit, click the Limit Number Of Rows and providing a value in the row limit text field.

    • To remove a row limit, click the No Limit radio button

3

Click the green Save and Close button to save the updated table filter.

Mapping Rules

← Apply Table Filters