Hi,
I have three prompts as folows:
1. prompt 1
2. prompt 2 - values of which are based on the selection in prompt 1, So the cascading prompt of prompt 2 is prompt 1
3. prompt 3 - This is dependent on both prompt 1 and prompt 2, but as a filter type i.e. The query values of prompt 3 are filtered with conditions of prompt 1 and prompt 2.What is the filter condition I should have in the prompt query.
The real values are as follows:
prompt 1 - values Segment, region e.t.c
prompt 2 - when segment is choosen , segment values are displayed, if region is selected region values are displayed.
select prompt 2 values from prompt 2 where prompt 1 = ?param 1?
select prompt 3 values from prompt 3 where prompt 1 = ?param 1? and prompt 2 = ?param 2?
If i use the filter ?param 1? = ?param 2?, it errors out as syntrax error. How to achieve this?
Thanks