Using APEX 21.1 in the cloud, but example replicated on 23.2.4
In my example app/page: DEMO | demo1234 | Menu > Pretius APEX Nested Reports [Plug-in] (Page 5) I am using a plug-in to display a nested report.
This nested report can only work with either a Classic or an Interactive Report.
I need two columns (review_due, admin_only) to be updateable by a switch and have implemented this using apex_item.switch as can be seen in the SQL of the region ‘Departments’
When the user changes the ‘Review Due’ switch, it uses the following to update the table DEPT accordingly
- dynamic action ‘Change Review Due’ with jQuery Selector
- page items P5_DEPTNO and P5_REVIEW_DUE
However, as soon as I add another switch, it all falls apart. From the way I understand it, the report cannot distinguish between the two switches as the following could apply to either.
jQuery Selector = .apex-item-group--switch .apex-item-option :checked
Therefore, in my example, I have commented out
- column admin_only in Departments region sql
- Change dynamic action for the same column
Has anyone ever tried this and got it to work? Ideally I want both columns to be switches, and not one switch, one checkbox/select.
Thanks
Annelize