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

Mon Jun 2 07:40:05 UTC 2003

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.