Tickets by resolution displays incorrect data
|Reported by:||Alex||Owned by:||Ryan J Ollos|
The Tickets by Resolution displays incorrect data. It will always display all tickets as resolved by as a single status (e.g. 'fixed', 'worksforme', etc.) based on the resolution status of the last ticket that has been resolved.
The problem can be fixed by adding 'GROUP BY resolution' to the end of the query starting on line 85 in model.py so the query looks like this:
cursor.execute(""" SELECT resolution, count(resolution) FROM ticket WHERE status='closed' AND id IN (%s) GROUP BY resolution""" % ",".join(str_ids))