• USA : +1 973 910 5725
  • INDIA: +91 905 291 3388
  • info@tekslate.com
  • Login

Automatic Search Inline LOV

In this lesson we will see how to create Inline LOV search page.

Inline LOV is used to search with in the page.

The following are the steps to create Inline LOV

Step1: Create the new WorkSpace and project, create new page add AM to the page.

Step2: Create new VO in respective BC4J. While creating VO change the package name of BC4J to “.lov.server” at end, generally List of Values VO ends with LOVVO and the example BC4J path is:

 

Package (BC4J) : xxinlinelov.oracle.apps.po.inlineprj.lov.server

VO name : InlineLOVVO

Query in the VO is:

SELECT first_name FROM PER_ALL_PEOPLE_F

The Application Navigator of the project now looks like:

9

Step3: Under the main page create new item and select item style in property Inspector as “MessageLOVInput”.

We can find List of Values region under Message LOV Input item.

Right click on the List of Values region select New -> Table Using Wizard…

Here we can create Table Style region only we cannot change the region style to another one.

See the below image it shows that how the page structure will look now:

10

Select the FirstName item under the table region and then in the property Inspector of that item check that in the Functional, Search Allowed is set to True.

Step4: Select LOV Mappings in the structure of Message LOV input after that do the following changes in the property inspector of lovMap1.

Functional:

LOV Region Item : FirstName  (the item to display in the LOV region)

Return Item : item1 (the item to return)

Criteria Item : item1 (criteria item works like in where condition value)

Run the page and see the output. The first page of the output looks like the following:

11

click on the search symbol  12 so that it leads us to another page as shown in the below figure:

13

Check the Radio Button of which employee you want to choose and then click on Select button or use Quick Select option to select the name which is required.

After choosing the name it will display in the Message Text Input item as follows:13

Check the Radio Button of which employee you want to choose and then click on Select button or use Quick Select option to select the name which is required.

After choosing the name it will display in the Message Text Input item as follows:

14

Summary
Review Date
Reviewed Item
Automatic Search Inline LOV
Author Rating
5

“At TekSlate, we are trying to create high quality tutorials and articles, if you think any information is incorrect or want to add anything to the article, please feel free to get in touch with us at info@tekslate.com, we will update the article in 24 hours.”

0 Responses on Automatic Search Inline LOV"

Leave a Message

Your email address will not be published. Required fields are marked *

Site Disclaimer, Copyright © 2016 - All Rights Reserved.