Accessing "Recent Projects" Data and Related Objects via SQL or WRS API in Windchill

[ozclkonur]

Hello,

I'm currently trying to analyze the "Recent Projects" section in Windchill using SQL queries. So far, I’ve identified the Project2 and PlanActivity tables. However, I’ve encountered some inconsistencies:

• The Project2 table returns around 25 records without any filters.

• When I apply the filter statecontainerTeamManagedInf = 'RUNNING', the count drops to 21.

• However, the "Recent Projects" UI only displays 15 projects.

This suggests that additional filtering may be applied internally, but I haven’t been able to identify the exact mechanism yet.

Additionally, I need to retrieve the related documents, WTParts, or EPMDocuments linked to these projects, but I haven't found a clear way to do this yet.

Here are my main questions:

1. Is there a specific SQL table that directly reflects the "Recent Projects" displayed in the Windchill UI?

2. How can I find the WTParts, Documents, or EPMDocuments that are linked to these projects or plans?

3. Is there a WRS (Windchill REST Services) API endpoint that returns a list of associated objects (such as WTParts or Documents) for a given project or plan?

Any guidance or documentation on this would be greatly appreciated.
Thank you in advance!

[Marco_Tosin]

You can take a look at this article

QML to report Project Name and display all of the contents of the project along with Life Cycle State in Windchill ProjectLink

[avillanueva]

In addition to @Marco_Tosin suggestions, check out RecentUpdate table. I am guessing here but I think this is where it stores information about recent activity. You would want to filter for a user (assume that's you) and Projects. Remember that there are user preferences that control how may it should list:

If I have the right table, this should be where you can find what appears as your recent projects list. Remember, this is different for each user and changes as they access different projects.