Question

Can i easily transfer a query builder report from one user to another??

  • 17 July 2020
  • 1 reply
  • 147 views

Userlevel 6
Badge +11

Any ideas?

 

Have a personal query builder report a user wants to share with another. Tried simple ‘Send to collague’ but that didn't seem to work


1 reply

Userlevel 7
Badge +18

Here’s some PL/SQL that will copy all the query builder reports from one user to another:

 

DECLARE
   source_user_      VARCHAR2(30) := 'DURETTKETEST1';
   destination_user_ VARCHAR2(30) := 'DURETTKETEST2';
   info_             VARCHAR2(32767);
   objid_            user_quick_report.objid%TYPE;
   objversion_       user_quick_report.objversion%TYPE;
   attr_             VARCHAR2(32767);
BEGIN
   FOR rec_ IN (
       SELECT *
         FROM user_quick_report_tab
        WHERE owner = source_user_
   ) LOOP
      client_sys.clear_attr(attr_);
      user_quick_report_api.new__(info_, objid_, objversion_, attr_, 'PREPARE');
      client_sys.set_item_value('TITLE', rec_.title, attr_);
      client_sys.set_item_value('ROW_TYPE', rec_.row_type, attr_);
      client_sys.set_item_value('OWNER', destination_user_, attr_);
      user_quick_report_api.new__(info_, objid_, objversion_, attr_, 'DO');
      user_quick_report_api.write_sql_expression__(objversion_, objid_, rec_.sql_expression);
      user_quick_report_api.write_query__(objversion_, objid_, rec_.query);
   END LOOP;
END;
/

COMMIT;

Reply