topic Re: How to query attachments in a document's Notebook section (QueryBuilder and/or QuerySpec methods in Windchill Customization

How to query attachments in a document's Notebook section (QueryBuilder and/or QuerySpec methods)

RFS — Thu, 11 Apr 2024 08:44:08 GMT

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?

Re: How to query attachments in a document's Notebook section (QueryBuilder and/or QuerySpec methods

Marco_Tosin — Thu, 11 Apr 2024 06:30:16 GMT

You can find the name of document on ApplicationData table.

Re: How to query attachments in a document's Notebook section (QueryBuilder and/or QuerySpec methods

RFS — Thu, 11 Apr 2024 19:47:21 GMT

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.

Re: How to query attachments in a document's Notebook section (QueryBuilder and/or QuerySpec methods

Marco_Tosin — Fri, 12 Apr 2024 06:51:06 GMT

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.

Understanding Database tables relationships to generate Queries or build Reports in Windchill PDMLink

Re: How to query attachments in a document's Notebook section (QueryBuilder and/or QuerySpec methods

Marco_Tosin — Fri, 12 Apr 2024 07:59:22 GMT

Below other articles about database relationship:

How to get the UML relation among WTUser/WTPrincipal/WTPrincipalReference objects in Windchill PDMLink?

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