Running a Query

Description: In order to run a query, first select it from the query list. If the query has input parameters defined, prompt lines will appear in the parameter grid.

Modules Found In:  Accounts Receivable, Project Administration, Accounts Payable, Human Resources

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, this represents the lower range.

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

Click on the Run button to fill the Results tab based on the query definition. If the result sets contain any key fields, they will appear in blue with an underline (like an internet hyperlink). By clicking on one of these, the associated master file screen will 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 style.

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