Skip navigation
995 Views 7 Replies Latest reply: Mar 29, 2012 11:49 AM by MikeLockwood RSS
ptc-3312241 Copper 10 posts since
Oct 4, 2011
Currently Being Moderated

Mar 24, 2012 11:03 PM

WC Workflow's Question

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 ?

  • MikeLockwood Diamond 255 posts since
    May 7, 2010
    Currently Being Moderated
    Mar 25, 2012 3:26 PM (in response to ptc-3312241)
    Re: WC Workflow's Question

    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.

      • MikeLockwood Diamond 255 posts since
        May 7, 2010
        Currently Being Moderated
        Mar 26, 2012 8:06 AM (in response to ptc-3312241)
        Re: WC Workflow's Question

        I can send a sample report if you like - don't see a way to attach files here.

        send to: mike.lockwood@alconlabs.com

            • MikeLockwood Diamond 255 posts since
              May 7, 2010
              Currently Being Moderated
              Mar 29, 2012 11:49 AM (in response to ptc-3312241)
              Re: WC Workflow's Question

              Not too sure.  May be a variety of situations depending on object type.  Create generally refers to the Iteration / Revision (e.g. when Checked in for a Document/Part).  Modify could mean Iterate but also could mean Move, State change, rename, lifecycle re-assign, etc.  Would be nice to have a listing of this from PTC.  Need to study the database table (UpdatestampA2) to really know.

More Like This

  • Retrieving data ...

Bookmarked By (0)

Legend

  • Correct Answers - 3 points
  • Helpful Answers - 1 points