Query Builder Report: getting the related Promotion Requests of a Drawing

[Spiff]

Hi,

I am searching for a Query Builder Report definition to get informations of Promotion Requests that have collected specific Drawings (EPMDocuments).

With other words: the search criteria should be the EPMDoc's Number and the result should be the Number (and some additional infos like Status) of every Promotion Request where this EPMDoc is a part of.

I found this report which I try to modify to add a connection to EPMDocuments but I don't know what tables and joins are necessary.

https://support.ptc.com/appserver/cs/view/case_solution.jsp?n=CS112325&lang=en

Can you help me?

Thanks!

David

[JeffZemsky · Accepted solution]

Add Promotion Request and CAD Document to the Report types. Use Promotion Target as the Join type. Add the appropriate attributes.

When you generate the report you can then pick the fields to display and search on.

[MikeLockwood]

Attached is above w/a few additional nice-to-have features.

[JarrettOberg]

Hi David,

Were these examples able to resolve your issue?

Thanks,
Jarrett

[Spiff]

Hi Jeffrey, Mike & Jarrett,

sorry for my delayed answer.

Yes, Jeffrey's description has been perfect to solve my issue!

Thanks a lot.

David