Example Filter

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

Example Filter


This example will find objects that are either

  Stored procedures in the 'Sales' or 'Marketing' schema that do not contain the text '--temporary_object'

  Tables in the 'Sales' schema

  Views in the 'Marketing' schema

 

This would appear as follows in the filter dialog 

 

Notice that the root of the filter is in 'Or' mode, this is because we have three distinct conditions, and any of those conditions can produce a match. Under the root filter, we have three compound filters, one for each of the conditions listed above.

 

The first one handles the criteria

    Stored procedures in the 'Sales' or 'Marketing' schema that do not contain the text '--temporary_object'

 

This part of the filter is shown in the tree as follows: 

 

So, we have an object type filter set to match stored procedures. We also have a compound filter which will match if the object schema name is 'Sales' or if the object schema name is 'Marketing'. Then we have a text filter which will match if the object definition does not contain the text '--temporary object'.

 

The next compound filter deals with the criteria

    Tables in the 'Sales' schema

 

This part of the filter is shown in the tree as follows 

 

So, we have an object type filter set to match tables, and we have a text filter which will match if the object schema name is 'Sales'.

 

The last compound filter deals with the criteria

  Views in the 'Marketing' schema

 

This part of the filter is shown in the tree as follows 

 

So, we have an object type filter set to match views, and we have a text filter which will match if the object schema name is 'Marketing'.