How discussion / comments are associated to Problem Report?

[sathalye]

Hello

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

Regards

Sameer

[ChrisSpartz]

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.

[ChrisSpartz]

Sameer,

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

[sathalye]

No !!! I couldn't join them.

[LoriSood]

Sameer,

I used Chris Spartz's  data model explanation to create the attached QML. It may give you a starting point for what you need.

Thanks,
Lori

[Marco_Tosin]

Lori,

I have linked this discussion to the document Resource for reporting