Run a query

Run a query 

To run a query:

  1. At the Query Manager screen, after you've defined your query, click OK.
  2. If:
    1. system parameter filters are included in your query, EmpowerHR asks for selections.  Make your selections and then click OK.  EmpowerHR runs the query and displays the output in the query results window.  
    2. there are no system parameter filters included in your query, EmpowerHR immediately runs the query and displays the output in the query results window.   

Save a query 

You don't need to save a query to be able to run the query.  However, you might choose to save a query so you can re-use it later.  After you save a query, EmpowerHR adds it to the Saved Queries  folder on the Catalogue panel.

While we refer to the Saved Queries folder, your system administrator may have defined folders and sub-folders in the Catalogue differently to suit your organisation's requirements.

To save a query:

  1. At the Query Manager screen, after you've defined your query, click the Save tab.
  2. At the Save tab, complete the fields using the following table as a guide.
At this field...
Do this...

Folder Category

Select a folder from the dropdown list.

Sub-folder Category

Select a sub-folder from the dropdown list.

Query Name

Enter a name for the query.

Query Description

Enter a description that clearly defines the purpose of the query.  This appears as a tool tip when you right-click the query name.

Public Query?

Select this checkbox if you want to share the query with other users.

Allow drill-down from another query

Select this checkbox if you want to allow drill-down from other queries.  See run a drill-down query for more information.

Output Format

Leave the default setting for the output to display in a Window.

If you want a different format, select an option from the dropdown list.  EmpowerHR prompts you for more information.  For example, the filename to be created, or spreadsheet to be populated with the output data.

Include Headings

Select this checkbox if you want headings included in the output.

  1. Click Save As to save the query.

Change a query you've saved 

You can:

  • make changes to a query you've previously saved
  • make a copy of a query you've previously saved

To change/make a copy of your query:

  1. At the Query Manager screen, select the query and click Move Right to displays the fields in the Query data panel.
  2. Change the query data, if you want.
  3. Click the Save tab.
  4. At the Save tab, to:
    1. save the changes you made to your existing query, click Save
    2. save a copy of your existing query, enter a new Query Name.  Change any other details on the Save tab, as required, and then click Save.

Copy a public query 

You can share a query you've created by selecting the Public Query? checkbox when you save the query.  Anyone can run a public query but only the author can modify the query.

Public queries created by other users display a small lock icon next to the query name.  While you can't change their public query, you can make a copy.

To make a copy of a public query created by another user:

  1. At the Query Manager screen, select the query and click Move Right to displays the fields in the Query data panel.
  2. Change the query data, if you want.
  3. Click the Save tab.
  4. At the Save tab, enter a new Query Name.  Change any other details on the Save tab, as required, and then click Save As. 




Next topic

Work with query results






© 2023 Fusion5. All rights reserved.