Run a Query

Description: How to Run a Query.

To run a query, 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, 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 this represents the lower range.

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

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

Dragging a result column to the area above the results grid will group the results in a hierarchical manner.

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