In this topic you will learn how to Create a Run Time Prompt.
Run Time Prompts allow you to further refine your query output results. When running your query, the system will "prompt" you to enter a value prior to retrieving results.
In this example, you wish to view results for each Business Unit separately and determine the order in which you view them.
You will change the Condition Type to "equal to" so that you can specify, using a prompt, which Business Unit you wish to view. In this example, using a prompt is more efficient than creating a list that includes all Business Units.
Click the equal to option.
Once the "equal to" option is selected for the Condition Type, the Expression 2 Type box displays a new list of options. The Expression 2 changes to Define Constant.
When Prompt is selected for Expression 2 Type, the Expression 2 box changes from Define Constant to Define Prompt. Two (2) links have been added as well to the Expression 2 link: New Prompt and Edit Prompt. Currently, there are no Prompts identified, so the Edit Prompt option would not be selected at this time.
For this example, the Edit Prompt Properties page will remain as defaulted.
A prompt window displays on the page. You will enter the Business Unit identifier into the Unit field. The system will retrieve only vouchers for the Unit specified.
Edit Prompt Properties (continued)
Length: The number of available characters for that field;
Decimals: The number, if any, of Decimal places allowed;
Edit Type: Allows you to evaluate a value against a set of tables to determine if the value is valid;
The Prompt created displays in the Expression 2 box. Prompts are displayed in the Criteria format ":number" (i.e. :1). Additional prompts may be created and would be assigned sequential numbers to be displayed as :2, :3, etc.
Edit Prompt Properties (continued)
Heading Type: Defines whether the prompt heading is Text, RFT Short or RFT Long;
Heading Text: Displays the label for the prompt box;
Unique Prompt Name: A default value generated by the Query Manager; and
Prompt Table: This field is not used when creating simple queries.
You will now run the query to test the criteria changes.
Edit Prompt Properties
The Edit Prompt Properties is here you define prompt properties and is comprised of the following fields:
Field Name: The name of the field for which you are creating the prompt;
Type: Indicates the type of field (i.e. character, date, date, time, number, etc.);
Format: Specifies the format (i.e., Upper Case, Mixed Case, Zip
Code) of the field;
The query results display.
This completes Create a Run Time Prompt.
Click the equal to option.
A prompt window displays on the page. You will enter the Business Unit identifier into the Unit field. The system will retrieve only vouchers for the Unit specified.