Enhancement to Filter SQL Server and Oracle Objects

VE 2020 introduces a new Include/Exclude option to filter database objects by name.

Visual Expert allows you to narrow the code analysis to a portion of your code.
You can then focus on objects of primary interest when analyzing Oracle or SQL Server databases.

How to include/exclude database objects in Visual Expert?

Your Visual Expert project must connect to a database server to use this feature. If that’s the case, please follow the steps below:

• Select 'Manage Source Code' from the Settings tab in the ribbon menu.
  
  
  
  
• Select your source code location and click on 'Edit'.
  
  



• Click on 'Add Name Filter' in the “Selection of the DB Objects” window.
  
  
  
  
• The 'Filter Objects by Name' window opens:
  
  
  
  
• Choose between Include or Exclude to define your main criterion.
• Then define your sub-criteria:
1. Set the type of filter - Contains, Starts With, Ends With, Match Expression
2. Define the Pattern, the string of characters that will be used to filter the object name
3. Select the type of Object
• Click ‘OK’ to save the filter.
  The above combination will display a list of all objects whose name contains "db_".

The new 'Name Filter' appears in the list.

• To edit a filter, click on the first icon (with pen) to open Filter Objects by Name window and modify the criteria.
  
  
  
  
• To delete a Name Filter, click on the second icon (with red cross).