Calculating Duration of an SCTASK - San Diego

[Diane Zawada]

Hello - I am trying to create a report calculating Duration on SCTASKS. The Duration and Business Duration are fields I can bring into my report. The Business Duration calculates, however the  Duration does not, I'm using the SC_Task table and all my other criteria are working. I also tried to do this in a classic list view and Duration while a choice is not being calculated. Can you advise why I can get this information on Incident but not on Catalog tasks? Seems strange like I'm missing something. 

Perhaps this is only available for Incident? Thanks for any help you can provide. 

[BharathChintala]

@Diane Zawada  OOB incident duration will be calculated. For SC_TASK you have write script to populate.

[OlaN · Accepted solution]

Hi,

Like Bharath already stated, OOB incident durations are automatically calculated when a record is closed, but there is no such thing on SCTASKS.

You will need to create your own Business Rule to do the calculation whenever a SCTASK is closed.

You should be able to copy and reuse the existing Business rule on incident table and make modifications on it to be used on the sc_task table.

Have a look at the business rule called "mark_closed" on the incident table to get information on how it works.

Or ask if you need more details/help.

[Diane Zawada]

thanks I'll check into that rule, and see what we can do.