Ticket #4364 (closed enhancement: duplicate)

Opened 4 years ago

Last modified 3 years ago

SQL for report to sort tickets based on number of votes

Reported by: lschiere Assigned to: rjollos
Priority: normal Component: VotePlugin
Severity: normal Keywords:
Cc: grone Trac Release: 0.11

Description

It would be awesome if you could sort tickets based on the number of votes they have received.

Attachments

Change History

01/14/09 06:52:54 changed by anonymous

what about his ticket? There you find a sample SQL query #3655

01/19/09 06:38:09 changed by anonymous

here is some draft

SELECT ticket.id AS ticket , COUNT(votes.resource) AS vote, status, severity, priority, owner, time as created, summary

FROM ticket LEFT OUTER JOIN votes ON ('ticket/' ticket.id = votes.resource)

WHERE ticket.status IN ('new', 'assigned', 'reopened')

GROUP BY ticket.id ORDER BY vote DESC

10/05/09 14:46:05 changed by grone

  • cc set to grone.

08/27/10 21:36:39 changed by rjollos

  • owner changed from athomas to rjollos.

Reassigning ticket to new maintainer.

08/27/10 23:13:59 changed by rjollos

  • status changed from new to closed.
  • resolution set to worksforme.

Duplicate of #3655.

08/27/10 23:14:04 changed by rjollos

  • status changed from closed to reopened.
  • resolution deleted.

08/27/10 23:14:09 changed by rjollos

  • status changed from reopened to closed.
  • resolution set to duplicate.

08/28/10 00:08:40 changed by rjollos

  • summary changed from sort tickets by votes to SQL for report to sort tickets based on number of votes.

Add/Change #4364 (SQL for report to sort tickets based on number of votes)




Change Properties
Action