Skip to main content
O
ozclkonur14-Alexandrite
14-Alexandrite
June 27, 2025
Question

Need Help Accessing WTPart, WTDocument Linked to Recent Projects in Custom C# Application

  • June 27, 2025
  • 1 reply
  • 602 views

Hello,

I’m developing a custom application in C# to integrate with Windchill. My goal is to:

  • List the projects shown under "Recent Projects"

  • When a project is selected, display the related objects such as WTParts, WTDocuments, EPMDocuments, etc.

I have already found and listed the Recent Projects via SQL (likely using the Project2 table and related filters), but I have not been able to identify how to retrieve the associated content (e.g. WTPart, WTDocument) linked to each project.

Could you please help me with:

  1. How to get WTParts, WTDocuments, or other content linked to these Recent Projects?

  2. Whether there is a specific table or join that I should be using in SQL?

  3. Or alternatively, is there a REST API (WRS) endpoint that provides this data?

I would greatly appreciate any guidance or documentation on this.

Thank you in advance.

1 reply

avillanueva
23-Emerald I
avillanueva23-Emerald I
23-Emerald I
June 27, 2025

I am not expert in REST API (yet) but that would be my way to go. If you do not find a REST API that works for you, I recommend writing your own. Windchill is Java based so you can write your own services if you do not find what you are looking for. This can do the heavy lifting for your different steps like accessing recent projects based on a username. I would avoid directly accessing the back end database.

O
ozclkonur14-AlexandriteAuthor
14-Alexandrite
June 27, 2025

I’m also planning to develop this myself, but the main issue is that I couldn’t find the linking table between the projects I found in SQL and the related WTPart, WTDocument, etc.
If I can identify that linking table, it will make everything much easier for me.

joe_morton
18-Opal
joe_morton18-Opal
18-Opal
June 27, 2025

Are you trying to display ALL the objects related to the Project? That could be quite a lot of objects...!

 

Projects are a bit unique in that there can be items stored in the Project (if they were created there), and also items shared to the project. I'm not sure what your use case is.

 

For items stored, it's a Context link

For items shared, it looks like this:

joe_morton_0-1751032001841.png

 

Terms & ConditionsCookie settingsAccessibility statement