Filters

This parameter affects Comparison, Migration, Synchronization and scripting processes. Also Batch processes are affected.
Filter can be defined for Tables and for Views.
There is an option to create several Filters for each table or view.
Only one filter per table or per view may be used (activated) at a time.
Filters may be inactivated.

Once Filter is selected for View or Table - all the processes, executed in the Workspace for specific Database Connection are affected by this Filter (if relevant Table or View used in this process).

Create Filter:

Right-click on Table or View.
Select Current Filter->Create New Filter.New Filter dialog will open In this dialog you can write any WHERE condition for the Filter.
Double-click on Field name in the list will paste the field name into your SQL statement.
Once SQL created, you can use Test to check the syntax.
To finish the process, click OK and provide Filter name in the Save Filter dialog.

Edit existing Filter.

Right-click Table/View name and select Current Filter->Edit Filter
Select the Filter you want to edit from Filter Names list.

Drop the Filter

Right-click on Table/View name and select Current Filter->Drop Filter
In the opened dialog, check all filters you want to Drop
Press OK.

Activate the Filter:

Right click on Table/View name and select Current Filter
Select one of your filters from the list in the menu. You can see that the icon near Table/View name has changed and is signed with Filter.

Pay attention - from now all processes, executed in this workspace using Filtered Table/View, will be affected by this Filter.

The Filter is an internal Cross-Database Studio Workspace Connection object parameter. Backend database does not store this Filter.

Un-Activate Filter:

Right-click Table/View name
Select Current Filter->No Filter. You can see that icon near Table/View is regular and is not signed with Filter.