Yesterday I got a question from my blog
post reader about LOV components, about how to use LOV components on a reference attributes. Actually, its quite common requirement to have reference attribute shown in LOV, and not its code. I knew it from before, this functional requirement can be implemented in ADF 11g,
Steve Muench described it in
Oracle Magazine article year ago. However, I decided to implement sample application for this requirement and to give more light on this topic.
Download sample application -
LOVByName.zip. It is based on instructions from Steve Muench article mentioned above.
I'm talking here about LOV, where description text is used directly in LOV component, and code is not shown:
User can select value from LOV popup:
And return it back:
So, what you need to do in order to make it work this way. Actually, nothing new comparing to LOV with code value. As usual, include reference attribute, key attribute will be added automatically:
Those attributes are added as reference attributes, means not updateable:
Main thing here is to declare LOV on reference attribute - JobTitle:
You should set JobTitle as LOV attribute and additionally return real key attribute - JobId: