Skip to main content
S
Spiff8-Gravel
8-Gravel
August 22, 2014
Solved

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

  • August 22, 2014
  • 1 reply
  • 1984 views

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

Best answer by JeffZemsky

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

From.png

join.png

select+window.png

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

report_builder.png

1 reply

J
JeffZemsky17-PeridotAnswer
17-Peridot
August 22, 2014

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

From.png

join.png

select+window.png

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

report_builder.png

M
22-Sapphire I
MikeLockwood22-Sapphire I
22-Sapphire I
August 22, 2014

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

Terms & ConditionsCookie settingsAccessibility statement