Ageing Reports in Bugzilla --- Attention David & Jason....
Jason Pyeron
jason at pyeron.com
Mon Jun 2 08:04:44 UTC 2003
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.
More information about the developers
mailing list