WordPress.org

Make WordPress Core

{31} Tickets in the Media component

Create a new ticket
  • Active tickets in the Media component
  • Grouped by workflow and sorted by type, summary
  • Accepted tickets have an '*' appended to their owner's name
Report execution failed:
TypeError: not enough arguments for format string

SELECT COUNT(*) FROM (
SELECT
  CASE
  WHEN milestone LIKE '_.%'
  THEN 'Slated for Next Release'
  WHEN milestone = 'Awaiting Review' AND (keywords LIKE '%reporter_feedback%' OR keywords LIKE '%close%' OR keywords LIKE '%2nd_opinion%')
  THEN 'Candidates for Closure'
  WHEN milestone = 'Awaiting Review'
  THEN 'Tickets Awaiting Review'
  WHEN strftime("%s", current_date) - 31536000 >= changetime / 1000000
  THEN 'Tickets Not Modified in a Year'
  WHEN keywords LIKE '%feedback%'
  THEN 'Tickets Needing Feedback'
  WHEN keywords LIKE '%has_patch%'
  THEN 'Tickets with Patches'
  WHEN type = 'defect (bug)'
  THEN 'Unpatched Bugs'
  ELSE 'Unpatched Enhancements'
  END as __group__,
  id AS ticket,
  summary,
  CASE
  WHEN status = 'accepted'
  THEN owner || '*'
  ELSE owner
  END as owner,
  component as _component,
  version as _version,
  priority as priority,
  severity,
  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
WHERE t.component = %s
  AND status <> 'closed'
ORDER BY CASE
  WHEN milestone LIKE '_.%'
  THEN 10
  WHEN keywords LIKE '%reporter_feedback%' OR keywords LIKE '%close%' OR keywords LIKE '%2nd_opinion%'
  THEN 40
  WHEN milestone = 'Awaiting Review'
  THEN 20
  WHEN strftime("%s", current_date) - 31536000 >= changetime / 1000000
  THEN 30
  WHEN keywords LIKE '%feedback%'
  THEN 50
  WHEN keywords LIKE '%has_patch%'
  THEN 60
  WHEN type = 'defect (bug)'
  THEN 70
  ELSE 80
  END, t.type, summary
) AS tab
Note: See TracReports for help on using and creating reports.