how to pass values to a presentation variable including All Column Values

Question

Hello

I have a requirement where I need to cascade values from one prompt to another using "SQL Results" option using presentation variables. ( I have given presentation variables for both the prompts)

I was able to cascade the values from one prompt to another but when I choose All Column Values it is not getting passed and the prompt shows blank.

After that I found a way to pass the All Column Values, now my query is not giving any results when I choose more than one value in the prompt.

Please help me with the query that works if I choose All Column Values and also works if I choose more than one value.

Andrew Fomin. · Answer

Here is the exact query (it is based on Oracle's Sample Sales Lite demo, so you can easily reproduce it):

SELECT "Products"."Product Type" FROM "Sample Sales Lite"  where  "Products"."LOB"  in (@{p_lob}['@']{'na'}) or '@{p_lob}' = ''

User_G8P21 · Answer

When i select All Column Values, the next prompt is not showing any results. Could you please send the same query you used using your presentation variable?

Andrew Fomin. · Answer

What do you mean by "is not working"? Does It throw an error? Or does it give the unexpected result? Or no result at all?

It works for me. See this sample video.

https://gfycat.com/ForsakenUnsightlyHorsechestnutleafminer