Creating and Applying Entity Filters

You can filter the list of database objects displayed in the Object Browser to only objects that you want by creating entity filters. For example, you can create a filter for object names that begin with "SALES" to have only tables and views with matching names displayed in the Object Browser.

To apply a filter to the Object Browser automatically each time you connect to the target database, you can mark the filter as default.

Creating an Entity Filter

To create an entity filter:

  1. On the View menu, point to Entity Filter and click Manage Filters.
  2. In the displayed Manage Schema Filters window, click New.
  3. In the Filter Name box in the displayed Schema Filter Properties dialog box, type a name for the entity filter.
  4. In the Logical Operation list, select a logical operand. The following options are available:
    • Or
    • And
  5. To specify the appropriate conditions, click New.
  6. In the displayed Filter Condition Properties dialog box, specify the following:
    • Filter Field. The field the filtering must be performed by. The following options are available:
      • Schema
      • Name
    • Criteria. The following options are available:
      • Equals
      • Starts with
      • Contains
      • Ends with
      • Not Equals
    • Filter Value
  7. If you want the specified filtering values to be case-insensitive, select the Ignore Case check box.
  8. Click OK to return to the Schema Filter Properties dialog box.
  9. In the Schema Filter Properties dialog box, click OK to return to the Manage Schema Filters window.
  10. To mark the filter as default, select the Is Default check box.

    To turn off the default filter, clear the Is Default check box.

The specified filters are displayed in the Filters area of the Manage Schema Filters window.

Now, the created filter needs to be applied to the Object Browser.

Applying a Created Filter to the Object Browser

You can apply a created filter to the Object Browser to display only those objects whose schemas and/or names meet the filtering criteria.

You don't need to apply the default filter; it will be applied automatically each time you connect to the target database.

To apply a created filter to the Object Browser:

Click View, point to Entity Filter, click Select, and then select the created filter.

Using entity filters in combination with turned-off schema groupings in the Object Browser (on the View menu, clear Group by Schema) will help you get to the objects you need more quickly.

Removing a Filter

To remove a filter from the Object Browser to display all database objects, on the View menu, point to Entity Filter and then click None.

You can remove the default filter for a currently open Query Analyzer window, but it will be reapplied in each new Query Analyzer window. You can turn off the default filter altogether.


Aginity Workbench for Hadoop * Topic last updated August 30, 2018