​How can I get the times it took to pass "activity Status"

[ruben_salazar1983]

How can I get the times it took to pass "activity Status"

Example:

How long does it take for the activity to go from "OPEN" to "DRAFT" and then to "CLOSED"

What fields can I bring to execute a query to be able to find the times between how long it takes between each of these phases.

Could you help me?

[Yanik_Kurzawski]

Hello Ruben Dario Salazar Aya,

I don't think there are any default fields for this. You would need to create some UDF's und a Business Rule that updates those UDF's with a timestamp or the time difference on activity status change to see how long each phase took.

Kind Regards
Yanik

[b_mark]

Hello Ruben, if you are interested in the time the technician needed to finish his work - the object you have to query for is called "ServiceAssignmentStatus" you can use a query like the example below which i had in operation some days ago. Just replace add your activity code.

select s.name, s.createDateTime, s.lastChanged, a.code, a.executionStage FROM ServiceAssignmentStatus s

JOIN Activity a on a.id = s.object.objectId

where a.code = 'your activity code' ORDER BY s.createDateTime ;