Opened 8 years ago

Closed 7 years ago

#4570 closed enhancement (invalid)

add a report for automatic install for TracLegos

Reported by: k0s Owned by: k0s
Priority: normal Component: TracLegosScript
Severity: normal Keywords:
Cc: nicholasbs Trac Release: 0.11


This should give changed tickets:

SELECT id AS ticket, summary, component, milestone, t.type AS type, severity,
t.time AS created_,
   tc.field AS field, tc.newvalue AS description_,
   changetime AS _changetime, reporter AS _reporter
  FROM ticket t, enum p
  OUTER JOIN ticket_change tc ON tc.ticket =
  WHERE = t.priority AND p.type = 'priority'
AND field <> 'resolution'
AND field <> 'milestone'
AND field <> 'component'
AND (field <> 'status' AND tc.newvalue <> 'closed')
 /* GROUP BY*/
  ORDER BY tc.time DESC

Attachments (0)

Change History (1)

comment:1 Changed 7 years ago by k0s

  • Resolution set to invalid
  • Status changed from new to closed

this doesn't seem relevent at the moment. please reopen with actionable details if desired

Add Comment

Modify Ticket

as closed The owner will remain k0s.
The resolution will be deleted. Next status will be 'reopened'.

E-mail address and user name can be saved in the Preferences.

Note: See TracTickets for help on using tickets.