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!

APEX 5.1 Dynamic Action with Refresh

Bozzy-OracleFeb 21 2018 — edited Feb 21 2018

Hi.

I have noticed some behaviour with dynamic actions which I would like to understand. I have a report region and a Select List item. Based on the value of the of the select list item the report region is refreshed. I had tried two methods one works and the other doesn't. It is the latter that I am wanting to understand.

The two options were basically:

1. Approach that works.

   A single dynamic Action on the Select List Item which:

   - True Action 1:

      Performs a PL/SQL execution (a simple NULL;) to submit the the select list item session state;

   - True Action 2:

      Performs a refresh on the interactive report region.

2. The approach which doesn't work:

     Two separate dynamic actions:

      DA1 on my select list item:

      - True Action:

        Performs a PL/SQL execution (a simple NULL;) to submit the the select list item session state;

   

     DA2 on my select list item:

    - True Action:

          Performs a refresh on the ineractive report region.

With this second approach the report variable binding always seem to be based on the value of the previous selection (always one step behind).

Thanks in advance,

Clive  

Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Mar 21 2018
Added on Feb 21 2018
1 comment
372 views