How to calculate total time for which a field held a particular value
We have a ticketing system and to solve a ticket, we often need to gather additional information from the ticket opener and a TPA. For each ticket, we log all activities (in a child table) in form of...