Edgewall Software

Opened 8 years ago

Last modified 3 years ago

#10933 new enhancement

Custom Query: Column with last status change

Reported by: anonymous Owned by:
Priority: normal Milestone: unscheduled
Component: query system Version: 1.0
Severity: normal Keywords: workflow status
Cc: Branch:
Release Notes:
API Changes:
Internal Changes:


I couldn't find a possibility to show in custom query another column which show the last status change of a ticket. Is there a way to add such a column that i haven't seen or could this be added to custom query?

Attachments (0)

Change History (5)

comment:1 by Ryan J Ollos <ryan.j.ollos@…>, 8 years ago

It looks like the column selections are determined by the ticket fields. It is not clear what you are asking for though. Are you wishing to know what the previous status of the ticket was prior to the most recent status change, or the timestamp of the last status change? Either way, the information must be obtained from the ticket_change table, and you'd have to write a plugin to provide this extra column option on the custom query page.

comment:2 by anonymous, 8 years ago

I'm sorry for the unclear question.. I would like to get a column which shows how many days/weeks/months the ticket is already in the current status. Would it be possible that someone provides such a plugin? I'm not able to do this..

comment:3 by Christian Boos, 8 years ago

Keywords: workflow status added
Milestone: unscheduled

You might also try TH:RequestaHack.

comment:4 by Ryan J Ollos, 6 years ago

Has been request in th:#10604.

comment:5 by Ryan J Ollos, 3 years ago

Maybe we need an extension point so that plugins can define filters and columns.

Modify Ticket

Change Properties
Set your email in Preferences
as new The ticket will remain with no owner.
The ticket will be disowned.
as The resolution will be set. Next status will be 'closed'.
The owner will be changed from (none) to anonymous. Next status will be 'assigned'.

Add Comment

E-mail address and name can be saved in the Preferences .
Note: See TracTickets for help on using tickets.