In APEX, the value of the shuttle item is a colon delimited string representing the contents of the right hand side.
Consider a shuttle: P1_SHUTTLE below created from the following SQL
When you ask for the value of :P1_SHUTTLE you get a colon delimited string of the Right Hand side (e.g. 7782:7566:7934:7844:7876:7698:7900:7839:7788:7521)
To obtain the left hand side, on submit, the following steps are required:
The above code uses local variables to store the colon delimited strings although you may choose to perform a custom process with the shuttle results.
The SQL consists of:
The LOV rendered as a HTML Select List with the Return Item Extracted through XML functions and converted to a table
MINUS
The Shuttle Right Hand Side rendered as a table
So basically, the left hand side is “what can be chosen minus what has been chosen”
The results of the above are then aggregated in to a single colon delimited string representing the shuttle left hand side (e.g. 7369:7499:7654:7902)
For more information, check out our Oracle APEX Services, and if you liked this blog, check out our other APEX blogs here.
Contact us today and one of our expert developers will be in touch.
Author: Matt Mulvaney
Job Title: Senior Oracle APEX Development Consultant
Bio: Matt is an experienced APEX solution designer having designed numerous complex systems using a broad range of Oracle Technologies. Building on his previous experience of Oracle Forms & PL/SQL, he is entirely focused on providing functionally rich APEX solutions. Matt promotes APEX as a software platform and openly shares best practises, techniques & approaches. Matt has a passion for excellence and enjoys producing high quality software solutions which provide a real business benefit.