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

Comments

  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.

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

    ReplyDelete
  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?

    ReplyDelete

Post a Comment

Popular posts from this blog

ADF Encountered deferred syntax #{ in template text.

OracleJSP error: oracle.jsp.parse.JspParseException:  Error: Encountered deferred syntax #{ in template text.  If intended as a literal, escape it or set directive  deferredSyntaxAllowedAsLiteral This normally happens when you have some tag lib dependancy problems but this was  not the case for me... My problem: For some reason my model project had web stuff in it(public html etc)  so I had to remove the public html stuff from my project and manually edit the Model.jpr project file and remove the tag lib entries at the bottom o the file. Go figure.    

JBO-25013: TooManyObjectsException

oracle.jbo.TooManyObjectsException: JBO-25013: Too many objects match the primary key oracle.jbo.Key[Key null ]. Ok so for you it may be trying to insert a duplicate record this should explain your problem (also check trigger they could be the cause.) NOTE: You can also try to create a new duplicate EO if you have a page with two VO's using the same EO. This could sort your problems. For me I needed to add a launch listener on my LOV and clear the cache of my vo. LOV <af:inputListOfValues id="NameId" popupTitle="#{bindings.Name.hints.label}" value="#{bindings.RolName1.inputValue}" label="#{bindings.RolName1.hints.label}" model="#{bindings.RolName1.listOfValuesModel}" required="#{bindings.RolName1.hints.mandatory}" columns="#{bindings.RolName1.hints.displayWidth}" shortDesc="#{bindings.RolName1.hints.tooltip}" launchPopupListener="#{backingBeanScope.backingBean.launchPop

OJDeploy: Documentation for the tool

Real DOCS:  http://docs.oracle.com/cd/E26098_01/user.1112/e17455/deploying_apps.htm#OJDUG645 OJDeploy Documentation if you run it from the command line - I keep looking for this so I though I would post it here so I remeber. Oracle JDeveloper Deploy 11.1.2.1.0.6081 Copyright (c) 2003, 2010, Oracle and/or its affiliates. All rights reserved. Usage:   ojdeploy -profile <name> -workspace <jws> [ -project <name> ] [ <options> ]   ojdeploy -buildfile <ojbuild.xml> [ <options> ]   ojdeploy -buildfileschema Arguments:   -profile               the name of the Profile to deploy   -workspace      full path to the JDeveloper Workspace file(.jws)   -project              name of the JDeveloper Project within the .jws where the Profile can be found. If omitted, the Profile is assumed to be in the Workspace.   -buildfile            full path to a build file for batch deploy   -buildfileschema  print XML Schema for the build file