Work in JDeveloper's IDE to add List-of-Values (LOV) components to the pages.
Create a Static View Object: Use the Create View Object wizard to add a static view object to the business services.
Create a Static LOV: Use the Data Controls panel to add a Single Selection | ADF Select One Choice component to create the LOV on a page.
Create a Lookup View Object: Use the Create View Object wizard to add a dynamic view object to the business services.
Create a Dynamic LOV: Use the Data Controls panel to add a dynamic LOV to a page.
A static LOV is based on a view object where transient attributes are created and populated at design time. You will define a view object, populate it with the static values needed for the LOV and associate it with the view object that will use it as an LOV. [ tell me more...]
StatusCodesas the name of the view object.
Statusas the name of the attribute and select Key Attribute . Then click OK.
Descriptionas the name of the attribute, and click OK. Then click Next twice.
PENDING Order has been submitted SHIP Order is being shipped PICK Order is being picked COMPLETE Order complete CANCEL Order was cancelled STOCK Order is waiting for stock CART Order is in cart
When you define a static list for a view object, JDeveloper creates a standard message bundle file in which to store them. The file is specific to the view object component to which it is related, and it is named accordingly. Internationalizing the model layer of an application built using ADF Business Components entails producing translated versions of each component's message bundle file. For example, the Italian version of the
ModelBundle.properties message bundle would be a class named
ModelBundle_it.properties, and a more specific Swiss Italian version would have the name
tell me more...]
When you add the view object as a view accessor, it should look like this: [ tell me more...]
A static LOV is based on a view object where transient attributes are created and populated at design time. You will assign the view object to a specific attribute that requires an LOV and choose how the LOV will be displayed. You then edit a page to display the attribute as an LOV list. [ tell me more...]
The status codes are displayed as a choice list in the LOV UI. With a choice list, other options are available: you can display multiple columns in the LOV (in this example, the status code); and also allow the user to leave the selection blank. You also could have used a different LOV UI, for instance a combo box or a radio group. [ tell me more...]
In the edit page, an LOV is available next to the OrderStatusCode label: [ tell me more...]
A dynamic LOV is based on a view object which provides the SQL to populate the list of values. You will define the view object and specify the query that will used as the basis for the LOV in this case, retrieving all the customers. Once you've configured a view object to provide a list of values for a given field, you can easily allow that list to be used for validation. In this example, you can ensure that the
CustomerId value that a user enters in the
editOrders form is a valid
CustomerId, that is, a value that is in the list of values. [
tell me more...]
CustomerViewas the name of the view object.
SELECT * from PERSONS Persons
WHERE Persons.PERSON_TYPE_CODE = 'CUST'
The new view object can be added as a view accessor in the View Accessors dialog, available by clicking the View Accessors tab in the overview editor for entity objects. [ tell me more...]
You created a view object that can be used as the provider for a list of values in the user interface. That view object also serves as a list of valid values in the validation of the CustomerId field. [ tell me more...]
You will use the dynamic view object (a view object populated from a SQL query) created earlier as the basis for a list of values. You will remove the CustomerId field from the form, and replace the field with an inputListOfValues component. This component displays as an input text field, with a button next to it which can be activated to display the list of values in a separate window. You will configure the list of values to display a subset of columns from the view object, and specify the relationship between the field and the value selected from the list. [ tell me more...]
Using the Data Controls panel, you can add an ADF LOV Input for CustomerId to the page, replacing the inputText field for CustomerId after you delete it. [ tell me more...]
You added an
inputListOfValues component to the
editOrders.jspx form. At runtime clicking on the LOV button activates the list of values, from which you can select a value for the field from a user-friendly interface. [
tell me more...]
Copyright © 1997, 2009, Oracle. All rights reserved.false ,,,,,,,,,,,,,,,