Checkbox Style Query in Oracle Apex



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

Post a Comment

Previous Post Next Post