Opened 6 years ago

Closed 5 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 5 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 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.