且构网

分享程序员开发的那些事...
且构网 - 分享程序员编程开发的那些事

Oracle Apex 19.2 - 在经典报告中创建单选按钮

更新时间:2022-10-14 20:42:43

Install Sample Reporting application on your APEX instance (preferably on apex.oracle.com as Dan suggested).

Navigate to the Classic Report page.

Change the query to the report to the following:

select rowid,
       ID,
       PROJECT,
       TASK_NAME,
       START_DATE,
       END_DATE,
       STATUS,
       ASSIGNED_TO,
       COST,
       BUDGET,
       apex_item.radiogroup(1,TASK_NAME) ACTION
from EBA_DEMO_IR_PROJECTS
where (nvl(:P3_STATUS,'0') = '0' or :P3_STATUS = status)

Note the added column "ACTION" which consists of the apex_item.radiogroup with TASK_NAME value. Let's assume that this is the value that you want to pass to another page item.

Open that column's attribute under Page Designer and disable "Escape special characters" attribute and add a CSS Class (e.g. mycolumn)

Create a Page Item (e.g. P3_NEW).

Now add the following Dynamic Action

  • Event > Click
  • Selection Type > jQuery Selector
  • jQuery Selector > #classic_report .mycolumn input

Your true action will be of the type Set Value and the Set Type is JavaScript Expression with the following code:

this.triggeringElement.value

Your affected element is P3_NEW and disable Fire on Initialization