Filter Trees

DBA xPress ›› Features ›› Object Browser ››
Parent Previous Next

Filter Trees


Table of Contents

  Example Filter

  Setting up a Filter Tree


Part of the underlying engine powering the object browser allows for complex filters to be defined which can select objects based on multiple criteria.

The filters are based on a tree system, and are split in to two categories, combination elements (compound filters) and match elements. Compound filters combine other elements to produce a result (for example, if all sub-elements match elements then produce a positive result), whereas match elements produce a result based on inspection of a schema element (for example, is the name of the schema that this object belongs to 'Sales').

 

The compound filter types available are as follows 

Type

Description

And

The compound filter will return a positive match if all child elements return a positive match

Or

The compound filter will return a positive match if any of the child elements return a positive match

Exclusive Or

The compound filter will return a positive match if one and only one of the child elements returns a positive match

 

The match elements available are as follows 

Type

Description

Object Type Filter

The filter returns a positive match if the object matches the filter type in the specified manner

Object Type Group Filter

The filter returns a positive match if the object matches the filter type group in the specified manner

Text Filter

The filter returns a positive match if the selected text property of the object matches the filter text in the specified manner

 

Each of those filter types have specific properties. To see more information about the properties that those filters expose, click on the name of the filter.

 

Overall Filter Mode

At the top of the filter dialog is a drop down list marked 'Mode'. This is used to determine whether the filter tree includes only objects that match the filter, or excludes objects that match the filter.

 

Root Filter Properties

Each filter has a 'root filter element' which is the element which brings all other filter elements together. This element is a special type of compound filter, with two extra properties. These are the name of the filter, which is used to refer to the filter in dialogs and the recently used filter list, and the inheritance mode of the filter. The inheritance mode specifies whether an object can match because an object that is related to it matches as well. For example, when matching a table, it might be useful to match all the columns belonging to that table as well. There are two filter modes which facilitate this: 'From parent object only' and 'From any referenced object'.

 

'From parent object only' will look at the current object's parent, and if that matches, then the current object will match. If the parent does not match, then the parent's parent will be checked, until the chain is searched.

 

'From any referenced object' will look at all of the objects that the current object references, and if any of those match, then the current object will match.