QUERIES Section

General Remarks

IMPORTANT: Synexsys is equipped with a powerful "query by example" system. By working simultaneously with classification treeviews (automatic trees / manual trees / link trees), you will obtain precise results quickly and seamlessly. The fact that trees classify information represents a query in itself. Except that, to get this preliminary filter, you only need to select the tree nodes that interests you, without need of entering any criteria. Often, you will realise that the tree by itself can already provide you with the good answers without need of executing queries.

The Queries Section of the SXSi Console is the core of inventory data processing. This part of the program allows you to:

Execute queries on each of the SXSi inventory module, as well as across custom fields.

Process the query results in the visualisation window (sort and group by field, hide or display columns and invert their order, search within the results, etc.)

Print and / or export the query results to external files (HTM, XLS, CSV)

Count Object occurrences that correspond to the search criteria

Zones

The "Queries" Section window is vertically divided into two parts:

Trees & Queries

The left pane displays the management trees as well as the area where you may enter search criteria. For more information, see building queries

Results

The right pane displays the results of the queries that have been executed on the left of the window. For more information, see the results window

Sub-Sections

The "Queries" Section includes several sub-sections that allow you to query the SXSi database specifically. The sub-sections more or less match the tabs found in the "Objects" sub-Section of the "Inventory" Section.

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

Last Update: 16.03.2005