I have requirement where I need to hide the child prompts based on the selection in the parent prompt.
ex: An user can be prompted to select the following two choices:
Fiscal Year
Calendar Year
If user selects Fiscal year, a child prompt should be displayed as ‘Enter the Fiscal Year’. Instead if user chooses Calendar, then i need to display the following two prompts.
Enter the Start Date
Enter the End Date.
Is there anyway to dynamically change the prompt based on the previous prompt selection?
Just thought of checking with you all about the possiblity of using cutom LOV’s for the cacading prompts.
I do not have columns (for the fiscal and calendar year) from the tables. All I need is to create the custom LOV for both years and then applying the cascading.
Having said that can I still implement the cascading?
You cannot hide prompts… when you use the prompts in your query panel, all the prompts will appear to the user… there is no way to hide them.
If you have PERIOD_TYPE (W, M,Q,Y, FW,FM,FQ,FY) or something similar where you have some differentiation between Calander periods and Fiscal Periods, then yes you can implement them. But you have to take care of the prompt message string … as a constant . you should provide something like ‘Enter Year’.