cancel
Showing results for 
Search instead for 
Did you mean: 
cancel
Showing results for 
Search instead for 
Did you mean: 

We are happy to announce the new Windchill Customization board! Learn more.

Creating a Query Builder Report To Tie WTParts To Referencing Documents

srector
1-Newbie

Creating a Query Builder Report To Tie WTParts To Referencing Documents

I am trying to create a Query Builder Report that will accept a WTPart Number and return a list displaying the status information of all of the Documents referencing this part.



The wt.part.WTPartDocumentLink will give me a list of the relevant documents (It ties parts to docs), but I can’t figure out how to join this link to Document objects so that I can get the status info (State, Rev, etc.).



I have searched through the forum but haven’t found a lead as yet.



Can someone point me in the right direction, or suggest a better approach for getting to my end goal?



Any advice will be greatly appreciated.


Thanks,


Steve

1 REPLY 1
MikeLockwood
22-Sapphire I
(To:srector)

Attached

- 2 separate reports; may or may not want to combine (may not be possible)

- Doc attributes (e.g. state) are not included but can easily be added

- Key is the use of the doc Master and the joins
Top Tags