Oracle DB 19c | Oracle APEX 24.1.6
I have a Select List item with a LOV that derives from a SQL Query. The SQL Query filters on another page item to a subset of the overall values, much like the example listed in the documentation.
select ename,
empno
from emp
where deptno = :P3_DEPTNO
order by 1
However, I cannot get the Select List to display ANY values whatsoever. The difference I see between my setup and the typical “Cascading Parameter” setup is that the Page Item on which I am filtering in the Select List query is set by a dynamic action (not by actually selecting a value from another Page Item Select List).
I have tried setting the value of the page item on which I filter (:P3_DEPTNO in the example above) with a typical “Set Value” action, as well as an “Execute Server-side Code” where I ran the procedure apex_util.set_session_state, also making sure that my item's “Storage” property was set to “Per Session (Persistent)”.
I've also tried adding a dynamic action on the page item which is being filtered on, so that when that value changes I run an Action that refreshes the select list page item.
None of these options have seemingly worked and I'm a bit puzzled by what the problem is. Any help or insight would be greatly appreciated.
Jared