Modify

Opened 5 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

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 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

Action
as closed .
as The resolution will be set. Next status will be 'closed'.
to The owner will be changed from k0s. Next status will be 'closed'.
The resolution will be deleted. Next status will be 'reopened'.
Author


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

 
Note: See TracTickets for help on using tickets.