You update the right-hand side by setting the Value for the Item.
(Normally, I just use the Value of the LOV... not Display text and value)
The update is usually done with a Dynamic Action executing PL/SQL.
declare l_retval varchar2(32767); begin select listagg( empno, ':' ) within group (order by upper( ename ) ) into l_retval from emp where deptno = :P15_DEPT_NO; :P15_EMPNO := l_retval; end;
Example app name/passwd: demo/demo
dev name: developer
dev passwd: trymeout
When you look at the Dynamic Action, please take note that you need to set "Page Items to Submit" and "Page Items to Return".
Thanks a lot for the example Mike!
it seems that my problem with shuttle is, that each side of shuttle should be populated from different source tables. And then the approach you showed me does not work.
When I open/refresh the page then the right hand side is correctly fetched, but when the left hand side LOV is refreshed because of change in cascadig parameter then the right hand side LOV is empty. So I need to somehow refresh the right hand side of the shuttle when left hand side is changed. Maybe to use On demand process?
Can you explain why you have the extra code? (steps 3 through 10)
It looks like all of that can be done by defining the LOV used for the Shuttle as a Cascading LOV.
Page 2 of my example app uses a double-linked list.
(ie left-hand side of the shuttle is defined by Two parent LOVs)
No Dynamic Actions were defined.
Jiri N. -- Try combining my two examples and see if that works
Feel free to create an account on apex.oracle.com and show off what you have done.
Just remember, everybody with internet access can see it. Make sure you don't have anything confidential in there.
if you select some entries in the shuttle and change the first LOV from ACCOUNTING to RESEARCH then the selected values in the shuttle will be lost. You will need to remember those and set them if the first LOV is changed. In your example cascading works but changing the value of the first or second LOV will remove the selected value from the shuttle.
finally I fixed my problem yesterday. And of course the problem was on my side. I use wrong format of return values and then the right hand side of shuttle was empty, when the left hand side was refreshed after some change of cascading LOV item. By the wrong format I mean that I returned 'Surmane- Clark:Surname- King' instead of to return just list of personal ids '99:101'.
Thank you very much for your posts!