Hi Gurus!
I am not able to crack a scenario which is mentioned below.I am just presenting it in a simpler way(as simpler as I can :))
The scenario is, We have prompt 'A' which is having 3 static choices and also multi value select enabled.
We are filtering (not cascading) another prompt 'B' query based on the values selected in the above said prompt.
I defined the filter condition like [].[].[queryitem] in ?promptAparamter? and made optional.
So even if by making the prompt 'A' as required, It is not acting as a mandatory prompt.
So I think by using java script only we can make the prompt A mandatory. If you have any ideas, Please share with me.
Thanks in Advance.
Is prompt 'A' on Autosubmit?
So as to say: are you reloading the page such that it has set the filter for query B?
And, if you are trying to do this in a prompt page you will have some trouble. Autosubmit on a prompt page uses a next command, not a reprompt. Next will look for any other prompt page then attempt to load the report page. Leaving your sad and lonely prompt B filtered, but with no selection made.
So, after I said are you autosubmitting? And told you it's the solution, I'm right unless it's on a prompt page. If it's on a prompt page, don't autosubmit. Use a prompt button, and set it to 'reprompt'. I can't remember for sure, but you may need to add a hidden list container with some data to force the Prompt Page to stay available, but only do that if you have trouble keeping your prompt page loaded after reprompting.