I want to dynamically display the values in a prompt.
However I know of one code that needs to be translated.
Ex.
'abc' = 'Red'
I do not want to do a Static Collection because it is possible other codes may enter
the table.
If I do a case statement on the table the issue is the parameter gets set to the case statement condition which does not exist in the table.
Ex.
Case when
column='abc' then 'Red'
else column
The parameter will be set to RED thus making the filter on the main query useless.
Thoughts???
Hi, you can combine a static list and the dynamic query in a prompt. I would have your query, but filter out the value you need to translate, then in the static list, do your translation. Let me know if you have any issues or if this doesn't help.
Hope this helps.
anita