Oracle Apex cascading checkboxes

0
votes

i need a solution for this "conventionally" mean using apex native functionality. I have two cascading check boxes when i select any or multiple value from the parent checkbox then the referenced values in checkbox 2 should return (this is working) but when deselect all the values from parent checkbox it should return all the value in checkbox 2. https://apex.oracle.com/pls/apex/f?p=119345:15 help will be appreciated.

1
oracleoracle-apexoracle-apex-5.1

1 Answers

0
votes

Try to use NVL in your input item.

SELECT DEPTNO || '-' || ENAME, EMPNO 
FROM EMP 
WHERE DEPTNO IN 
      (SELECT COLUMN_VALUE 
         FROM TABLE(APEX_STRING.SPLIT(NVL(:P15_CB1,DEPTNO),':'))) 
ORDER BY 1

Ex. https://apex.oracle.com/pls/apex/f?p=145797:3

login on: https://apex.oracle.com/pls/apex/f?p=4550:1

workspace: stackquestions
user: test
pwd: test
app: 145797
page: 3