


Study with the several resources on Docsity
Earn points by helping other students or get them with a premium plan
Prepare for your exams
Study with the several resources on Docsity
Earn points to download
Earn points by helping other students or get them with a premium plan
How to add and use prompts in myhr query manager to customize report criteria and filter data. It covers the procedure for adding prompts from the criteria and prompts tabs, as well as tips for handling errors and incorporating prompt values into expressions.
Typology: Summaries
1 / 4
This page cannot be seen from the preview
Don't miss anything!



In myHR Query Manager, prompts allow users to change criteria parameters each time the report runs without having to edit the query. For instance, a query author can set up a prompt for employee ID. Each time the report runs, the user has to enter an employee ID and the report only shows data for that employee.
Procedure for Adding Prompt from Criteria Tab
Go to the Criteria tab.
Click Add Criteria.
Choose the field for Expression 1.
Under Choose Expression 2 Type, select the Prompt option.
In the Expression 2 box, click the New Prompt hyperlink.
On the Edit Prompt Properties page, the values will be filled out with default values that match the Expression 1 field from the Edit Criteria Properties page. You don't need to change the default values.
Optionally, you can edit the text that will be displayed on the prompt pop-up when a user runs the report. On the Edit Prompt Properties page, choose Heading Type of Text and type the desired wording into the Heading Text box.
Click OK at the bottom of the Edit Prompt Properties page.
Click OK at the bottom of the Edit Criteria Properties page.
Tip For some fields, like department ID, you may get the following error message when you try to enter a prompt value: Invalid value – press the prompt button or hyperlink for a list of valid values. This error occurs because Query Manager is linking the prompt to a missing prompt table. If you see this error, navigate back to the Edit Criteria Properties page for the prompt criterion, click Edit Prompt, and then change the Edit Type pull-down menu to No Table Edit.
Tip Prompt values can be incorporated into Expressions for complex selection criteria or to display the prompt value as a field in the output.