11g list of values LOV

In JDeveloper 11g TP2 ( In TP3 is the af:inputListOfValues a bit different) can you define a List of values on an attribute of a bc4j viewobject. This is very easy but you can do it also manually so you can use it with toplink or with webservices. In this blog I make an jsf page on employees where you can update the department of this employee with a list of values or a lov combobox.This is a very simple LOV but you can make it more complex by using a search area in this. I will explain this in a other blog. But how do we manually create a LOV page. First we drop employees view from the data control on the jsf page. We select an ADF Form
We use all employees attributes with include navigation controls plus include submit button.

Now go to the pagedef of this page where we create a list of values binding on the department iterator. We need this for the lov page

We don't have the department iterator so we have to select it first.
We select all the attributes of the department iterator.
Open the pagedef and rename the list of values ID to DeptnoLOV. This is how the list of values looks in the pagedef.
<br /> <listofvalues staticlist="false" listopermode="navigation" iterbinding="DeptView1Iterator" id="DeptnoLOV"><br /> <attrnames><br /> <item value="Deptno"><br /> <item value="Dname"><br /> <item value="Loc"><br /> </attrnames><br /> </listofvalues><br />
Now go to the page and select the last column and insert input list of values.

Now we update the af:inputListOfValues element in jspx page with this one
<br /> <af:inputlistofvalues label="#{bindings.Deptno.hints.label}" popuptitle="Search Departments" value="#{bindings.Deptno.inputValue}" returnpopuplistener="#{LovBean.DeptLOVReturnListener}" required="#{bindings.Deptno.mandatory}" columns="#{bindings.Deptno.displayWidth}" id="test"><br /> <f:validator binding="#{bindings.Deptno.validator}"><br /> <af:convertnumber groupingused="false" pattern="#{bindings.Deptno.format}"><br /> <af:collectionreturnpopupdatalistener from="deptnoTableId"><br /> <f:facet name="searchContent"><br /> <af:panelgrouplayout layout="vertical"><br /> <af:table rows="#{bindings.DeptnoLOV.tree.rangeSize}" fetchsize="#{bindings.DeptnoLOV.tree.rangeSize}" first="#{bindings.DeptnoLOV.tree.rangeStart}" emptytext="#{bindings.DeptnoLOV.tree.viewable ? 'No rows yet.' : 'Access Denied.'}" var="row" value="#{bindings.DeptnoLOV.tree.collectionModel}" selectedrowkeys="#{bindings.DeptnoLOV.tree.collectionModel.selectedRow}" selectionlistener="#{bindings.DeptnoLOV.tree.collectionModel.makeCurrent}" rowselection="single" id="deptnoTableId"><br /> <af:column headertext="#{bindings.DeptnoLOV.tree.labels.Deptno}" sortproperty="Deptno" sortable="false"><br /> <af:outputtext value="#{row.Deptno}"><br /> </af:column><br /> <af:column headertext="#{bindings.DeptnoLOV.tree.labels.Dname}" sortproperty="Dname" sortable="false"><br /> <af:outputtext value="#{row.Dname}"><br /> </af:column><br /> </af:table><br /> </af:panelGroupLayout><br /> </f:facet><br /> </af:inputListOfValues><br />
returnPopupListener attribute of inputListOfValues is very important, here is the method defined which copies the value of the lov to the deptno of the employee. You can also have launchPopupListener where you can limit the records of the lov.

package nl.ordina.beans;

import javax.el.ELContext;
import javax.el.ExpressionFactory;
import javax.el.ValueExpression;
import javax.faces.application.Application;
import javax.faces.context.FacesContext;

import oracle.adf.model.binding.DCIteratorBinding;
import oracle.adf.view.rich.event.ReturnPopupEvent;
import oracle.binding.BindingContainer;
import oracle.jbo.Row;

public class LovDepartment {


   public void DeptLOVReturnListener(ReturnPopupEvent returnPopupEvent) {
       // Add event code here...
       DCIteratorBinding EmpViewIterator = (DCIteratorBinding) getBindings().get("EmpView1Iterator");
       Row rw = EmpViewIterator.getViewObject().getCurrentRow();
       rw.setAttribute("Deptno",getDeptLovID());

   }

   private BindingContainer getBindings() {
       FacesContext fc = FacesContext.getCurrentInstance();
       Application app = fc.getApplication();
       ExpressionFactory elFactory = app.getExpressionFactory();
       ELContext elContext = fc.getELContext();
       ValueExpression valueExp = elFactory.createValueExpression(elContext, "#{bindings}", Object.class);
       return (BindingContainer)  valueExp.getValue(elContext);
   }
  
   private String getDeptLovID() {
       FacesContext fc = FacesContext.getCurrentInstance();
       Application app = fc.getApplication();
       ExpressionFactory elFactory = app.getExpressionFactory();
       ELContext elContext = fc.getELContext();
       ValueExpression valueExp = elFactory.createValueExpression(elContext, "#{bindings.DeptnoLOV.inputValue}", Object.class);
       return valueExp.getValue(elContext).toString();
   }
}

We only have to register this bean in the adfc-config.xml
<br /><?xml version="1.0" encoding="windows-1252" ?><br /><adfc-config xmlns="http://xmlns.oracle.com/adf/controller" version="1.2"><br /> <view id="employees"><br /> <page>/employees.jspx</page><br /> </view><br /> <managed-bean><br /> <managed-bean-name>LovBean</managed-bean-name><br /> <managed-bean-class>nl.ordina.beans.LovDepartment</managed-bean-class><br /> <managed-bean-scope>request</managed-bean-scope><br /> </managed-bean><br /></adfc-config><br />
Now we can delete in the jsf page the deptno column of the employee form because we have now the lov. If you don't like the LOV or inputListOfValues you can also use a combobox or inputComboboxListOfValues. You only have to use this code in the page and replace the inputListOfValues element.
<br /><br /> <af:inputcomboboxlistofvalues id="deptnoId" popuptitle="Search and Select: #{bindings.Deptno.hints.label}" value="#{bindings.Deptno.inputValue}" label="#{bindings.Deptno.label}" returnpopuplistener="#{LovBean.DeptLOVReturnListener}" required="#{bindings.Deptno.mandatory}" columns="#{bindings.Deptno.displayWidth}" items="#{bindings.Deptno.items}" recentitems="#{bindings.Deptno.recentItems}" var="item"><br /> <f:validator binding="#{bindings.Deptno.validator}"><br /> <af:convertnumber groupingused="false" pattern="#{bindings.Deptno.format}"><br /> <af:collectionreturnpopupdatalistener from="deptnoTableId2"><br /> <f:facet name="searchContent"><br /> <af:panelheader text="Dept"><br /> <af:table rows="#{bindings.DeptnoLOV.tree.rangeSize}" fetchsize="#{bindings.DeptnoLOV.tree.rangeSize}" first="#{bindings.DeptnoLOV.tree.rangeStart}" emptytext="#{bindings.DeptnoLOV.tree.viewable ? 'No rows yet.' : 'Access Denied.'}" var="row" value="#{bindings.DeptnoLOV.tree.collectionModel}" selectedrowkeys="#{bindings.DeptnoLOV.tree.collectionModel.selectedRow}" selectionlistener="#{bindings.DeptnoLOV.tree.collectionModel.makeCurrent}" rowselection="single" id="deptnoTableId2"><br /> <af:column headertext="#{bindings.DeptnoLOV.tree.labels.Deptno}" sortproperty="Deptno" sortable="false"><br /> <af:outputtext value="#{row.Deptno}"><br /> </af:column><br /> <af:column headertext="#{bindings.DeptnoLOV.tree.labels.Dname}" sortproperty="Dname" sortable="false"><br /> <af:outputtext value="#{row.Dname}"><br /> </af:column><br /> <af:column headertext="#{bindings.DeptnoLOV.tree.labels.Loc}" sortproperty="Loc" sortable="false"><br /> <af:outputtext value="#{row.Loc}"><br /> </af:column><br /> </af:table><br /> </af:panelHeader><br /> </f:facet><br /> </af:inputComboboxListOfValues><br />
Here you have the example project