Sun. Oct 24th, 2021

Requirement: Let us assume we have two Regions in our page. The first is for the Search Panel, and the second region is to display the Search Results in a tabular format.

In the Search Panel we will have an item to enter the Department ID, and also a Search button.

In the Search Results region, we will be displaying the Employees Data corresponding to the Department ID which we entered in the Search Panel.

Sample screen is shown below:

Solution: For solution of the above requirement follow the steps as shown below:

Step 1: Let us create a Blank Page > Create two Regions with the name as Search Panel, and Search Results.

Step 2: Inside the Search Panel region let me have a Text Item and a Button as shown below:

Step 3: Set the property of the Search Results regions as below

  • Title: Search Result
  • Type: Interactive Grid
  • Location: Location Database
  • Type: Table/View
  • Table Name: EMPLOYEES
  • Where Clause: DEPARTMENT_ID = nvl(:P2_DEPARTMENT_ID, DEPARTMENT_ID)
  • Page Items to Submit: P2_DEPARTMENT_ID

Step 4: Create a Dynamic Action for the P2_SEARCH_BUTTON. Set the below properties for the Dynamic Action

  • Name: Reset_Report
  • Event: Click
  • Selection Type: Button
  • Button: P2_SEARCH_BUTTON

Step 5: Set the properties of the True outcome as below:

  • Action: Refresh
  • Selection Type: Region
  • Region: Search Result
  • Event: Refresh_Report

Save the changes and run the application. Thus, the ran application is shown below:

Give the value for the Department Id field as 3, and click on the Search button. And with that we can see the Search Results is getting refresh and displaying only those Employees whose Department Id is 3.

Hence, the solution to our requirement.

If you like the post please comment, share, and do join me on Facebook. Please subscribe to my YouTube Channel for video tutorials.

Thanks & Regards,
Susanto Paul

 852 total views,  6 views today

By Susanto Paul

Susanto is an Oracle ACE, a qualified MCA, MBA, and a highly-skilled Senior Oracle Specialist. He is an enthusiastic Blogger and YouTuber who helps learners to solve their complex problems more efficiently. He has 9+ years of experience in multiple technologies like AWS, Oracle ADF, Oracle APEX, Oracle JET, Oracle VBCS, Oracle IDCS, Oracle PL/SQL, Oracle Integration Cloud, Java, JDBC, Servlets, JSP, Spring, Hibernate, HTML5, CSS3, JavaScript, TypeScript, NodesJS, Angular, MySQL, Oracle WebLogic Server, JUnit, JMeter, Selenium Web Driver, etc. He is a certified: Oracle Certified Professional Java SE 6 Programmer, Oracle ADF 11g Certified Implementation Specialist, Oracle Cloud Platform Application Integration 2020 Certified Specialist, Oracle Cloud Infrastructure Foundations 2020 Certified Associate, and Oracle Cloud Infrastructure Developer 2020 Certified Associate

Leave a Reply

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