Sun. Oct 24th, 2021

Requirement: I have an Oracle APEX page displaying the Department’s data in tabular format. On the page, I have an item with the label as Department Name. Now, when we enter some value in the Department Name item and press the Enter Key of our keyboard, it should search and display the corresponding department details in the table.

Sample output screen is shown below:

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

Step 1: Create a blank page. Create a Region with the Title as Search

Step 2: Create an Item inside the Search Region. Set the properties for the Item as below:

  • Name: P12_DEPARTMENT_NAME
  • Type: Text Field
  • Label: Department Name

Step 3: Create a Dynamic Action for the P12_DEPARTMENT_NAME item and set the below properties.

  • Name: DepartmentNameDA
  • Event: Key Down
  • Type: Item is not null
  • Item: P12_DEPARTMENT_NAME

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

  • Action: Execute JavaScript Code
  • Code:
if(event.which == 13)
{
   apex.submit('P12_DEPARTMENT_NAME'); 
}

Step 5: Create another Region and set the below properties:

  • Title: Departments
  • Type: Classic Report
  • Location: Local Database
  • Type: Table / View
  • Table Name: DEPARTMENTS
  • Where Clause:
DEPARTMENT_NAME like '%'||:P12_DEPARTMENT_NAME||'%' or :P12_DEPARTMENT_NAME IS NULL or :P12_DEPARTMENT_NAME =''

Click on Save and Run Page button. Thus, the ran page will look as below:

Enter Human in the Department Name field and press on the Enter Key of our Keyboard, and we can see the result table displaying only those record whose Department Name is having Human in it, say for example Department Name as Human Resource as shown below:

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

 765 total views,  3 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 *