Here are the steps in order to create a Framework Manager query subject that uses prompts.
1. Create a stored procedure query subject that uses the sp_FIND_ORDER_DATE stored procedure.
The Query Subject Definition dialog box appears.
2. On the Definition tab, select the @order_number argument, and click the ellipsis (...) button.
3. In the Value box, type the following macro syntax and then click OK:
#(prompt('Order Number','integer'))#
Note: Framework Manager removes anything that is outside the number signs when running the macro.
4. To test the prompt for the variable, click the Test tab, and then click Test Sample.
The Prompt Values dialog box appears.
5. In the Name column, click Order Number.
6. In the Value field, type 1234 and click OK.
One record is returned, showing the date for Order Number 1234. Framework Manager uses this value for the duration of the current session or until you clear the prompt value.
7. Click OK.
