Skip to:
Content

{23} Popular Tickets

  • Tickets that have one vote or more
  • Sort by vote, component, type, summary
  • Accepted tickets have an '*' appended to their owner's name

Reports:

Report execution failed:
OperationalError: no such table: votes

SELECT COUNT(*) FROM (
SELECT
  CASE
  WHEN keywords LIKE '%needs_unit_tests%' OR keywords LIKE '%needs_docs%'
  THEN 3
  WHEN keywords LIKE '%close%' OR keywords LIKE '%needs_review%'
    OR keywords LIKE '%dev_feedback%' OR keywords LIKE '%2nd_opinion%'
  THEN 2
  WHEN keywords LIKE '%reporter_feedback%'
  THEN 3
  WHEN keywords LIKE '%commit%' OR keywords LIKE '%tested%'
  THEN 1
  WHEN keywords LIKE '%early%'
  THEN 2
  ELSE 3
  END as __color__,
  CASE
  WHEN SUM(COALESCE(vote, 0)) > 5
  THEN 'Very Popular'
  WHEN SUM(COALESCE(vote, 0)) > 1
  THEN 'Popular'
  ELSE 'Noteworthy'
  END as __group__,
  id AS ticket,
  summary,
  CASE
  WHEN status = 'accepted'
  THEN owner || '*'
  WHEN owner <> 'anonymous'
  THEN owner
  ELSE ''
  END as owner,
  component,
  version as _version,
  priority as priority,
  severity,
  SUM(COALESCE(vote, 0)) as votes,
  milestone as milestone,
  t.type AS type,
  status AS _status,
  CASE
  WHEN keywords LIKE '%needs_unit_tests%'
  THEN 'needs-unit-tests'
  WHEN keywords LIKE '%needs_docs%'
  THEN 'needs-docs'
  WHEN keywords LIKE '%close%'
  THEN 'close'
  WHEN keywords LIKE '%needs_review%'
  THEN 'needs-review'
  WHEN keywords LIKE '%dev_feedback%' OR keywords LIKE '%2nd_opinion%'
  THEN 'dev-feedback'
  WHEN keywords LIKE '%reporter_feedback%'
  THEN 'reporter-feedback'
  WHEN keywords LIKE '%commit%'
  THEN 'commit'
  WHEN keywords LIKE '%tested%'
  THEN 'tested'
  WHEN keywords LIKE '%has_patch%'
    OR keywords LIKE '%needs_testing%' AND keywords NOT LIKE '%needs_patch%'
  THEN 'has-patch'
  WHEN keywords LIKE '%early%'
  THEN 'early'
  ELSE ''
  END as workflow,
  time AS _created,
  changetime AS modified,
  description AS _description,
  reporter AS _reporter
FROM ticket t
LEFT JOIN votes v ON v.resource = 'ticket/' || id
WHERE status <> 'closed'
  AND Component <> 'WordPress.org'
GROUP BY t.id
HAVING votes > 0
ORDER BY votes DESC, Component, t.type, summary



) AS tab
Note: See TracReports for help on using and creating reports.