QUERIES Section

General Remarks

IMPORTANT: Synexsys is equipped with a powerful queries system. By working simultaneously with classification treeviews (automatic trees / manual trees), you will obtain precise results quickly and simply. In fact, trees classify information. That is considered a query in itself. Except for this previous result filter, you only need to select the tree node(s) that interest you, without need of entering any criteria. Perhaps you may realise that the tree can already provide you with the 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)

Keep track of 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 from the left side 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: 22.12.2004