Switch to: V9V8V7V6V5

SQL Search Help

SQL Search allows you to find database objects on Valentina Server or on a local data store very quickly. Objects can be located either by name or by property value, according to the filter and selected matching pattern.

SQL Search is available in Valentina Studio Pro or higher.

To run SQL Search use main menu Tools and select appropriate item.

Overview

SQL Search is a plugin dependent tool that can work with any database engine supported by Valentina Studio. To start searching open tool from the main menu: Tool→SQL Search, and select target item for searching in the right panel. It can be Bonjour service, Bookmark or existing connection of Valentina Studio.

SQL Search Overview

Basic panels and controls:

  • Header – contains basic information about searching target:
    • Connection Info – connection parameters.
    • Databases Count – the count of databases accessible for the current connection.
  • Search Text – the filter string, that can be set manually or constructed with special dialog.
  • Construct Filter – invokes dialog to construct filter.
  • Match Pattern – the operator that will be used to define matching the filter and text of appropriate object property .
  • System Objects – defines whether system objects will be included in the searching process.
  • Databases – the list of databases in which the searching will be performed.
  • Object Types – the list of object types among which the searching will be performed.
  • Run Searching – starts the searching process.
  • Searching Result – the table that represents found objects.
  • Object Browser - the brief description of the found object.

Filter Options

SQL Search allows to use both simple and more complex filter constructed using special dialog. Moreover filter can use one of the several matching patterns, and can allow to search among system objects.

Filter Editor

Filter editor is a row where you can put any text to search. You can save the current filter and load it later by selecting an appropriate item in the drop-down menu.

Filter text can contains special symbols allowed by the current Math Pattern, for example % or _.

If the filter was constructed using Construct Filter Dialog it CAN'T BE CHANGED MANUALLY anymore. You have to use dialog again for this purpose.

Here you can see few examples of simple filter strings according to the match pattern.

Construct Filter Dialog

This dialog helps to create a proper complex filter that used boolean operators.

SQL Search - construct filter dialog

  • Filter Rows – shows the filter operands that will be joined by operator AND.
  • Filter Entries – shows the filter entries of the selected row that will be joined by operator OR.
    • Checkbox – indicates whether the entire will be compared by positive or negative matching (if negative - operator '<>' or NOT will be used ).

You can construct filter by managing it's values using buttons + and - to create or delete item.

The finite filter pattern for above dialog will be represented as:

SQL Search - complex filter pattern

Match Pattern

Depending from the target database engine you can use one of the available operator that will be used in the filter:

  • = (Exactly Matching) – the searching will be performed on exactly matching of the filter value and object property.
  • LIKE – the searching will be performed according to rules for LIKE matching of the particular database engine.
  • Regexp – (optional) the searching will be performed according to rules for regexp matching of the particular database engine.

Examples

Here a few examples of filter string considering to the match pattern :

System Objects

All supported DBMS contains system objects that helps to manage databases. You can exclude these objects (databases, schemas, tables, views … ) from searching using checkbox 'System Objects'.

By default system objects are excluded from searching.

Manage Filters

To avoid entering the same filter again and again you can save particular filter and use it on next session. If you do not need filter anymore you can remove it.

Use buttons Delete Filter and Save Filters for these purposes.

Searching Result

When searching is finished the result will be shown in the table:

SQL Search - result

In this section you can see:

  • Found Objects – the count of objects that matched to filter.
  • Total Time – the time that was spent to searching.
  • Error Count – (optional) shows the count of errors occurred while searching.
  • Search Field – the filter for searching result (table).
  • Result Table – the list of found objects.
  • Show in Schema Editor – Opens the selected object in the Schema editor of Valentina Studio.
  • Clear Result – removes the searching result.

All columns in the table are intuitively understood. Just pay attention on column Found In - it contains names of properties that matched to the current filter. For example, matching can be found in the list of index fields, or text of the stored procedure, or else. To observe values of matched properties use the Object Browser.

You can sort the table with result by any column.

Object Browser

The object browser shows the more detailed information about object selected in the result table.

  • Properties – shows the object properties the value of which was matched to the filter.
  • Path – shows the simplified tree structure of the object's parents.

Example of the property browser :

Example of the path browser :