We would be able to see the comments added to columns by keeping cursor on column name by selecting macros “Display Entities Note on Workspace” and by running the scripts.
TDM Enhancement Proposal:
1. While presenting the data model html report generated from TDM to business.
2. In the html report we have a tab called “ER diagram”.
3. Html report will not have an option to show the columns comments if we keep the cursor on column name on the ER diagram.
4. It would be great if we have an option for an entity format to display the column comments section in the workspace.
5. Screen snap attached to this thread on 0712 - file name "Attributes Enhancement" [ Refer this thread ] - https://community.toadworld.com/products/toad-data-modeler/f/30/t/35582
6. In the workspace -- Right click on any Entity -- Format -- Entity -- Pick display level as “Attributes” and Introduce a new field to have “Display Column Comments”
I'd be happy if the comments would display with a mouse over of the field....but if there's a way to get another documents export with the comments that'd be nice too.
My initial request was to have an option to display column comments in the workspace. Like in the attached ER diagram we have column, datatype, field is mandatory or not, PK or FK, like wise if we have an option to display column comments in the workspace that would be great.
I am aware that we can add a note at column level while creating ER diagram. However, added note will be seen only if we keep our mouse over respective column in TDM tool.
If we are presenting/sharing a HTML report to developers or to the business, they want to see the notes by looking at ER diagram in HTML report. If we have an option to display column comments in the workspace, HTML report by default will have comments in the ER diagram.
