Hi,
I have a shuttle "P1_GRET" shuttle component with its LOV getting values as below:
Select PREFERRED_TRADE_NAME as d, DRUG_PRODUCT_ID as v FROM ARIEL.DIM_DRUG_PRODUCT WHERE FLAG_PASSIVE ='0' ORDER BY 1 ASC
I already have values in the database so I prepopulate the right side values using a colon separated list:
SELECT LISTAGG(ID, ':') WITHIN GROUP (ORDER BY PREFERRED_TRADE_NAME)
FROM GRET_PRODUCTS WHERE GRET_ID = :P1_GRET GROUP BY ID
But what I want is the same display, value set up as I have on the left? What is the point of displaying primary key values in the right hand side? How would I display the values on the right, but still process the ID values when I commit to the database?
At the moment when you move an item from left to right, you get the display value on the right but the value appears to go into session, but when you populate the initial values of the right hand side, I just get IDs.
Regards
Stephen