mpotter at catcomtec
Jul 15, 2009, 10:18 AM
Post #4 of 4
(351 views)
Permalink
|
In a SQL style report include "changetime AS modified" among the fields in
the SELECT clause. Example:
-- ## 7: My Open Tickets ## --
-- All open tickets for current user.
SELECT p.value AS __color__,
(CASE status WHEN 'accepted' THEN 'Accepted' ELSE 'Owned' END) AS
__group__,
id AS ticket, summary, component, version, milestone,
t.type AS type, priority, time AS created,
changetime AS modified,
description AS _description,
reporter AS _reporter
FROM ticket t
LEFT JOIN enum p ON p.name = t.priority AND p.type = 'priority'
WHERE t.status <> 'closed' AND owner = $USER
ORDER BY (status = 'accepted') DESC, CAST(p.value AS int), milestone,
t.type, time
For Custom Query style reports, click on "> Columns" to open the list of the
available columns, set the "Modified" check .
-----Original Message-----
From: trac-users [at] googlegroups [mailto:trac-users [at] googlegroups] On
Behalf Of Thomas Vriet
Sent: Wednesday, July 15, 2009 12:48 PM
To: trac-users [at] googlegroups
Subject: [Trac] Re: "last modified date" in tickets view
more precisely what I'm looking for is : how I can make the ticket display
page to
have a "Modified" column, for instance this Trac do this :
http://core.trac.wordpress.org/report/1
RJOllos wrote:
> Sounds like you want to setup a custom query via the /query page.
>
> On Jul 7, 3:23 pm, Thomas Vriet <tho...@goto10.org> wrote:
>> hello,
>>
>> how do I get a Trac to display a "last modified date" column in "View
tickets"
>> page. It seems to be possible as I saw it on other tracs.
>>
>> thanks and sorry if this is a trivial one but I didn't find any clue so
far.
>>
>> cheers,
>>
>> Thomas
> >
>
--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups "Trac Users" group.
To post to this group, send email to trac-users [at] googlegroups
To unsubscribe from this group, send email to trac-users+unsubscribe [at] googlegroups
For more options, visit this group at http://groups.google.com/group/trac-users?hl=en
-~----------~----~----~----~------~----~------~--~---
|
