Home » Developer & Programmer » Reports & Discoverer » SQL to find folders by view? (Discoverer)
SQL to find folders by view? [message #329037] Mon, 23 June 2008 19:36 Go to next message
Messages: 6
Registered: May 2005
Location: San Diego
Junior Member
Most of our folders in Discoverer are based on database views (i.e., not custom folders.) After a few years of rampant proliferation, we desperately need a way to correlate our database views and Discoverer folders to see which views can be eliminated. Can anyone point me to the table(s) that relate Discoverer folders to database views so that I can come up with a query to search views by folder, folders by view, etc.? Better yet, if you have some sql code that already does this, would you care to share?


Re: SQL to find folders by view? [message #329103 is a reply to message #329037] Tue, 24 June 2008 02:16 Go to previous message
Messages: 913
Registered: March 2005
Location: Netherlands
Senior Member
Years ago I had a script on Discoverer 4 that looked at the database tables eul4_objs (just checked it). I do recall that the folder definitions are in there and I assume the current verions have something similar. Hope this helps a little bit.
Previous Topic: Report
Next Topic: drop down list based on 1th parameter value
Goto Forum:

Current Time: Tue Aug 22 00:35:19 CDT 2017

Total time taken to generate the page: 0.04818 seconds