Skip to main content
1-Visitor
September 10, 2015
Question

How discussion / comments are associated to Problem Report?

  • September 10, 2015
  • 1 reply
  • 2444 views

Hello

How discussion / comments are associated to Problem Report? How can we fetch it in Query Builder report?

Regards

Sameer

1 reply

13-Aquamarine
September 10, 2015

On the Database level, it looks like each entry in the DiscussionPosting table has its branchida3b5 column pointing to the ControlBranch table. The ida3b5 column of the ControlBranch entry then points to the WtChangeIssueMaster table. The ida3masterreference column of WTChangeIssue also points to WTChangeIssueMaster.

13-Aquamarine
September 30, 2015

Sameer,

Were you able to able to successfully link discussions and problem reports in your query builder report?

sathalye1-VisitorAuthor
1-Visitor
October 1, 2015

No !!! I couldn't join them.