The Incident Archive

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" popu...