I can use the LOV as well as in the oracle apex

Question

I have carefully read the Tutorial 22: How to use the LOV. I would like to know if I can use the LOV as well as in the oracle apex. One value to store, and the other to display, for example in the grid column.

Answer 1

Hi Dmitry,

You can set a datasource column as the target of a LOV column. In the example presented on the screenshot below, the value to diplay on the LOV is FIRST_NAME and the value to store is EMPLOYEE_ID. Note that "Datasource" is selected as target type. The "Target" value "dsName.columnName" represents the column name of your grid datasource to be set when a value is selected from your LOV.

Alternatively, you can also place a combobox component in your grid column;

...
 <column>
   <comboBox listDataSource="datasource_listing_values" displayColumn="value_to_display" valueColumn="value_to_store" column="current_value_stored_by_your_grid_datasource"/>
 </column>
...

alt text

I can use the LOV as well as in the oracle apex

Follow this question

Related questions