Skip to main content
6-Contributor
Nov 12, 2026 1:12 PM UTC
Question

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 WFSTATEEVENTAUDIT with TRIPCOUNT the 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?