How to create a new query report in Query generator?

How to create a new query report in Query generator?

Solution:
Go to Query Generator-->My Query
1. Click on "New Query" to create a new query.


2. Enter Query Name, Description, select status as "Enable" and click on "Save"

3. Click on "Add Item"


4. Select "Module" and "Source" .
5. Select the fields that you require to be displayed in the report and click "Save".


6. Click on "Execute" to run the newly created Report query

7. In the employee filter, select either "ALL" or "Inactive".


8. Click on either "Export to Excel" or "View on Screen" to see the result.

    • Related Articles

    • Encounter 'No channel available' when click on 'New Feedback Channel' in Feedback Channel Management

      Encounter 'No channel available' when click on 'New Feedback Channel' button in Feedback Channel Management. This means there is no channel available and has to create a new Feedback Channel category. Solution : 1. Go to All menus > HR Portal > ...

    • How to add or change Currencies in the System

      Possible cause(s): To modify or add any currencies needed by company. Suggested workaround / Solution(s): Go to set up > System > Regional Setting > Currency > click new currency > Key in > Save

    • How to setup Organization Structure

      Symptoms: How to setup or define Organization Structure for a company. Possible cause(s): None Suggested workaround / Solution(s): Go to “Setup” > “Company” > “Company Structure” > “Structure” tab. Select “Company’ and click on the parent OU (left ...

    • How to add another OU Level, that is level 4 in Organisation Structure?

      Frontier system only has 3 OU levels by default. Go through the following steps in order to add another level, level 4 in the Organisation structure : 1. Go to Setup > Company > Company Structure > select correct company profile. 2. Click the ...

    • How can employee reset their own password

      1. Employee to click on <Forgot Password> at the login screen 2. Enter the required information and ensure is correct before clicking on <Submit>. 3. If the information provided is correct, employee will be prompted with below message and email ...