EmpowHR - Version 9.0 Section 14 - Reporting

Query Manager

This option allows the user to add, view, run, and modify an existing query. There are multiple tabs in Query Manager.

• Records - Allows listing of records chosen to be used to run a query.
• Query - Allows the fields to be selected to be used to create the query.
• Expressions - Allows for the adding of expressions to the query.
• Prompts - Allows the query to be designed to prompt for information when the query is run. The results can be narrowed to only data matching information rather than data from all records.
• Fields - Allows the creation of the query.
• Criteria - Identifies specific sorting requirements.
• Having - Allows the editing of properties for the query.
• View SQL - Allows the viewing of the structure query language that EmpowHR automatically writes for the fields that are selected.
• Run - Allows for the running of query reports.