OraFAQ Forum: Reports & Discoverer » Query against Discoverer Reports, by a specific folder

Home » Developer & Programmer » Reports & Discoverer » Query against Discoverer Reports, by a specific folder

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Query against Discoverer Reports, by a specific folder [message #410609]

Mon, 29 June 2009 04:19

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

Report message to a moderator

Re: Query against Discoverer Reports, by a specific folder [message #413595 is a reply to message #410609]

Thu, 16 July 2009 10:48

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

Report message to a moderator

Re: Query against Discoverer Reports, by a specific folder [message #413596 is a reply to message #413595]

Thu, 16 July 2009 11:09

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!

Report message to a moderator

Previous Topic:	Export Discoverer query to Excel directly
Next Topic:	Oracle reports *********

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Wed Nov 27 03:56:45 CST 2024