Help with Query Builder - Problem Reports NOT linked to a Change Request

[kpritchard]

Hi All,

I'm trying to use Query Builder/Report Builder to find all Problem Reports in the System that are not linked to a Change Request. I thought I was close using a Join and Formalized By which would give me the Problem Reports that do have a linked Change Request but I ended up getting some erroneous exclusions. (Problem Reports that were not included in the returns using the Join with Change Request [WTChangeRequest2] and fomralized by).

Beyond that, anyone have any guidance on how to better understand and use this capability?

Thanks!

[Marco_Tosin]

Hi Keir,

in the community there is a group about reporting that you can join.

http://communities.ptc.com/groups/reporting

I wrote an article in which I collect things about reporting from different places.

http://communities.ptc.com/docs/DOC-6348

Probably you won't find the exact answer from your question, but I hope it can be helpful in some other way.

Marco

[kpritchard]

awesome! Thanks Marco!