Hello - for documentation and build purposes, I think the system should be improved to allow certain metadata to be easily accessed. For instance, I would like to get:
* list of all tables * list of views in each table * list of all columns in a table with data types
Regarding the graphviz graphs (currently a LABS feature), those are great, but I think for bulk documentation it should be easier to get all possible graphs dumped out, so that we can save time in documenting.
Of course I understand the idea of not over-documenting, but, sometimes it is unavoidable or required. This sort of info would really help not only when going down and making settings on each table for instance (in that I want a checklist so I do not forget where I am), but also when documenting the system for a client after a go-live.
Regards, Rick
ID 367
Category Other
Author
Rick Cogley
Date Created 9/22/2010 4:14:11 PM
Date Updated 3/2/2011 1:41:17 AM
Status New Idea
Score 20
Promoted By
basenine
Rick Cogley
Comments
Rick Cogley 3/1/2011 6:24:33 PM
My idea is lonely and needs your promotional help! :-)
Kirill Bondar Staff 3/2/2011 1:21:56 AM
API.DescribeApp() + API.DescribeTables() ?
Rick Cogley 3/2/2011 1:28:04 AM
Kirill to the rescue. So we can do this in javascript, for instance?
Kirill Bondar Staff 3/2/2011 1:38:36 AM
Yes, but please note, requesting page should reside in the same domain due to browser's security constraints. Though you can simply place it to application's resources section.
Rick Cogley 3/2/2011 1:41:17 AM
Hi Kirill - yes, we have been trying it in resources, accessing the API via Javascript, and it is much faster than putting it in an external domain, which we did try and found it did not work so well.