Home » Developer & Programmer » Reports & Discoverer » Query against Discoverer Reports, by a specific folder
Query against Discoverer Reports, by a specific folder [message #410609] Mon, 29 June 2009 04:19 Go to next message
garylythgoe
Messages: 39
Registered: February 2008
Location: Cambridge UK
Member
All,

We need to identify all Discoverer Reports, which use a specific folder i.e all reports which use the folder 'AR Transactions' etc.

Is this possible?

We have some SQL which identifies stats when reports were last ran, etc but dont know we can list reports which use a specific folder.

Any guidance would be appreciated.

Regards,
Gary
Re: Query against Discoverer Reports, by a specific folder [message #413595 is a reply to message #410609] Thu, 16 July 2009 10:48 Go to previous messageGo to next message
Rod123
Messages: 2
Registered: July 2009
Junior Member
Seems difficult to do.

Do you mind if I ask why you want to identify all Discoverer Reports which use a specific folder?

garylythgoe wrote on Mon, 29 June 2009 01:19
All,

We need to identify all Discoverer Reports, which use a specific folder i.e all reports which use the folder 'AR Transactions' etc.

Is this possible?

We have some SQL which identifies stats when reports were last ran, etc but dont know we can list reports which use a specific folder.

Any guidance would be appreciated.

Regards,
Gary

Re: Query against Discoverer Reports, by a specific folder [message #413596 is a reply to message #413595] Thu, 16 July 2009 11:09 Go to previous message
garylythgoe
Messages: 39
Registered: February 2008
Location: Cambridge UK
Member
Hi there,

We need to make a big change to a folder which is used a LOT! But the change will also require a change in the reports to make them function correctly, so we need to identify them. I have written some code which will now work..


SELECT DISTINCT 
                b.doc_name workbook_name, 
				fus.user_name created_by
           FROM <eul_schema>.eul4_qpp_stats a,
                <eul_schema>..eul4_documents b,
                <eul_schema>..eul4_objs c,
                <eul_schema>..eul4_bas d,
                <eul_schema>..eul4_ba_obj_links f,
                fnd_user fus
          WHERE a.qs_doc_name = b.doc_name
            AND c.obj_id = SUBSTR (a.qs_object_use_key, 1, 6)
            AND c.obj_id = f.bol_obj_id
            AND d.ba_id = f.bol_ba_id
            AND TO_CHAR (fus.user_id) = SUBSTR (b.doc_updated_by, 2)
--			AND b.doc_name LIKE '%CCC%WI12%'
			AND	c.obj_name = <folder name here>


Hope this helps someone!
Previous Topic: Export Discoverer query to Excel directly
Next Topic: Oracle reports *********
Goto Forum:
  


Current Time: Thu Mar 28 16:48:05 CDT 2024