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!

Preserve select checkbox in classic report not working

ApexMeisterMar 22 2016 — edited Mar 22 2016

'm using Apex 5.0.3, 11g DB, IE 11.0

I'm following the blog below, but it does work I probably doing something wrong.

Let's Wreck This Together...with Oracle Application Express!: Preserving checked checkboxes in a report

Please note that dbg is a custom procedure that simply writes the string parameter to a file.

I do not get any errors but the on demand pl/sql code is never executed.

Also I tried to debug the page and I can see that the js is being executed except the on demand pl/sql is not being run.

I tried changing the newhtmldb_get parameter to use &app_id. instead of the pFlowid but I get the same result

Below is my classic report sql

SELECT APEX_ITEM.checkbox(1,c002,'onclick="f_SelectModule(this)"') bselect,

c003 module_desc

FROM apex_collections

WHERE collection_name = 'KUM'

Page HTML Header

<script type="text/javascript">
<!--

function f_SelectModule( cb ){
var get = new htmldb_Get(null,$v('pFlowId'),'APPLICATION_PROCESS=SelectModule',0);
get.addParam('x01',cb.value);
gReturn = get.get();
get = null;
}
//-->
</script>

pastedImage_4.png

This post has been answered by Scott Wesley on Mar 22 2016
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Apr 19 2016
Added on Mar 22 2016
1 comment
719 views