Sometimes client needs consult inside os SQL tables what comments were done in each campaign approve process to generate a custom report.
To do this this techdoc mentiones what tables are necessary research in SQL/Oracle tables from Governance Minder database.
What tables need to research inside of GM tables to see the entered comments from approvers and what universe/campaign belongs these comments?
Doing a select in table BusinessFlowComments can see all Comments but it's not possible determine what universe/campaign generated the comment with only one id present in this table.
- The table comments that contains the approver comments during a campaign are inside of BusinessFlowComments table. This table have the column Comment ID.
- With # of column CommentID that is also present in the another table named as "BFTaskComments" it's possible see the in the colum BusinessFlowId #.
- BusinessFlowId is a number too and with this value doing a select in the table BusinessFlows it's possible to disocover what Universe, Owner, Name (of campaign) and other informations from that comment.
- One example:
if Commentid id #1 and BusinessFlowId is #27 you do a select in a third table named as "BusinessFlows" that will have the column "Universe", "Owner", "Name", etc... for that Comment.