Hi Steve <[EMAIL PROTECTED]>
This works for us on Trac 0.10.4:
===================================================
Title:
Active, Visible Tickets Unchanged for More Than 30 Days, oredered by Time
Unchanged
Description:
List tickets that haven't been changed in the last 30 days, sorted by length
of time unchanged.
SQL:
SELECT DISTINCT p.value AS __color__,
id AS ticket,
summary, component, milestone, t.type AS type,
owner, reporter, time AS created,
changetime AS modified, description AS _description,
priority,
round(julianday('now') - julianday(changetime, 'unixepoch')) as days
FROM ticket t
LEFT JOIN enum p ON p.name = t.priority AND p.type = 'priority'
WHERE ((julianday('now') - julianday(changetime, 'unixepoch')) > 30)
AND status = 'assigned'
ORDER BY changetime, p.value, owner
=====================================================
Cheers
Steve McCusker
> -----Original Message-----
> From: trac-users group [mailto:[EMAIL PROTECTED]
> Sent: Monday, 31 March 2008 19:37
> To: trac-users digest subscribers
> Subject: 3 new messages in 2 topics - digest
>
>
>
> Trac Users
> http://groups.google.com/group/trac-users?hl=en
>
> trac-users@googlegroups.com
>
> Today's topics:
>
> * Help! Need simple report to show 'Active tickets that haven't
> been updated/
> modified in the past 7 days' - 1 messages, 1 author
>
> http://groups.google.com/group/trac-users/browse_thread/thread/81f
> e9f49f8bc78c1?hl=en
> * does trac support to send notificaton when a change set in the svn - 2
> messages, 2 authors
>
> http://groups.google.com/group/trac-users/browse_thread/thread/6e4
> d09af10fd76de?hl=en
>
> ==================================================================
> ============
> TOPIC: Help! Need simple report to show 'Active tickets that haven't been
> updated/modified in the past 7 days'
> http://groups.google.com/group/trac-users/browse_thread/thread/81f
> e9f49f8bc78c1?hl=en
> ==================================================================
> ============
>
> == 1 of 1 ==
> Date: Sun, Mar 30 2008 1:26 am
> From: "胡争辉"
>
>
> Do you have a look at the link below:
>
> http://trac.edgewall.org/wiki/TracReports#CreatingCustomReports
>
> 2008/3/29, Steve <[EMAIL PROTECTED]>:
> >
> >
> > Can someone give me the query for this report?
> >
> > I just want to show all active tickets that no-one has updated/modifed
> > in the past 7 days.
> >
> > thanks in advance!
> >
> > Steve
> >
> > >
> >
>
>
> --
> MSN: Contact me by other methods first.
> QQ: 443089607
> QQ mail: [EMAIL PROTECTED]
> Skype: huzhenghui
> Gtalk: huzhengh
> GMail: [EMAIL PROTECTED]
>
>
>
>
>
> ==================================================================
> ============
> TOPIC: does trac support to send notificaton when a change set in the svn
> http://groups.google.com/group/trac-users/browse_thread/thread/6e4
> d09af10fd76de?hl=en
> ==================================================================
> ============
>
> == 1 of 2 ==
> Date: Sun, Mar 30 2008 2:51 am
> From: Xinhao Zheng
>
>
> hi all,
>
> if you got some clue for my situation,pls share me with your idea:
>
> i want to everyone who is involved in the project get a
> notification(email) when changes happened to the svn,.Is that possible?
> or maybe we can try to generate a ticket when user do some changes to
> svn.
>
> thanks!
>
> georgezheng
>
>
>
> == 2 of 2 ==
> Date: Sun, Mar 30 2008 3:21 am
> From: "Emmanuel Blot"
>
>
> Check out the SVN 'commit hook' scripts in the contrib/ directory.
>
> Cheers
> Manu
>
> On Sun, Mar 30, 2008 at 10:51 AM, Xinhao Zheng
> <[EMAIL PROTECTED]> wrote:
> >
> > hi all,
> >
> > if you got some clue for my situation,pls share me with your idea:
> >
> > i want to everyone who is involved in the project get a
> > notification(email) when changes happened to the svn,.Is that possible?
> > or maybe we can try to generate a ticket when user do some changes to
> > svn.
> >
> > thanks!
> >
> > georgezheng
> > >
> >
>
>
>
> --
> Manu
>
>
>
>
> ==================================================================
> ============
>
> 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@googlegroups.com
> or visit http://groups.google.com/group/trac-users?hl=en
>
> To unsubscribe from this group, send email to
> [EMAIL PROTECTED]
>
> To change the way you get mail from this group, visit:
> http://groups.google.com/group/trac-users/subscribe?hl=en
>
> To report abuse, send email explaining the problem to
> [EMAIL PROTECTED]
>
> ==================================================================
> ============
> Google Groups: http://groups.google.com?hl=en
>
>
>
> --
> No virus found in this incoming message.
> Checked by AVG.
> Version: 7.5.519 / Virus Database: 269.22.1/1349 - Release Date:
> 29/03/2008 5:02 PM
>
>
> No virus found in this incoming message.
> Checked by AVG.
> Version: 7.5.519 / Virus Database: 269.22.1/1349 - Release Date:
> 29/03/2008 17:02
>
No virus found in this outgoing message.
Checked by AVG.
Version: 7.5.519 / Virus Database: 269.22.1/1349 - Release Date: 29/03/2008
17:02
--~--~---------~--~----~------------~-------~--~----~
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@googlegroups.com
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
-~----------~----~----~----~------~----~------~--~---
