How does the "Duration field" on Problem task works??

[ganesht]

Hi,

I want to know how the Duration field works and on what conditions it is based on. I have a req to show a field for total time spent on Problem task. Can I use Duration field for this??

[Sharath Chandra]

Hi Ganesh,

On Problem table, Duration field has the dateDiff between the problem opened and closed dates, and Business duration has calDateDiff between the opened and closed dates. These fields are populated when the task is closed. The calculations are part of "mark_closed" business rule on problem table.

If you want to the similar behaviour on "Problem Task", you can try and create a similar business rule to perform the calculations. Depending on your requirement you can set either of the fields or both of them.

Regards,

Sharath