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

Mon Jun 2 07:53:28 UTC 2003

Jason,

I am not sure what you mean by "start date" in my situation...

Let me repeat - I am interesting in looking at the aging of pending bugs...

specifically :- P1 bugs pending over 7 days...

The start date that I used was just a bogus date -- earliest date that I 
could use in my installation. End date I did try 7.

so, when I tried :

Start Date : 2002-01-01
End Date : 7

I do get Pendingt P1 bugs, but the system included even the P1s that were 
created in the last 1 week..

But, I want the system to pick up P1s that were created over 1 week ago and 
which are still pending. It should not have given me the P1s that were 
created in the last 1 week...

So, If you understood what I am saying, please try out your query in your 
own installation before making a suggestion...

Thanks!

<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: Jason Pyeron <jason at pyeron.com>
>Reply-To: developers at bugzilla.org
>To: developers at bugzilla.org
>Subject: Re: Ageing Reports in Bugzilla --- Attention David & Jason....
>Date: Mon, 2 Jun 2003 03:40:05 -0400 (EDT)
>
>
>the days are relative to Now
>
>and it is 7 not #7d ( i ment that as a format )
>
>so you want to do a query like start date , start date + 7?
>
>On Mon, 2 Jun 2003, Madhava Challa wrote:
>
>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=jpyeron@pyerotechnics.com>
>
>
>--
>-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
>-                                                               -
>- Jason Pyeron                   http://www.pyerotechnics.com   -
>- Owner & Lead                  Pyerotechnics Development, Inc. -
>- +1 410 808 6646 (c)           500 West University Parkway #1S -
>- +1 410 467 2266 (f)           Baltimore, Maryland  21210-3253 -
>-                                                               -
>-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
>
>This message is for the designated recipient only and may contain
>privileged, proprietary, or otherwise private information. If you
>have received it in error, purge the message from your system and
>notify the sender immediately.  Any other use of the email by you
>is prohibited.
>
>
>
>----
>To view or change your list settings, click here:
><http://bugzilla.org/cgi-bin/mj_wwwusr?user=cmadhav@hotmail.com>

_________________________________________________________________
Protect your PC - get McAfee.com VirusScan Online  
http://clinic.mcafee.com/clinic/ibuy/campaign.asp?cid=3963