Community Tip - When posting, your subject should be specific and summarize your question. Here are some additional tips on asking a great question. X
In one of our processes for a Document, the user is expected to upload an attachment into the Document Notebook section (in a particular folder). I am trying to learn the tables involved to report on such an upload and potentially determine that one has or has not been done prior to a workflow task being completed.
Ex: For a Notebook such as below...
... I can create a QB report to get the Document and Notebook folders...
... but I cannot find which table to add so that I can report the "Sample" attachment from the first image.
Help?
You can find the name of document on ApplicationData table.
Hi Marco. I can attach the Application Data table to the Document via the Holder to Content link type and see the primary or secondary content files. But where do I link it to see the Notebook uploads? The Notebook and Notebook Folder tables don't give a suggested link type between themselves and Application Data (Holder to Content is not available).
I have figured out how to list other content such as the Bookmarks, but still cannot find the uploads.
Unfortunately, I do not use Notebooks so I cannot verify how to link the tables together.
I can point you to an article to help in understanding the links between tables/objects.
Below other articles about database relationship:
Overview of the meta model and related APIs in Windchill
Object Relationships for Report Building
How to generate Windchill PLM Database Doc for Oracle Database
Location of HTML version of UML diagrams in Windchill PDMLink