Changes between Initial Version and Version 1 of AllAssignedTickets


Ignore:
Timestamp:
2010-10-01T23:19:13+02:00 (14 years ago)
Author:
trac
Comment:

--

Legend:

Unmodified
Added
Removed
Modified
  • AllAssignedTickets

    v1 v1  
     1= All Assigned Tickets =
     2
     3{{{
     4#!SQLTable
     5SELECT owner, status, scheduled, component, t.type AS type, project || ':#' || id AS ticket, summary
     6FROM multitrac_query('status = ''assigned'' OR status = ''accepted'' AND owner <> ''''') t
     7LEFT JOIN enum p ON p.name = t.priority AND p.type = 'priority'
     8ORDER BY owner, scheduled
     9
     10}}}