Modify

Opened 15 years ago

Closed 14 years ago

#4570 closed enhancement (invalid)

add a report for automatic install for TracLegos

Reported by: Jeff Hammel Owned by: Jeff Hammel
Priority: normal Component: TracLegosScript
Severity: normal Keywords:
Cc: Nicholas Bergson-Shilcock Trac Release: 0.11

Description

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 = t.id
  WHERE p.name = t.priority AND p.type = 'priority'
AND field <> 'resolution'
AND field <> 'milestone'
AND field <> 'component'
AND (field <> 'status' AND tc.newvalue <> 'closed')
 /* GROUP BY t.id*/
  ORDER BY tc.time DESC
LIMIT 40

Attachments (0)

Change History (1)

comment:1 Changed 14 years ago by Jeff Hammel

Resolution: invalid
Status: newclosed

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

Modify Ticket

Change Properties
Set your email in Preferences
Action
as closed The owner will remain Jeff Hammel.
The resolution will be deleted. Next status will be 'reopened'.

Add Comment


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

 
Note: See TracTickets for help on using tickets.