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!

Dynamic action with interactive report region refresh

Bas de KlerkApr 26 2011 — edited Mar 19 2012
Hi!

I'm using APEX 4.02

I've got a page with 2 regions.
Region1 is a (input) form
Region2 is an interactive report on the same table as region 1

When entering values on the form I'm trying to dynmically lookup similar records in the table with the interactive report.

I've made a dynamic action on the change of the form fields which should refresh the interactive report region. I can see this one fires if I add a alert to debug if it fires.
The dynamic report is based on a query with bind variables pointing to the form fields, for example
where
field1 = :P2_FIELD1


This works great on the page load, so no dynamic action is fired but I can see the rows in the report region are the ones I am looking for.
But the refresh of the report region is not working, it is never refreshing and/or showing the correct data after a change of the form fields, so it looks like the dynamic action "refresh region" is not working on the interactive report.

Any ideas why this can go wrong ?
I would like to solve this using standard dynamic actions and preferrably not via PL/SQL or JS, shoudl be possible if I should believe the documentation... ;)

Cheers
Bas

Edited by: bklerk on 26-apr-2011 3:07
This post has been answered by jariola on Apr 26 2011
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Apr 16 2012
Added on Apr 26 2011
7 comments
4,956 views