How to retrieve the first Start Time of a repeated workflow activity in Windchill?
Title:
How to retrieve the first Start Time and latest Completion Time of a repeated workflow activity in Windchill?
Description:
Hi Team,
We have a requirement to retrieve the Start Date and Completed Date of a workflow activity for a Change Notice.
In certain cases, the same workflow activity can be executed multiple times due to rework or workflow routing.
The required logic is:
- Start Date: First time the activity was started.
- Completed Date: Last/latest time the activity was completed.
For example:
Activity Execution 1
Start Time : 10-NOV-2023 10:48
Completed Time : <first completion>
Activity Execution 2
Start Time : 12-NOV-2026 11:17
Completed Time : 12-NOV-2026 11:20
Expected Result:
Start Date : 10-NOV-2023 10:48
Completed Date : 12-NOV-2026 11:20
- What is the recommended Windchill API or database approach to retrieve the first-ever Start Time of a workflow activity when the activity has been repeated?
- How can we retrieve the latest Completion Time after multiple executions/rework?
- Is
WFSTATEEVENTAUDITwithTRIPCOUNTthe appropriate source for this historical information? - Is there a supported Windchill API available for obtaining this information instead of directly querying the workflow database tables?


