Process Mapping Logo

Process Mapping - Forums

Sharing 19 years of knowledge and experience

 
Metastorm BPM forums
Sign up Latest Topics
 
 
 


Reply
  Author   Comment  
powerplay

Avatar / Picture

Senior Member
Registered:
Posts: 77
Reply with quote  #1 
Hi, 

There need to generate the report that shows the time difference between Entry time and Event time in minutes.

But for a loop back action. eEntryTime in eEvent table is NULL.

How to use the EntryTime in case of loop back action?


Thanks!

__________________
Thanks
HB
0
BMellert

Guru
Registered:
Posts: 688
Reply with quote  #2 
You are correct, initial events have no entry time.
In that case you should probably use Creation Time.
0
powerplay

Avatar / Picture

Senior Member
Registered:
Posts: 77
Reply with quote  #3 
But Creation Time will tell me the time at which the folder was created.
What I required is the time at which the folder enters a specific stage where loop back action is triggered.
Bit surprised why its not updating EntryTime.. :(

__________________
Thanks
HB
0
BMellert

Guru
Registered:
Posts: 688
Reply with quote  #4 
Sorry, I had not read close enough.
My theory as to why they do this, loop back actions don't come from a different stage, so they don't record an entry time.  They seem to only record it as it leaves the stage.  Good for determining how long something is in a stage, but not so good for what you are trying to do.

If the folder is currently in that stage, you can get its entry time from eFolder.eEntryTime.

Otherwise, you can determine the entry time by looking for the next action where eEvent.eEntryTime is populated (min(eEntryTime) for same eFolderID and eActionCount > current action count).

Or if you know you need this data for other computations, store it as a variable or in another table.
0
JoeOmerta

Veteran
Registered:
Posts: 210
Reply with quote  #5 
There's "when action started/completed" and "when stage started/completed" if understanding you correctly.
0
BMellert

Guru
Registered:
Posts: 688
Reply with quote  #6 
That only works if the folder is in the current stage.  I agree its the best approach if that's the case.

I have the impression though that Powerplay is looking for if its not in the current stage ... such as for historical purposes.
0
powerplay

Avatar / Picture

Senior Member
Registered:
Posts: 77
Reply with quote  #7 
Yes, actually to generate the time taken at each stage for every action(EntryTime - EventTime). If Loop back action is excecuted 5 times.
We can calculated the time = Difference(1st time,5th time) as the agg total of being in the same stage. But not the time taken for individual loop.

I think, the time needs to be captured in some variable OR table everytime loopback action is executed.

__________________
Thanks
HB
0
Previous Topic | Next Topic
Print
Reply

Quick Navigation:


Create your own forum with Website Toolbox!