Skip to main content
P
ptc-33122411-Visitor
1-Visitor
March 25, 2012
Question

WC Workflow's Question

  • March 25, 2012
  • 1 reply
  • 3471 views

Hi All,

We have a workflow for a part request, We want to measure the efficiency of the whole process.like the time taken by Part Request Object in diff states.

So I added a timestamp(after every Set State) and was able to capture it into a Workflow variable......Now I am just to get that value for timestamp posted to an external attribute so that I can use it in my report manager or adv search....Could anyone please advise ?

1 reply

M
22-Sapphire I
MikeLockwood22-Sapphire I
22-Sapphire I
March 25, 2012

The LIFECYCLEHISTORY table includes the timestamp for all state changes, so an easier way to approach this type of reporting is to join LIFECYCLEHISTORY to the request and then report on "created" which is when it arrived at the state of interest. Need to add and join LIFECYCLEHISTORY once for each state of interest.

P
ptc-33122411-VisitorAuthor
1-Visitor
March 26, 2012

Thanks for the reply mike, If I understand correctly does the lifecycle history table is like :

"wt.audit.eventinfo.ChangeLifecycleStateEventInfo" ?

If this is the table which I need to consider then that would solve my problem. Thanks again for your help.

Parveen

Terms & ConditionsCookie settingsAccessibility statement