Creating a Query Builder Report To Tie WTParts To Referencing Documents

[srector]

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

[MikeLockwood]

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