Skip to main content
6-Contributor
Nov 22, 2026 5:44 PM UTC
Question

How to Retrieve the First Start Time of a Repeated Workflow Activity in Windchill?

Hi Team,

I have a requirement to retrieve the first/original Start Time of a workflow activity in Windchill.

The same workflow activity can be executed multiple times due to rework or workflow routing.

For example:

 

Execution 1:

Start Time : 10-NOV-2026 10:48

 

Execution 2 (after rework):

Start Time : 12-NOV-2026 11:17

 

Execution 3 (after another rework):

Start Time : 15-NOV-2026 09:30

My expected result is:

Plain Text

First Start Time : 10-NOV-2026 10:48

Currently, when working with WfActivity and WorkItem, I am getting the Start Time from the latest/current execution.

My requirement is to retrieve the first-ever Start Time, even if the same activity has been executed multiple times due to rework.

Could you please suggest:

  1. How can I retrieve the historical executions of the same workflow activity?
  2. How can I identify the first/original Start Time?
  3. Is WFSTATEEVENTAUDIT with TRIPCOUNT the correct approach for identifying previous executions?
  4. Is there a supported Windchill Java API to retrieve this information instead of directly querying the workflow database tables?

If possible, please share a sample Java API/code example.

Thanks in advance.