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!

Copy an interactive report default state to another interactive report default state

BlueForest85Apr 2 2023 — edited Apr 2 2023

Hello everyone,

MY APEX VERSION NUMBER : 22.1.0

Let's imagine that I have an interactive report A on the page 2.

I also have an interactive report B on the page 3. This interactive report columns are supposed to be the same as the ones of A.

There is also an interactive report C on page 4, with the same columns.

Now, let's imagine that I have to modify the SQL request of the interactive report A on page 2. So, I must also modify the SQL request on page 3 and 4 given that the same columns are displayed.
I sign in the app, go to page 2, and modify the displayed columns of the interactive report A. Then, I save the IR default state.

I must do the same, go to page 3, and 4, modify the displayed columns, and save the default state.

Here we only have a few pages, but in a real application, there could be 5, 6, 7, OR MORE pages where we would have to modify displayed columns, and the default state to display them…

Is there a way to copy an IR state to another one on another page ?

Could it be simpler to modify the SQL requests, displayed columns and default state on one IR, and then copy it to other pages, deleting the existing IR on the targeted page ?

Thank you for your experience !

Comments
Post Details
Added on Apr 2 2023
7 comments
91 views