Hello people -
So, I have a field with dynamic prompt table (which of course i set the .sqltext using peoplecode).
I am asked to change the prompt to a Dropdown list. Which i did by simply adding a Dropdown field construct to the page and simply setting the dynamic view/field as the prompt. But, when i run it, it would just ignore the “dynamic” part and simply give me all the values in the underlying table. Just trying to figure out if Dropdown list doesn't (or works) with dynamic views.
Thank you!