Tuesday, March 29, 2011

List of values as one item for form layout - And lov key and description lookup

This is a quick and dirty so take note of the downside:

0) Create LOV based on sql query and map lov in your vo.

1) Add transient attribute based on sql query to your vo. (tick mapped to column or sql or and selected in query tick boxes)

2) Enter alias and sql query (Expression) in (makes sure your where clause maps one column of the vo to a column in that table). Select t.desc from table t where t.code = CodeInVO

3) Add an addtional mapping in your LOV setting in your vo attribute and map it (green button to add and select the correct values in the drop down) to your newly created transient.

see below for the formatting of this LOV if you are using a panelFormLayout and you want it to be layed out as one entry in the panel form.

<af:panelLabelAndMessage id="plam11" label="#{bindings.Attrib1.hints.label}">
  <af:panelGroupLayout layout="horizontal" id="pgl7">
    <af:inputListOfValues id="attrib1Id"
      popupTitle="Search and Select: #{bindings.Attrib1.hints.label}"
      <f:validator binding="#{bindings.Attrib1.validator}"/>
      <af:convertNumber groupingUsed="false"
    <af:inputText value="#{bindings.Attrib1Name.inputValue}" id="ot9"
      columns="50" partialTriggers="attrib1Id" disabled="true"/>

NOTE: if you have a required field mark the inputlistof values as required and simple and the panelLabelAndMessage as showRequired true.

1) Click this button to map to sql
2) This is the alias field that needs a unique value mentioned above.
3) The sql statement you wish to use is inserted here.
4) This is the mapping of the expression you wish to use (field in the mapped vo).


  1. Could you please explainstep 2.
    Especially how to access CodeInVO. Is there any expression to do the same?

    I would appreciate a sample code if possible.

    Thanks in advance.

  2. Sorry for the late reply I have updated the post at the bottom to make point 2 more clear

  3. Thanks very much for answering my query. Is this usecase where we need to display both the ID column and name column? Otherwise we can use the UI hints in the LOV of ID COLUMN to have the NAME COLUMN displayed in the list, isn't it?