Another question on Reports

[Casey Gregoire]

At our office we would like to be able to make a report (preferably the
tabular report) of bugs that have been opened this month and week, and the
bugs that have been closed this month and week. I have been playing with the
query to try to do this, but I am not sure if this it can do what I need.
(When we define open, we mean bugs that have been entered, and bugs that
have been reopened. And closed we mean as Resolved, Fixed, and Closed.) 
 
The problem I have is that I can't assume the bug was created this week
since the way we use the system bugs can be reopened often, and should be in
the report. And that adds to the problem of bugs that can be reopened. If
these queries don't do that trick does any one have suggestions on how to
best go about adding this to Bugzilla? I don't want to muck up the code.
 
The queries we do are:
For open bugs:
            None of the other query options above is set, except for the
product we want the report on
Status changed after [date to start from] (first of month for monthly
reports, first of week for weekly reports)
And
Status changed to NEW or
Status changed to REOPENED or
Status changed to UNCONFIRMED or
Status changed to ASSIGNED
AND
Status is equal to NEW or
Status is equal to REOPENED or
Status is equal to UNCONFIRMED or
Status is equal to ASSIGNED
 
 
For Closed bugs:
            None of the other query options above are set, except for the
product we want the report on
Status changed after [date to start from] (first of month for monthly
reports, first of week for weekly reports)
And
Status changed to CLOSED 
Status changed to RESOLVED or
Status changed to VERIFIED or
And
Status is equal to CLOSED or
Status is equal to RESOLVED or
Status is equal to VERIFIED or
 
 
Would this give us all of the bugs for the given product opened/created from
the start date, and all of the bugs CLOSED/RESOLVED in the given time
period? I am not sure how the Boolean charts code works and don't want to be
wrong. Does the above Boolean statement get treated as
(Op1 and opt2 or opt3 or opt4 and opt5 opt6 opt7) 
   or is it treated as
(Op1 and (opt2 or opt3 or opt4) and (opt5 opt6 opt7))
 
I think the code does it the second way, and I think it would have to for my
query to get what I want.
 
 
Thank you,
            Casey Gregoire
            Programmer
            CHS of America
            100 1st Ave S. Suite 601
            St. Petersburg, FL 33701
            Phone - (727) 824-0800 ext 1236

Every great achievement was once impossible. -- Anonymous
I'd like to get started on time, if we can, inasmuch as we're late already.
-- Larry Gelbart
Nothing is accomplished without passion. -- My Fortune Cookie
 
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.bugzilla.org/pipermail/developers/attachments/20030602/589f460d/attachment.html>