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.

asked 17 Aug '12, 02:55

DPushkashu's gravatar image

accept rate: 25%

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;

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

alt text


answered 17 Aug '12, 03:30

Ibrahim%20Sandalli's gravatar image

Ibrahim Sand... ♦♦
accept rate: 25%

Your answer
toggle preview

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here



Answers and Comments

Markdown Basics

  • *italic* or _italic_
  • **bold** or __bold__
  • link:[text](http://url.com/ "title")
  • image?![alt text](/path/img.jpg "title")
  • numbered list: 1. Foo 2. Bar
  • to add a line break simply add two spaces to where you would like the new line to be.
  • basic HTML tags are also supported



Asked: 17 Aug '12, 02:55

Seen: 2,480 times

Last updated: 17 Aug '12, 03:30

© Copyright Gerger 2017