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

Community Tip - You can Bookmark boards, posts or articles that you'd like to access again easily! X

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

RFS
11-Garnet
11-Garnet

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

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...

RFS_0-1712771353273.png

... I can create a QB report to get the Document and Notebook folders...

RFS_1-1712771433593.png

RFS_2-1712771474011.png

 

... but I cannot find which table to add so that I can report the "Sample" attachment from the first image.

 

Help?

 

 

 

4 REPLIES 4
Marco_Tosin
21-Topaz I
(To:RFS)

You can find the name of document on ApplicationData table.

 

Marco
RFS
11-Garnet
11-Garnet
(To:Marco_Tosin)

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.

RFS_0-1712864790849.png

 

Marco_Tosin
21-Topaz I
(To:RFS)

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

 

 

Marco
Top Tags