Hello everyone. I'm using Trac 0.12, and my question is: what value
exactly ticket.time and ticke.changetime return? I selected
changetime and it returned value as "1331537781158000".
I just wanted to get how long before the ticket was modified. And I'm
using the following scripts I got from trac.edgewall.org:
SELECT p.value AS __color__,
t.owner AS __group__,
t.type,
id AS ticket, summary, component, version, t.severity AS severity,
(CASE status WHEN 'assigned' THEN owner||' *' ELSE owner END) AS
owner,
(CASE WHEN round(time.now*1000000 - changetime) > 86400
THEN round((time.now*1000000 - changetime)/86400.0) || ' days'
WHEN time.now*1000000 - changetime > 3600
THEN round((time.now*1000000 - changetime)/3600.0) || ' hours'
ELSE round((time.now*1000000 - changetime)/60) || ' mins'
END) AS LastModified,
description AS _description,
reporter AS _reporter,
milestone AS _milestone
FROM ticket t ,
enum p,
(SELECT current_timestamp as now) time
WHERE p.name = t.priority AND p.type = 'priority'
ORDER BY t.owner, changetime desc, p.value, t.severity, time
However, the "LastModified" returned a wired minus value for me. Could
anyone pls help? I've been working on this for a whole day. Thanks a
lot.
Helen
2012.3.21
--
You received this message because you are subscribed to the Google Groups "Trac
Users" group.
To post to this group, send email to [email protected].
To unsubscribe from this group, send email to
[email protected].
For more options, visit this group at
http://groups.google.com/group/trac-users?hl=en.
