Running a Query

Top  Previous  Next

Module: Accounts Payable    

Applet: Client Queries  

 


Description: How to Run a query.

To run a query, first select it in the Query list. If the query has input parameters defined, then 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 operators except is not null. This is the value that completes the filter operation (except in the case of the between operator). In the case of the between operator, this represents the lower range

 

Value 2 - Used only with the between operator. This represents the upper range.

 

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

 

If you drag a result column to the area above the results grid, the results will be grouped in a hierarchical fashion.

 

When you click on the Export button, you will be prompted for a file name. 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.