Run a Query

Top  Previous  Next

Module: Project Management    

Applet: Project Queries

 


Description: How to Run a Query.

 

In order to run a query, first select it in the Query List. If the query has input parameters defined, prompt lines will appear in the Parameter Grid.

File - InFocus table name. See data dictionary for more information.

 

Field - InFocus column name. See data dictionary for more information.

 

Operator - Choices are =, <>, >, <, >=, <=, Between, and Is Not Null. Is Not Null is synonymous with a blank or empty field.

 

Value 1 - Used with all filter operators except Is Not Null. Value 1 is the value that completes the filter operation (except in the case of the Between operator). In the case of the Between, Filter 1 represents the lower range.

 

Value 2 - Value 2 is used only with the Between operator. It represents the upper range.

 

Clicking on the Run button will fill in the Results tab, based on the query definition. If the results sets contain any key fields, they will appear like an internet hyperlink (in blue and underlined). Click on one of these to launch the associated master file screen with the associated record filled in. The primary key fields are Vendor Code, Client Code, Project Path, and Employee Code.

 

Drag a Result Column to the area above the Results Grid to group the results in hierarchical order.

 

Clicking on the Export button will bring up a prompt for a filename. This will be the Excel file to which the result set is exported. If the results set was grouped, the grouping will be preserved in the export.