| SQL to find folders by view? [message #329037] |
Mon, 23 June 2008 19:36  |
dmoser22
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?
Thanks,
-djm
|
|
|
|
| Re: SQL to find folders by view? [message #329103 is a reply to message #329037] |
Tue, 24 June 2008 02:16  |
skooman
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.
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
