Using apex version 5.1.3 and db 11gr2. I am trying to pass value from parent page(page -7) to child page (page -9).
On parent page i have an item which gets the value from EMP table using LISTAGG then on click of button on same page i am redirecting it to child page where i have an IR which will render based on values present in IN clause of Pivot column.
Child page sql of IR :
with primary_data as (
Select deptno,empno,p_var
FROM emp
where p_var is not null
)
select * from
primary_data
pivot(
max(deptno) as a
for(p_var) IN(&P9_IN_CLAUSE_VALUES.)) --'1001','1002','1003','1004','1005' this values are comming from parent page.
Now the problem is every time value changes of child page item P9_IN_CLAUSE_VALUES i am not able to re-create IR. It shows the old values every time is there any way to display new columns every time based on condition.
I am facing the same issue in IG as well.I can create a dynamic plsql region but i wanted to know can we re-create the IR/IG based on condition.
credentials :
IG_PIVOT/test/test
page 7- and -9