Skip to Main Content

APEX

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Multiple APEX_ITEM.SWITCH on an Interactive Report

AnnelizeFApr 18 2024 — edited Apr 18 2024

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

This post has been answered by fac586 on Apr 18 2024
Jump to Answer
Comments
Post Details
Added on Apr 18 2024
3 comments
869 views