Posted By

qrist0ph on 05/22/08



Versions (?)

Trac Report Alle offenen Aufgaben

 / Published in: SQL

  1. SELECT p.value AS __color__,
  2. id AS ticket, summary, t.type AS type,
  3. STATUS,
  4. time AS created,
  5. changetime AS _changetime, description AS _description,
  6. reporter AS _reporter
  7. FROM ticket t, enum p
  8. WHERE STATUS <> 'closed'
  9. AND = t.priority AND p.type = 'priority' AND (t.type='task' OR t.type='AllgemeineAufgabe')
  10. ORDER BY p.value, milestone, t.type, time

Report this snippet  

You need to login to post a comment.