Skip to content

Instantly share code, notes, and snippets.

@wheresalice

wheresalice/gist:112195

Created May 15, 2009 12:42
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save wheresalice/112195 to your computer and use it in GitHub Desktop.
Save wheresalice/112195 to your computer and use it in GitHub Desktop.
Download ZIP
Display open Trac tickets modified in the past 10 days
Raw
gistfile1.sql
SELECT p.value AS __color__,
id AS ticket, summary, component, version, t.type AS type,
owner, status,
time AS created,
changetime AS _changetime, description AS _description,
reporter AS _reporter
FROM ticket t, enum p
WHERE status <> 'closed'
AND unix_timestamp(date_sub(now(), interval 10 day)) < changetime
AND p.name = t.priority AND p.type = 'priority'
ORDER BY changetime desc
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment