<html xmlns:o="urn:schemas-microsoft-com:office:office" xmlns:w="urn:schemas-microsoft-com:office:word" xmlns="http://www.w3.org/TR/REC-html40">
<head>
<META HTTP-EQUIV="Content-Type" CONTENT="text/html; charset=iso-8859-1">
<meta name=ProgId content=Word.Document>
<meta name=Generator content="Microsoft Word 9">
<meta name=Originator content="Microsoft Word 9">
<link rel=File-List href="cid:filelist.xml@01C32921.72D558F0">
<!--[if gte mso 9]><xml>
<o:OfficeDocumentSettings>
<o:DoNotRelyOnCSS/>
</o:OfficeDocumentSettings>
</xml><![endif]--><!--[if gte mso 9]><xml>
<w:WordDocument>
<w:View>Normal</w:View>
<w:Zoom>0</w:Zoom>
<w:DocumentKind>DocumentEmail</w:DocumentKind>
<w:EnvelopeVis/>
</w:WordDocument>
</xml><![endif]-->
<style>
<!--
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
{mso-style-parent:"";
margin:0in;
margin-bottom:.0001pt;
mso-pagination:widow-orphan;
font-size:12.0pt;
font-family:"Times New Roman";
mso-fareast-font-family:"Times New Roman";}
p.MsoAutoSig, li.MsoAutoSig, div.MsoAutoSig
{margin:0in;
margin-bottom:.0001pt;
mso-pagination:widow-orphan;
font-size:12.0pt;
font-family:"Times New Roman";
mso-fareast-font-family:"Times New Roman";}
span.EmailStyle15
{mso-style-type:personal-compose;
mso-ansi-font-size:10.0pt;
mso-ascii-font-family:Arial;
mso-hansi-font-family:Arial;
mso-bidi-font-family:Arial;
color:black;}
@page Section1
{size:8.5in 11.0in;
margin:1.0in 1.25in 1.0in 1.25in;
mso-header-margin:.5in;
mso-footer-margin:.5in;
mso-paper-source:0;}
div.Section1
{page:Section1;}
-->
</style>
</head>
<body lang=EN-US style='tab-interval:.5in'>
<div class=Section1>
<p class=MsoNormal><span class=EmailStyle15><font size=2 color=black
face=Arial><span style='font-size:10.0pt;mso-bidi-font-size:12.0pt;font-family:
Arial'>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.) <o:p></o:p></span></font></span></p>
<p class=MsoNormal><span class=EmailStyle15><font size=2 color=black
face=Arial><span style='font-size:10.0pt;mso-bidi-font-size:12.0pt;font-family:
Arial'><![if !supportEmptyParas]> <![endif]><o:p></o:p></span></font></span></p>
<p class=MsoNormal><span class=EmailStyle15><font size=2 color=black
face=Arial><span style='font-size:10.0pt;mso-bidi-font-size:12.0pt;font-family:
Arial'>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.<o:p></o:p></span></font></span></p>
<p class=MsoNormal><span class=EmailStyle15><font size=2 color=black
face=Arial><span style='font-size:10.0pt;mso-bidi-font-size:12.0pt;font-family:
Arial'><![if !supportEmptyParas]> <![endif]><o:p></o:p></span></font></span></p>
<p class=MsoNormal><span class=EmailStyle15><font size=2 color=black
face=Arial><span style='font-size:10.0pt;mso-bidi-font-size:12.0pt;font-family:
Arial'>The queries we do are:<o:p></o:p></span></font></span></p>
<p class=MsoNormal><span class=EmailStyle15><font size=2 color=black
face=Arial><span style='font-size:10.0pt;mso-bidi-font-size:12.0pt;font-family:
Arial'>For open bugs:<o:p></o:p></span></font></span></p>
<p class=MsoNormal><span class=EmailStyle15><font size=2 color=black
face=Arial><span style='font-size:10.0pt;mso-bidi-font-size:12.0pt;font-family:
Arial'><span style="mso-spacerun: yes"> </span><span
style='mso-tab-count:1'> </span>None of
the other query options above is set, except for the product we want the report
on<o:p></o:p></span></font></span></p>
<p class=MsoNormal style='text-indent:.5in'><span class=EmailStyle15><font
size=2 color=black face=Arial><span style='font-size:10.0pt;mso-bidi-font-size:
12.0pt;font-family:Arial'>Status changed after [date to start from] (first of
month for monthly reports, first of week for weekly reports)<o:p></o:p></span></font></span></p>
<p class=MsoNormal style='text-indent:.5in'><span class=EmailStyle15><font
size=2 color=black face=Arial><span style='font-size:10.0pt;mso-bidi-font-size:
12.0pt;font-family:Arial'>And<o:p></o:p></span></font></span></p>
<p class=MsoNormal style='text-indent:.5in'><span class=EmailStyle15><font
size=2 color=black face=Arial><span style='font-size:10.0pt;mso-bidi-font-size:
12.0pt;font-family:Arial'>Status changed to NEW or<o:p></o:p></span></font></span></p>
<p class=MsoNormal style='text-indent:.5in'><span class=EmailStyle15><font
size=2 color=black face=Arial><span style='font-size:10.0pt;mso-bidi-font-size:
12.0pt;font-family:Arial'>Status changed to REOPENED or<o:p></o:p></span></font></span></p>
<p class=MsoNormal style='text-indent:.5in'><span class=EmailStyle15><font
size=2 color=black face=Arial><span style='font-size:10.0pt;mso-bidi-font-size:
12.0pt;font-family:Arial'>Status changed to UNCONFIRMED or<o:p></o:p></span></font></span></p>
<p class=MsoNormal style='text-indent:.5in'><span class=EmailStyle15><font
size=2 color=black face=Arial><span style='font-size:10.0pt;mso-bidi-font-size:
12.0pt;font-family:Arial'>Status changed to ASSIGNED<o:p></o:p></span></font></span></p>
<p class=MsoNormal style='text-indent:.5in'><span class=EmailStyle15><font
size=2 color=black face=Arial><span style='font-size:10.0pt;mso-bidi-font-size:
12.0pt;font-family:Arial'>AND<o:p></o:p></span></font></span></p>
<p class=MsoNormal style='text-indent:.5in'><span class=EmailStyle15><font
size=2 color=black face=Arial><span style='font-size:10.0pt;mso-bidi-font-size:
12.0pt;font-family:Arial'>Status is equal to NEW or<o:p></o:p></span></font></span></p>
<p class=MsoNormal style='text-indent:.5in'><span class=EmailStyle15><font
size=2 color=black face=Arial><span style='font-size:10.0pt;mso-bidi-font-size:
12.0pt;font-family:Arial'>Status is equal to REOPENED or<o:p></o:p></span></font></span></p>
<p class=MsoNormal style='text-indent:.5in'><span class=EmailStyle15><font
size=2 color=black face=Arial><span style='font-size:10.0pt;mso-bidi-font-size:
12.0pt;font-family:Arial'>Status is equal to UNCONFIRMED or<o:p></o:p></span></font></span></p>
<p class=MsoNormal style='text-indent:.5in'><span class=EmailStyle15><font
size=2 color=black face=Arial><span style='font-size:10.0pt;mso-bidi-font-size:
12.0pt;font-family:Arial'>Status is equal to ASSIGNED<o:p></o:p></span></font></span></p>
<p class=MsoNormal><span class=EmailStyle15><font size=2 color=black
face=Arial><span style='font-size:10.0pt;mso-bidi-font-size:12.0pt;font-family:
Arial'><![if !supportEmptyParas]> <![endif]><o:p></o:p></span></font></span></p>
<p class=MsoNormal><span class=EmailStyle15><font size=2 color=black
face=Arial><span style='font-size:10.0pt;mso-bidi-font-size:12.0pt;font-family:
Arial'><![if !supportEmptyParas]> <![endif]><o:p></o:p></span></font></span></p>
<p class=MsoNormal><span class=EmailStyle15><font size=2 color=black
face=Arial><span style='font-size:10.0pt;mso-bidi-font-size:12.0pt;font-family:
Arial'>For Closed bugs:<o:p></o:p></span></font></span></p>
<p class=MsoNormal><span class=EmailStyle15><font size=2 color=black
face=Arial><span style='font-size:10.0pt;mso-bidi-font-size:12.0pt;font-family:
Arial'><span style="mso-spacerun: yes"> </span><span
style='mso-tab-count:1'> </span>None of
the other query options above are set, except for the product we want the
report on<o:p></o:p></span></font></span></p>
<p class=MsoNormal style='text-indent:.5in'><span class=EmailStyle15><font
size=2 color=black face=Arial><span style='font-size:10.0pt;mso-bidi-font-size:
12.0pt;font-family:Arial'>Status changed after [date to start from] (first of
month for monthly reports, first of week for weekly reports)<o:p></o:p></span></font></span></p>
<p class=MsoNormal style='text-indent:.5in'><span class=EmailStyle15><font
size=2 color=black face=Arial><span style='font-size:10.0pt;mso-bidi-font-size:
12.0pt;font-family:Arial'>And<o:p></o:p></span></font></span></p>
<p class=MsoNormal style='text-indent:.5in'><span class=EmailStyle15><font
size=2 color=black face=Arial><span style='font-size:10.0pt;mso-bidi-font-size:
12.0pt;font-family:Arial'>Status changed to CLOSED <o:p></o:p></span></font></span></p>
<p class=MsoNormal style='text-indent:.5in'><span class=EmailStyle15><font
size=2 color=black face=Arial><span style='font-size:10.0pt;mso-bidi-font-size:
12.0pt;font-family:Arial'>Status changed to RESOLVED or<o:p></o:p></span></font></span></p>
<p class=MsoNormal style='text-indent:.5in'><span class=EmailStyle15><font
size=2 color=black face=Arial><span style='font-size:10.0pt;mso-bidi-font-size:
12.0pt;font-family:Arial'>Status changed to VERIFIED or<o:p></o:p></span></font></span></p>
<p class=MsoNormal style='text-indent:.5in'><span class=EmailStyle15><font
size=2 color=black face=Arial><span style='font-size:10.0pt;mso-bidi-font-size:
12.0pt;font-family:Arial'>And<o:p></o:p></span></font></span></p>
<p class=MsoNormal style='text-indent:.5in'><span class=EmailStyle15><font
size=2 color=black face=Arial><span style='font-size:10.0pt;mso-bidi-font-size:
12.0pt;font-family:Arial'>Status is equal to CLOSED or<o:p></o:p></span></font></span></p>
<p class=MsoNormal style='text-indent:.5in'><span class=EmailStyle15><font
size=2 color=black face=Arial><span style='font-size:10.0pt;mso-bidi-font-size:
12.0pt;font-family:Arial'>Status is equal to RESOLVED or<o:p></o:p></span></font></span></p>
<p class=MsoNormal style='text-indent:.5in'><span class=EmailStyle15><font
size=2 color=black face=Arial><span style='font-size:10.0pt;mso-bidi-font-size:
12.0pt;font-family:Arial'>Status is equal to VERIFIED or<o:p></o:p></span></font></span></p>
<p class=MsoNormal><span class=EmailStyle15><font size=2 color=black
face=Arial><span style='font-size:10.0pt;mso-bidi-font-size:12.0pt;font-family:
Arial'><![if !supportEmptyParas]> <![endif]><o:p></o:p></span></font></span></p>
<p class=MsoNormal><span class=EmailStyle15><font size=2 color=black
face=Arial><span style='font-size:10.0pt;mso-bidi-font-size:12.0pt;font-family:
Arial'><![if !supportEmptyParas]> <![endif]><o:p></o:p></span></font></span></p>
<p class=MsoNormal><span class=EmailStyle15><font size=2 color=black
face=Arial><span style='font-size:10.0pt;mso-bidi-font-size:12.0pt;font-family:
Arial'>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<o:p></o:p></span></font></span></p>
<p class=MsoNormal><span class=EmailStyle15><font size=2 color=black
face=Arial><span style='font-size:10.0pt;mso-bidi-font-size:12.0pt;font-family:
Arial'>(Op1 and opt2 or opt3 or opt4 and opt5 opt6 opt7) <o:p></o:p></span></font></span></p>
<p class=MsoNormal><span class=EmailStyle15><font size=2 color=black
face=Arial><span style='font-size:10.0pt;mso-bidi-font-size:12.0pt;font-family:
Arial'><span style="mso-spacerun: yes"> </span>or is it treated as<o:p></o:p></span></font></span></p>
<p class=MsoNormal><span class=EmailStyle15><font size=2 color=black
face=Arial><span style='font-size:10.0pt;mso-bidi-font-size:12.0pt;font-family:
Arial'>(Op1 and (opt2 or opt3 or opt4) and (opt5 opt6 opt7))<o:p></o:p></span></font></span></p>
<p class=MsoNormal><span class=EmailStyle15><font size=2 color=black
face=Arial><span style='font-size:10.0pt;mso-bidi-font-size:12.0pt;font-family:
Arial'><![if !supportEmptyParas]> <![endif]><o:p></o:p></span></font></span></p>
<p class=MsoNormal><span class=EmailStyle15><font size=2 color=black
face=Arial><span style='font-size:10.0pt;mso-bidi-font-size:12.0pt;font-family:
Arial'>I think the code does it the second way, and I think it would have to
for my query to get what I want.<o:p></o:p></span></font></span></p>
<p class=MsoNormal><span class=EmailStyle15><font size=2 color=black
face=Arial><span style='font-size:10.0pt;mso-bidi-font-size:12.0pt;font-family:
Arial'><![if !supportEmptyParas]> <![endif]><o:p></o:p></span></font></span></p>
<p class=MsoNormal><span class=EmailStyle15><font size=2 color=black
face=Arial><span style='font-size:10.0pt;mso-bidi-font-size:12.0pt;font-family:
Arial'><![if !supportEmptyParas]> <![endif]><o:p></o:p></span></font></span></p>
<p class=MsoAutoSig><!--[if supportFields]><font color=black><span
style='color:black'><span style='mso-element:field-begin'></span><span
style="mso-spacerun: yes"> </span>AUTOTEXTLIST \s "E-mail
Signature" <span style='mso-element:field-separator'></span></span></font><![endif]--><i><font
color=gray><span style='color:gray;font-style:italic'>Thank you,<o:p></o:p></span></font></i></p>
<p class=MsoAutoSig><i><font size=3 color=gray face="Times New Roman"><span
style='font-size:12.0pt;color:gray;font-style:italic'><span style='mso-tab-count:
1'> </span><b><span
style='font-weight:bold'>Casey Gregoire<o:p></o:p></span></b></span></font></i></p>
<p class=MsoAutoSig><b><i><font size=3 color=gray face="Times New Roman"><span
style='font-size:12.0pt;color:gray;font-weight:bold;font-style:italic'><span
style='mso-tab-count:1'> </span></span></font></i></b><i><font
color=gray><span style='color:gray;font-style:italic'>Programmer<o:p></o:p></span></font></i></p>
<p class=MsoAutoSig><i><font size=3 color=gray face="Times New Roman"><span
style='font-size:12.0pt;color:gray;font-style:italic'><span style='mso-tab-count:
1'> </span><b><span
style='font-weight:bold'>CHS of America<o:p></o:p></span></b></span></font></i></p>
<p class=MsoAutoSig><b><i><font size=3 color=gray face="Times New Roman"><span
style='font-size:12.0pt;color:gray;font-weight:bold;font-style:italic'><span
style='mso-tab-count:1'> </span></span></font></i></b><i><font
color=gray><span style='color:gray;font-style:italic'>100 1st Ave S. Suite 601<o:p></o:p></span></font></i></p>
<p class=MsoAutoSig><i><font size=3 color=gray face="Times New Roman"><span
style='font-size:12.0pt;color:gray;font-style:italic'><span style='mso-tab-count:
1'> </span>St.
Petersburg, FL 33701<o:p></o:p></span></font></i></p>
<p class=MsoAutoSig><i><font size=3 color=gray face="Times New Roman"><span
style='font-size:12.0pt;color:gray;font-style:italic'><span style='mso-tab-count:
1'> </span>Phone
- (727) 824-0800 ext 1236<o:p></o:p></span></font></i></p>
<p class=MsoNormal><font size=3 color=black face="Times New Roman"><span
style='font-size:12.0pt;color:black'><br>
</span></font><i><font size=2 color="#333333" face=Arial><span
style='font-size:10.0pt;mso-bidi-font-size:12.0pt;font-family:Arial;color:#333333;
font-style:italic'>Every great achievement was once impossible. -- <b><span
style='font-weight:bold'>Anonymous</span></b><br>
I'd like to get started on time, if we can, inasmuch as we're late already. -- <b><span
style='font-weight:bold'>Larry Gelbart</span></b></span></font></i><b><i><font
color="#333333"><span style='mso-bidi-font-family:Arial;color:#333333;
font-weight:bold;font-style:italic'><o:p></o:p></span></font></i></b></p>
<p class=MsoNormal><i><font size=3 color="#333333" face="Times New Roman"><span
style='font-size:12.0pt;mso-bidi-font-family:Arial;color:#333333;font-style:
italic'>Nothing is accomplished without passion. -- <b><span style='font-weight:
bold'>My Fortune Cookie</span></b></span></font></i><b><i><font size=2
color="#333333" face=Arial><span style='font-size:10.0pt;mso-bidi-font-size:
12.0pt;font-family:Arial;color:#333333;font-weight:bold;font-style:italic'><o:p></o:p></span></font></i></b></p>
<p class=MsoNormal><!--[if supportFields]><font color=black><span
style='color:black'><span style='mso-element:field-end'></span></span></font><![endif]--><font
color=black><span style='color:black'><![if !supportEmptyParas]> <![endif]></span></font><font
color=black><span style='color:black;mso-color-alt:windowtext'><o:p></o:p></span></font></p>
</div>
</body>
</html>