Skip to Main Content
Feature Request FR-2778
Product Area APIs
Status DELIVERED

27 Voters

Supported API to copy saved, private Interactive Reports from one user to another

morten Public · Oct 3 2022

Idea Summary
Need a supported way (PL/SQL API) to duplicate private reports from one user to another. See https://twitter.com/mortenbraten/status/1575051748535738368 

Use Case
One user has set up an Interactive Report, and would like to share it with others, but the “Save Public Report” can't be used (for any number of reasons, such as the application being multitenant and saving it as public would show the report to users in all tenants). Therefore need a supported way to duplicate private reports from one user to another.

Preferred Solution (Optional)
A PL/SQL API (in the APEX_IR package?) to copy a specific report, and specify the username of the user to copy the report to. We could then use this API in our own apps to manage the duplication of reports according to various business and access rules.

This has been delivered in Oracle APEX 23.2!

Known Duplicates

Known duplicates

FR-2335
FR-2335 Export/Import Saved Report Definitions

Comments

Comments

  • denes.kubicek OP 2.7 years ago (edited 2.7 years ago)

    Voted for your idea. I have one related to the hidden columns and standard report settings. Please vote if you like it.

    https://apex.oracle.com/ideas/FR-2742

  • jayson hanes Admin OP 1.4 years ago

    Here's the doc link https://docs.oracle.com/en/database/oracle/apex/23.2/aeapi/CLONE_REPORT-Function.html

  • ankita.mishra OP 10 months ago

    Hello @jayson hanes ,

    This Clone Report is working for the logged In user but if we are trying to perform same action for a new user (when p_new_owner => :APP_USER then it works but when we provide a new user) then it only generates the new id with same report name is shared but the it did not clone all filters, computations, and linked objects of the report that was shared. Although the report name is shared with the new user, and these elements are missing. Shouldn't the entire report, including these elements, be cloned? Can you please help me what probably am I doing wrong?

    @morten Did you tried it , Does it worked for you? 

    Thanks!