yeah, basically you can...
- Code: Select all
select `incidentid`,`duration` from sit_updates where `incidentid` = 'XX' and `type` = 'closing';
then add all the resulting rows with each other.
we actually have a feature report for this, so in the near future I think It'll be implemented that each incidet shows the summed amount of time registered.