Ageing Reports in Bugzilla --- Attention David & Jason....

Mon Jun 2 07:39:43 UTC 2003

I also tried

2002-01-01 and 7

as well as

2002-01-01 and -7

Please help...

>From: "Madhava Challa" <cmadhav at hotmail.com>
>Reply-To: developers at bugzilla.org
>To: developers at bugzilla.org
>Subject: Ageing Reports in Bugzilla --- Attention David & Jason....
>Date: Mon, 02 Jun 2003 07:09:23 +0000
>
>David & Jason,
>
>1. I am using Bugzilla version : 2.16.1
>
>2. I want to generate a report of P1s pending OVER 1 WEEK.
>
>and NOT P1s created during last 1 week.
>
>3. After selecting [Bug_creation] in the list box, I gave the following 
>criteria: ....
>
>Start Date : 2002-01-01 (Older than the first bug in our installation)
>
>End Date : I tried several different combinations...
>
>-7d ----> did'nt work...
>
>as well as
>
>#7d -----> did'nt work...
>
>as well as
>
>Now -7d ----> did'nt work...
>
>Please help...
>
>Regards,
>
>>Which bugzilla version are you using?
>>on the tip I use #d and in version 2.16.2 I use #
>
>>ex: 2.16.2: 7 Now
>    2.17.4: 7d Now
>
>>jason pyeron
>
><html><DIV>
><DIV>
><DIV>Madhava Challa,</DIV>
><P>(360)956-7043 (Home)</P>
><P>(360)923-2697 (Work)</P>
><P>(203)545-2642 (Cell) </P>
><DIV></DIV><A 
>href="mailto:cmadhav at hotmail.com">cmadhav at hotmail.com</A></DIV>
><DIV> </DIV></DIV></html>
>
>
>
>
>>From: David Miller <justdave at syndicomm.com>
>>Reply-To: developers at bugzilla.org
>>To: developers at bugzilla.org
>>Subject: Re: Ageing Reports in Bugzilla
>>Date: Sun, 1 Jun 2003 18:17:06 -0400
>>
>>On 6/1/2003 10:11 PM +0000, Madhava Challa wrote:
>>
>> > All Open P1 bugs pending for more than 7 days.
>> >
>> > The defn of OPEN = (UNCONFIRMED, NEW, ASSIGNED & RE-OPENED)
>> >
>> > The defn of Pending = Pending since bug creation.
>> >
>> > I was trying to do it in a manner where I am not hard-coding any date 
>>in the
>> > query. Unfortunately, Bugzy does'nt seem to support direct querying on 
>>"Open
>> > date" (meaning creation date). Or I could not figure out an easy way to 
>>do
>> > it...
>>
>>In the "Bug Changes" section, "[creation date]" changed between "7 days
>>ago" and "now".  (it's not a well-known fact that you can use relative
>>dates there, but you can :)
>>--
>>Dave Miller      Project Leader, Bugzilla Bug Tracking System
>>http://www.justdave.net/             http://www.bugzilla.org/
>>----
>>To view or change your list settings, click here:
>><http://bugzilla.org/cgi-bin/mj_wwwusr?user=cmadhav@hotmail.com>
>
>_________________________________________________________________
>Tired of spam? Get advanced junk mail protection with MSN 8. 
>http://join.msn.com/?page=features/junkmail
>
>----
>To view or change your list settings, click here:
><http://bugzilla.org/cgi-bin/mj_wwwusr?user=cmadhav@hotmail.com>

_________________________________________________________________
The new MSN 8: smart spam protection and 2 months FREE*  
http://join.msn.com/?page=features/junkmail