Docs Menu
Docs Home
/
Relational Migrator
/
Table Filters

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.

Before you Begin

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

Steps

1

Select a table filter

  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

Edit your table filter

  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

Save the updated table filter

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

Learn More

Mapping Rules

Back

Apply

Next

Delete