I have a date prompt and Version prompt. Based on the date prompt value, it needs to show all the versions available for that date as possible values in the second prompt.
I need both date and Version # to be selected and set in the query.
Thanks for your response .
I have tried cascading prompt. Though in first prompt i have selected the date, in second prompt, it shows all dates and its versions (hierarchical display).
Is there any way to show only respective versions of the date selected?
or
Is there any way to select both date and version # in a single prompt?
But you are “ANDing” date and version in the where clause of the generated SQL.
So they have to be in two separate prompts.
What you are asking is to pass the first prompt value(date) to the second prompt(version) in order to show only those versions which belong to the date selected.
This can only be done by prompting again in second prompt for the date passed in first prompt.