Skip to main content
1-Visitor
Sep 10, 2015 1:09 PM UTC
Question

How discussion / comments are associated to Problem Report?

Hello

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

Regards

Sameer

5 replies

13-Aquamarine
Sep 10, 2015 8:38 PM UTC

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.

Translate
13-Aquamarine
Sep 30, 2015 9:05 PM UTC

Sameer,

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

Translate
sathalye1-VisitorAuthor
1-Visitor
Oct 1, 2015 2:03 PM UTC

No !!! I couldn't join them.

Translate