Skip to Main Content

APEX

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Shuttles: How to get/use the value of a highlighted shuttle value?

877403Nov 10 2011 — edited Dec 22 2011
Hi,

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
This post has been answered by Shunt on Nov 11 2011
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jan 19 2012
Added on Nov 10 2011
12 comments
4,792 views