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!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

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
823 views