Real time consumed on task (Sum)

[przemek_kompix_]

Hello

I'm looking for possibility to report time consumed for single task in workflow.

If i get single task and change it's status to:
In Progress
On Hold
In Progress
On Hold
In Progress
On Hold
In Progress
Completed

Is a way to count time spend on every pairs In Progress - next step? Are these information are kept in database?

Or is that is not possible, is date recorded into database when status of task is changed?

Or maybe is a plugin or option when the task is in specific state, the time is count? For example, task was 4 times in state In progress. How could I now the sum of its periods (for example 2hours +  1hour +  2hours +  3hours = 8 hours). And finally time spend on the workflow.

Best Regards
Przemysław Staniszewski

[mitpatoliya]

No, there is nothing related to time consumed for each task is stored in the database.
Only start time is stored I guess.
So, all you need to do is you need to explicitly capture those times at each transition and finally you can get the total time taken based on that.

[przemek_kompix_]

This is a very good tip.

It can be done by my own trigger in database which calculate time add to destination.

It's possible to write that feature in alfersco way without adding the trigger?