One of the best ways to document GP Configuration is to put an explanation into the “Comments” of the Elements. This makes it easier for those who follow in your foot sets to understand the configuration without looking in archives and searching through documents formatted by Project Managers who think paper grows on trees :-P.
However, I have never met a Project Manager that doesn’t want a hard copy Design Document for their customer to sign-off.
Element Comments are stored in the Database as a “CLOB”, making them difficult to extract. The following script extracts Comments from the CLOB using the “TO_CHAR” function.
|
SELECT PIN_NM, DESCR, TO_CHAR(COMMENTS)
FROM PS_GP_PIN
WHERE LENGTH(TO_CHAR(COMMENTS)) > 0
|
Run this script from your SQL Client… you are then just a cut and paste away from finishing your Design Document.
Its like you learn my mind! You seem to grasp a lot about this, like you wrote the guide in it or something.
I think that you can do with a few percent to drive the message house a bit, however instead of that,
this is great blog. An excellent read. I’ll certainly be back.