Shuttles: How to get/use the value of a highlighted shuttle value?
877403Nov 10 2011 — edited Dec 22 2011Hi,
I am using apex 4.0.2.00.07 on IE8 with theme Traditional Blue. I have browsed the forum, but could not really find an answer to the following question:
I am using a standard shuttle item in one of my forms. I know how to read out the 'selected' values on the right-hand side and how to read out the 'unselected' on the left-hand side. But what I would like to do is to catch the latest, 'highlighted' (i.e. once clicked at, but not yet moved to any of the sides) value to e.g. use it in a dynamic action.
What I want to achieve in the end:
Sometimes you end up with many very similar and easy to confuse entries in a shuttle. I would like to give a user some additional information on the latest, once clicked/highlighted shuttle value before he actually (de)selects it. It should not matter if the value is still unselected (left) or already selected (right).
When clicking once on a shuttle value, I would like to e.g. fill some display-only items on the same page with additional information for the selection. But to retrieve those, I need the return value of the highlighted record.
A simple example:
Tables A and B have .ID , .NAME and .DESCRIPTION columns each. There can exist many-to-many relations between A and B which are stored in table A2B (consists of just the two FK columns A_ID and B_ID).
On my page P1 I want to maintain new records for table A plus the relation to existing records in B. I have a shuttle with source
"select B_ID from A2B where A_ID = :P1_AID" combined with a list of values with B.NAME as display and B.ID as return value. I would like to display the information from B.DESCRIPTION in another item on the page whenever in the shuttle a new value "B.NAME" gets highlighted.
Any ideas?
BR,
Martin