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

Madhava Challa cmadhav at hotmail.com
Mon Jun 2 08:16:22 UTC 2003


I understand the CURRENT status stuff... Yes, I am not getting those CLOSED 
one's which anyway I do not want to be icluded...

As per you,

When I use

1970-01-01 and 7

I should get everything that was created over 1 week and which is CURRENTLY 
still open...

But I get those as well as more... I am getting even the one's that got 
created in the last 1 or 2 days even...

I can call you on your cell tomorrow, if you do not mind.... Please send me 
your cell #..

appreciate all your help...

Regards,

>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 04:04:44 -0400 (EDT)
>
>
>the earliest possible date ever is Jan 1, 1970 use this as your start
>date.
>for your end date you want 7 days ago
>
>this will return all bugs which are older than 7 days.
>
>filter this for P1, P2, etc.
>
>Rememeber this is the CURRENT status of the bug.
>
>If bug 42 was crerated on Jan 1, 1999 as NEW:P1 and then on March 1, 1999
>it was CLOSED it will not show up as a NEW bug of P1 which is older than 7
>days since it is NOW CLOSED.
>
>I have a lot of code to prep tonight , if you want to call my cell that is
>fine, otherwise the emails will have to wait until this evening.
>
>Jason Pyeron
>
>On Mon, 2 Jun 2003, Madhava Challa wrote:
>
> > 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
> >
> > ----
> > 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>

_________________________________________________________________
Add photos to your e-mail with MSN 8. Get 2 months FREE*.  
http://join.msn.com/?page=features/featuredemail




More information about the developers mailing list