Step-1 :
=====
Create Region.
Name : Check Box
Type : Static Content
Create New Item this Region.
Name : P2_DEPARTMENTS
Type : CheckBox
List Of Values -
Type : SQL Query
SELECT DEPARTMENT_NAME,DEPARTMENT_ID FROM DEPARTMENTS ORDER BY 1;
Create Dynamic Action on P2_DEPARTMENTS
Action - Refresh
Affected Elements - Selection type - Region
Region - Employees
Step-2 : ===== Create New Region. Name : Employees Type : Interactive Report SQL Query : select E.EMPLOYEE_ID, E.FIRST_NAME, E.LAST_NAME, E.EMAIL, E.PHONE_NUMBER, E.HIRE_DATE, E.JOB_ID, E.SALARY, E.COMMISSION_PCT, E.MANAGER_ID, D.DEPARTMENT_NAME from EMPLOYEES E, DEPARTMENTS D where E.DEPARTMENT_ID=D.DEPARTMENT_ID AND INSTR( :P2_DEPARTMENTS, D.DEPARTMENT_ID)>0 AND D.DEPARTMENT_ID IS NOT NULL Page Items to Submit : P2_DEPARTMENTS
Tags:
Oracle Apex