Cascading Prompts

[srini2mk]

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