Skip to main content

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}"
      value="#{bindings.Attrib1.inputValue}"
      model="#{bindings.Attrib1.listOfValuesModel}"
      required="#{bindings.Attrib1.hints.mandatory}"
      columns="#{bindings.Attrib1.hints.displayWidth}"
      shortDesc="#{bindings.Attrib1.hints.tooltip}"
      autoSubmit="true">
      <f:validator binding="#{bindings.Attrib1.validator}"/>
      <af:convertNumber groupingUsed="false"
        pattern="#{bindings.Attrib1.format}"/>
    </af:inputListOfValues>
    <af:inputText value="#{bindings.Attrib1Name.inputValue}" id="ot9"
      columns="50" partialTriggers="attrib1Id" disabled="true"/>
  </af:panelGroupLayout>
</af:panelLabelAndMessage>




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).

Labels

Labels:

Comments

  1. RamApril 29, 2011 at 9:03 AM

    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.

    ReplyDelete
  2. Donovan SherriffsMay 3, 2011 at 10:28 AM

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

    ReplyDelete
  3. RamMay 3, 2011 at 7:50 PM

    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?

    ReplyDelete

Post a Comment

Popular posts from this blog

ADF sort of generic screen for tables with the same structure

We have a couple (about a hundred) of tables with the same structure (Code, Description, Create Date, Update Date). So I wanted to do something simple so that I did not have to create all these screens 1) EO   I created the EO based on one of the tables I had that had the above columns. I then Added a transient attribute called table name to my EO based on a groovy expression. (the expression needs to change as I am reading web tier stuff from the model layer but I will fix this later) I then generated a java class for my EO. And added the following overriden method to my newly created java class. protected StringBuffer buildDMLStatement(int i, AttributeDefImpl[] attributeDefImpl,   AttributeDefImpl[] attributeDefImpl2, AttributeDefImpl[] attributeDefImpl3, boolean b) {   StringBuffer statement = super.buildDMLStatement(   i, attributeDefImpl, attributeDefImpl2, attributeDefImpl3, b); return new StringBuffer(StringUtils.replace(statement.to...
Post a Comment
Read more

Util code

public static MethodExpression getMethodExpression( String expr, Class returnType, Class[] argTypes){ FacesContext fc = FacesContext.getCurrentInstance(); ELContext elctx = fc.getELContext(); ExpressionFactory elFactory = fc.getApplication().getExpressionFactory(); return elFactory.createMethodExpression( elctx, expr, returnType, argTypes); } public static javax.faces.el.MethodBinding getMethodBinding( String expr, Class[] argTypes){ FacesContext fc = FacesContext.getCurrentInstance(); ELContext elctx = fc.getELContext(); return fc.getApplication().createMethodBinding(expr, argTypes); } SetPropertyListener listener = new SetPropertyListener( ActionEvent.class.getName()); listener.setFrom(link.getRoute()); listener.setValueExpression("to", JSFUtils.getValueExpression("#{pageFlowScope.route}", String.class)); action.addActionListener(listener); AdfFacesContext.getCurrentInstance().getPageFlowScope() .put("route", lin...
Post a Comment
Read more

MANIFEST.MF merge JDeveloper for an executable jar

Goto your project > properties. Then click on deployment in the menu. Edit or add a jar deployment profile. Fill in the details under jar options (select Include manifest and give it a main class name) Also remember that the merge functionality only works with a BLANK line at the end of the merge file. REALLY this caught me. My merge file contents: Class-Path: commons-codec-1.3.jar [...empty line here CRLF...]
1 comment
Read more