Page History

Filters You can be placed place filters on data sources and corresponding data source objects to restrict their display in Data Source Explorer. This feature is useful if you have data sources that contain large numbers of database objects. You can apply filters to view only the schema objects you need for the development process.

There are two The following types of data source filters are available:

• Global filters that affect all registered data sources in the DB Optimizer development environment.
• Data Source specific filters affect only the specified data source for which they are defined.
•  On On Sybase and SQL Server platforms, you can apply database filters, which enables you to set different filters on different databases within the same source.

In both all of the above cases, data source object filters are defined via the Object Filter Manager, through the development of filter templates. Once defined, filter templates can be activated and deactivated as you need them.

...

1. In Data Source Explorer, right-click the data source and select Properties.
   The Properties dialog appears. 
2. Select the SQL Filters node and select Enable data source-specific settings. The other controls on the dialog become enabled.
3. Click New. The Filter Template dialog appears.
4. Specify the parameters of the filter.
• In the Name field, enter the name of the filter as you want it to appear in the selection window on the SQL Filter node.
• The Database Type pane provides a list of data source objects. Deselect the data source objects that this template filters so that they do not appear in Database Explorer when displaying data source objects for the data source.
• Click New to add filter parameters for data source object properties. The New SQL Filter Predicate dialog appears. 
• Use the Property and Operator fields to supply the filter criteria. Property specifies whether the value is a Name or Schema, and Operator specifies the matching type of the filter syntax. (Equals, Not Equals, Like, Not Like, In, Not In)
• In the Value field, enter the full or partial syntax of the property or properties you want to filter in Data Source Explorer.
5. Click OK. The filter property specification is added to the Filter Template.
6. When you have finished defining the filter template, click OK. The template name is added to the Properties dialog. It can be enabled and disabled by selecting or deselecting the check box beside its name, respectively.

...