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.

    Manage source code location

  • Select your source code location and click on 'Edit'.

    Change the source code to be analyzed


  • Click on 'Add Name Filter' in the “Selection of the DB Objects” window.

    Add Name Filter for Oracle & SQL Server objects in your project

  • The 'Filter Objects by Name' window opens:

    Filter Oracle + SQL Server objects by name

  • 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.

Filter Oracle + SQL Server objects by name


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

    Edit Name Filter for Oracle + SQL Server objects in your project

  • To delete a Name Filter, click on the second icon (with red cross).

    Remove Name Filter for Oracle + SQL Server objects in your project

 

Visual Expert 2020, Oracle, SQL Server, Filtering Database Objects