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

Result Base Search

In this lesson we are going to see how to create Result Base Search.

Result base search will give the search results so the results whatever we are seeing in the page are just for display purpose we cannot select the resultant values like the way we select in Inline LOV or External LOV.

Steps to create result base search page in oaf:

 

Step1: Create Workspace, project , AM and create one page assign AM to the page give page title and window title.

For example :-

workspace name : ResultBaseSearch

Project Name : ResultbasesearchPRJ

package name : xxresultbasesearch.oracle.apps.po.resultbasesearchprj.webui

AM name : ResultbasesearchAM

AM Package name: xxresultbasesearch.oracle.apps.po.resultbasesearchprj.server

Step2: Create new VO in respective BC4J, generally List of Values ends with VO and the example BC4J path is:

Package (BC4J) : xxresultbasesearch.oracle.apps.po.inlineprj.server

VO name : ResultBaseSearchVO

Query in the VO is:

SELECT PERSON_ID,            FULL_NAME,            DATE_OF_BIRTH,            KNOWN_AS,            NATIONALITY     FROM PER_ALL_PEOPLE_F

 

Step3: Attach VO to the AM

Step4:- After creating VO and attaching it to AM, in this step create new region under main region and select the region style in property inspector as Query. It means we need to create a Query region under the main region.

27

After creating Query Region in main region select the Query Region property Inspector and in Property Inspector select Construction Mode as Result Base search as shown in the below figure

28

Now in the page structure select the Query region, right click on the Query region select New -> Region Using Wizard…

29

Select Proper Application Module in the first step of creating region as show in the below figure:

30

 

In step2 select the region style as Table as show in the below image:

31

 

In step3 select the attributes of VO which you want to display in the output.

32

Finish the Region using wizard process.

Step5:-  Run the page and see the output, if we observe in the output the Query region creates automatically Go and Clear buttons.

33

Click on GO button to see the resultant output as shown in the below picture:

34

Summary
Review Date
Reviewed Item
Result Base Search
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 Result Base Search"

    Leave a Message

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

    Site Disclaimer, Copyright © 2016 - All Rights Reserved.

    Support


    Please leave a message and we'll get back to you soon.

    I agree to be contacted via e-mail.