Hi,
I have a value prompt where i have the below static choices
1) None
2) Ax- Date
3) Ex-Date
I have a second prompt that should display either Ax-Date calender-prompt or Ex-Date calender-prompt based on user selection from the first prompt.
please let me know on how to write the query for that
Thanks
Sameena
use a render variable and build two promots for ax and ex dates.
Adik's solution is good, but I'd go a different way about it.
1st, a render variable would require a page refresh to catch on. I oppose refreshes unless they're absolutely necessary, and almost never on a prompt page. The idea is to never let the user wait unless you absolutely have to.
2nd issue is you'll need to maintain two prompts. Since they're both date, there's no actual reason for two prompts.
Suppose you have a value prompt (parameter name: dateType) with 3 static options: Use:0 display:"none"; Use:1 display:"Ax-date"; Use:2 display:"Ex-date".
Then you add a date prompt (parameter name "date").
Your filter will look like this: (?dateType?=1 and [Ax-date]=?date?) or (?dateType?=2 and [Ex-date]=?date?) or (?dateType?=0).
This will filter by Ax date when you select Ax date, by Ex date when you select Ex date, and by nothing when you select None. So, one date prompt for all.
The only issue here is if you're keen on hiding the date prompt when "none" is selected. You can use JS for that, but the method differs between version 10.2+ and 10.1.1-
If you'll tell me which version you're using, I could hook you up with a code sample.
Thanks Adik and Namrod..
sameena