1
#!/usr/bonsaitools/bin/perl -wT
2
# -*- Mode: perl; indent-tabs-mode: nil -*-
4
# The contents of this file are subject to the Mozilla Public
5
# License Version 1.1 (the "License"); you may not use this file
6
# except in compliance with the License. You may obtain a copy of
7
# the License at http://www.mozilla.org/MPL/
9
# Software distributed under the License is distributed on an "AS
10
# IS" basis, WITHOUT WARRANTY OF ANY KIND, either express or
11
# implied. See the License for the specific language governing
12
# rights and limitations under the License.
14
# The Original Code is the Bugzilla Bug Tracking System.
16
# The Initial Developer of the Original Code is Netscape Communications
17
# Corporation. Portions created by Netscape are
18
# Copyright (C) 1998 Netscape Communications Corporation. All
21
# Contributor(s): Brian Bober <boberb@rpi.edu>
22
# Terry Weissman <terry@mozilla.org>
23
# Tara Hernandez <tara@tequilarista.org>
35
quietly_check_login();
39
print "Content-type: text/html\n\n";
41
my $product = $::FORM{'product'};
43
PutHeader("Bugzilla Query Page Help","Help", "This page is to help you learn how to use the query form.");
53
<form action="none"> <!-- Cause NS4.x is stupid. Die NS4.x you eeeevil eeeevil program! -->
57
<p><center><b><font size="+2">Help Using The Bugzilla Query Form</font></b><br>January, 20 2001 -
58
<a href="mailto:netdemonz\@yahoo.com">Brian Bober (netdemon)</a>.
59
<BR><I>Further heavy mutiliations by <a href="mailto:tara\@tequilarista.org">Tara Heranandez</A>, April 20, 2001.</I></CENTER>
61
<br><center><img width="329" height="220" src="ant.jpg" border="2" alt="Da Ant"></center>
63
<p><br><center><h3>The Sections</h3></center>
65
<p>The query page is broken down into the following sections:
67
<p><a href="#bugsettings">Bug Settings</a>
68
<br><a href="#peopleinvolved">People Involved</a>
69
<br><a href="#textsearch">Text Search Options</a>
70
<br><a href="#moduleoptions">Module Options</a>
71
<br><a href="#advancedquerying">Advanced Querying</a>
72
<br><a href="#therest">The Bottom Of The Form</a>
74
<p>"I already know how to use <a href="http://www.mozilla.org/bugs/">Bugzilla</a>, but would like <a href="#info">information</a> about Bugzilla and the author of this document."
75
<br>"Ok, I am almost certain the bug I discovered isn't in Bugzilla, how do I <a href="enter_bug.cgi">submit</a> the bug?" - <a href= "docs/html/Bugzilla-Guide.html#BUG_WRITING">Read the guidelines first</a>!
77
<p><br><center><h3>Tips</h3></center>
78
You don't have to fill out any field on the query page you don't need. Filling out fields will limit
79
your search. On the list boxes, such as Status, you can Ctrl-Click to unselect an option.
80
Until you get better, you can use the "brute force" method where you enter a very simple query and search through
81
the long list of bugs manually. Just try not to overuse this method if you don't have to as you might be slowing down
82
the search for other people if there are many people searching at the same time. Finally, I would recommend learning the Boolean Chart immediately because it is extremely
83
powerful. Also, there is a navigation bar at the <a href="#bottom">bottom</a> of
84
most Bugzilla pages, and important links at the <a href="index.cgi">front page</a>.
88
<p>Back to the <a href="query.cgi">Query</a>. If you typed anything in the forms already, you might want to hit back on the
89
browser. When you are all done reading, do a <a href="#samplequery">sample query</a>!
99
<a name="bugsettings"></a>
101
<p><br><center><h3>Bug Settings</h3></center>
105
<table width="700" bgcolor="#00afff" border="0" cellpadding="0" cellspacing="0">
107
<td align="center" height="200">
108
<table cellspacing="0">
110
<th align="left"><A HREF="queryhelp.cgi#status">Status</a>:</th>
111
<th align="left"><A HREF="queryhelp.cgi#resolution">Resolution</a>:</th>
112
<th align="left"><A HREF="queryhelp.cgi#platform">Platform</a>:</th>
113
<th align="left"><A HREF="queryhelp.cgi#opsys">OpSys</a>:</th>
114
<th align="left"><A HREF="queryhelp.cgi#priority">Priority</a>:</th>
115
<th align="left"><A HREF="queryhelp.cgi#severity">Severity</a>:</th>
118
<td align="left" valign="top">
120
<SELECT NAME="bug_status" MULTIPLE SIZE="7">
121
<OPTION VALUE="UNCONFIRMED">UNCONFIRMED
122
<OPTION VALUE="NEW">NEW
123
<OPTION VALUE="ASSIGNED">ASSIGNED
124
<OPTION VALUE="REOPENED">REOPENED
125
<OPTION VALUE="RESOLVED">RESOLVED
126
<OPTION VALUE="VERIFIED">VERIFIED
127
<OPTION VALUE="CLOSED">CLOSED
131
<td align="left" valign="top">
132
<SELECT NAME="resolution" MULTIPLE SIZE="7">
133
<OPTION VALUE="FIXED">FIXED
134
<OPTION VALUE="INVALID">INVALID
135
<OPTION VALUE="WONTFIX">WONTFIX
136
<OPTION VALUE="LATER">LATER
137
<OPTION VALUE="REMIND">REMIND
138
<OPTION VALUE="DUPLICATE">DUPLICATE
139
<OPTION VALUE="WORKSFORME">WORKSFORME
140
<OPTION VALUE="MOVED">MOVED
141
<OPTION VALUE="---">---
145
<td align="left" valign="top">
146
<SELECT NAME="rep_platform" MULTIPLE SIZE="7">
147
<OPTION VALUE="All">All
148
<OPTION VALUE="DEC">DEC
149
<OPTION VALUE="HP">HP
150
<OPTION VALUE="Macintosh">Macintosh
151
<OPTION VALUE="PC">PC
152
<OPTION VALUE="SGI">SGI
153
<OPTION VALUE="Sun">Sun
154
<OPTION VALUE="Other">Other
158
<td align="left" valign="top">
159
<SELECT NAME="op_sys" MULTIPLE SIZE="7">
160
<OPTION VALUE="All">All
161
<OPTION VALUE="Windows 3.1">Windows 3.1
162
<OPTION VALUE="Windows 95">Windows 95
163
<OPTION VALUE="Windows 98">Windows 98
164
<OPTION VALUE="Windows ME">Windows ME
165
<OPTION VALUE="Windows 2000">Windows 2000
166
<OPTION VALUE="Windows NT">Windows NT
167
<OPTION VALUE="Windows XP">Windows XP
168
<OPTION VALUE="Mac System 7">Mac System 7
169
<OPTION VALUE="Mac System 7.5">Mac System 7.5
170
<OPTION VALUE="Mac System 7.6.1">Mac System 7.6.1
171
<OPTION VALUE="Mac System 8.0">Mac System 8.0
172
<OPTION VALUE="Mac System 8.5">Mac System 8.5
173
<OPTION VALUE="Mac System 8.6">Mac System 8.6
174
<OPTION VALUE="Mac System 9.0">Mac System 9.0
175
<OPTION VALUE="Linux">Linux
176
<OPTION VALUE="BSDI">BSDI
177
<OPTION VALUE="FreeBSD">FreeBSD
178
<OPTION VALUE="NetBSD">NetBSD
179
<OPTION VALUE="OpenBSD">OpenBSD
180
<OPTION VALUE="AIX">AIX
181
<OPTION VALUE="BeOS">BeOS
182
<OPTION VALUE="HP-UX">HP-UX
183
<OPTION VALUE="IRIX">IRIX
184
<OPTION VALUE="Neutrino">Neutrino
185
<OPTION VALUE="OpenVMS">OpenVMS
186
<OPTION VALUE="OS/2">OS/2
187
<OPTION VALUE="OSF/1">OSF/1
188
<OPTION VALUE="Solaris">Solaris
189
<OPTION VALUE="SunOS">SunOS
190
<OPTION VALUE="other">other
194
<td align="left" valign="top">
195
<SELECT NAME="priority" MULTIPLE SIZE="7">
196
<OPTION VALUE="P1">P1
197
<OPTION VALUE="P2">P2
198
<OPTION VALUE="P3">P3
199
<OPTION VALUE="P4">P4
200
<OPTION VALUE="P5">P5
204
<td align="left" valign="top">
205
<SELECT NAME="bug_severity" MULTIPLE SIZE="7">
206
<OPTION VALUE="blocker">blocker
207
<OPTION VALUE="critical">critical
208
<OPTION VALUE="major">major
209
<OPTION VALUE="normal">normal
210
<OPTION VALUE="minor">minor
211
<OPTION VALUE="trivial">trivial
212
<OPTION VALUE="enhancement">enhancement
224
The <b>status</b> and <b>resolution</b> field define and track the
225
life cycle of a bug. <b>Platform</b> and <b>opsys</b> describe the system
226
which the bug is on. <b>Priority</b> and <b>Severity</b> are for tracking purposes.
228
<a name="status"></a>
232
<li><b>UNCONFIRMED</b> - Nobody has validated that this bug needs to be fixed. Users who have the correct
233
permissions may confirm this bug, changing its state to NEW. You can view
234
<a href="userprefs.cgi?bank=permissions">your permissions</a> here.
235
A bug may be directly resolved and marked RESOLVED but usually a bug will
236
be confirmed by the person to whom it is assigned. Usually, an UNCOMFIRMED bug
237
will be left uncomfirmed until someone has verified that the bug the reporter
238
submitted actually occurrs.
240
<li><b>NEW</b> - This bug has recently been added to the assignee's list of bugs
241
and must be processed. Bugs in this state may be accepted, and
242
become ASSIGNED, passed on to someone else, and remain
243
NEW, or resolved and marked RESOLVED.
245
<li><b>ASSIGNED</b> - This bug is not yet resolved, but is assigned to someone who
246
thinks they can fix it. From here bugs can be given to another person and become
247
NEW, or resolved and become RESOLVED.
249
<li><b>REOPENED</b> - The bug was once resolved, but the resolution was deemed
250
incorrect. For example, a WORKSFORME bug is
251
REOPENED when more information shows up and the bug is now
252
reproducible. From here bugs are either marked ASSIGNED
255
<li><b>RESOLVED</b> - A resolution has been made, and it is awaiting verification by
256
the QA. From here bugs are either re-opened and become REOPENED, are marked
257
VERIFIED, or are closed for good and marked CLOSED.
259
<li><b>VERIFIED</b>- QA has looked at the bug and the resolution and agrees that the
260
appropriate action has been taken.
262
<li><b>CLOSED</b> - The bug is considered dead, the resolution is correct, and the product the bug
263
has been reported against is terminated or shipped. Any zombie
264
bugs who choose to walk the earth again must do so by becoming
265
REOPENED. This state is rarely ever used.
268
<a name="resolution"></a>
271
<p>The <b>resolution</b> field indicates what happened to this bug.
273
<p>No resolution yet: All bugs which are in one of the "open" states (meaning the state
274
has no associated resolution)
275
have the resolution set to blank. All other bugs
276
will be marked with one of the following resolutions.
279
<li><b>FIXED</b> - A fix for this bug is checked into the tree and tested.
280
<li><b>INVALID</b> - The problem described is not a bug.
281
<li><b>WONTFIX</b> - The problem described is a bug which will never be fixed.
282
<li><b>LATER</b> - The problem described is a bug which will not be fixed in this
283
version of the product.
284
<li><b>REMIND</b> - The problem described is a bug which will probably not be fixed in this
285
version of the product, but might still be.
286
<li><b>DUPLICATE</b> - The problem is a duplicate of an existing bug. Marking a bug
287
duplicate requires the bug number of the duplicate and that number will be placed in the
289
<li><b>WORKSFORME</b> - All attempts at reproducing this bug were futile, reading the
290
code produces no clues as to why this behavior would occur. If
291
more information appears later, please re-assign the bug, for
295
<a name="platform"></a>
297
<p>The <b>platform</b> field is the hardware platform against which the bug was reported. Legal
298
platforms include but are not limited to:
301
<li>All (happens on all platform; cross-platform bug)<br>
307
<p><b>Note:</b> Selecting the option "All" does not select bugs assigned against all platforms. It
308
merely selects bugs that <b>occur</b> on all platforms.
311
<p><b>Operating System</b>
312
<p>The <b>operating system</b> field is the operating system against which the bug was reported. Legal
313
operating systems include but are not limited to:
316
<li>All (happens on all operating systems; cross-platform bug)
321
<li>Other (Not in any of these OSes)<br>
324
<p>Note that the operating system implies the platform, but not always.
325
For example, Linux can run on PC and Macintosh and others.
327
<a name="priority"></a>
330
<p>The <b>priority</b> field describes the importance and order in which a bug should be
331
fixed. This field is utilized by the programmers/engineers to
332
prioritize their work. The priorities are from P1 (Most important) to P5
335
<a name="severity"></a>
338
<p>The <b>Severity</b> field describes the impact of a bug.
341
<li><b>Blocker</b> - Blocks development and/or testing work.<br>
342
<li><b>Critical</b> - Crashes, loss of data, severe memory leak.<br>
343
<li><b>Major</b> - Major loss of function.<br>
344
<li><b>Normal</b> - This is the run of the mill bug.<br>
345
<li><b>Minor</b> - Minor loss of function, or other problem where an easy workaround is present.<br>
346
<li><b>Trivial</b> - Cosmetic problem like misspelled words or misaligned text.<br>
347
<li><b>Enhancement</b> - Request for enhancement.<br>
364
<a name="peopleinvolved"></a>
365
<p><br><center><h3>People Involved</h3></center>
369
<table width="390" bgcolor="#00afff" border="0" cellpadding="0" cellspacing="0">
371
<td height="180" align="center">
375
<td valign="middle">Email:
376
<input name="email1" size="25" value=""> </td><td valign="top">matching as:<br>
377
<SELECT NAME="emailtype1"><OPTION VALUE="regexp">regexp
378
<OPTION VALUE="notregexp">not regexp
379
<OPTION VALUE="substring">substring
380
<OPTION VALUE="exact">exact
385
<td colspan="2" align="center">Will match any of the following selected fields:</td>
390
<input type="checkbox" name="emailassigned_to1" value="1">Assigned To
391
<input type="checkbox" name="emailreporter1" value="1">Reporter
393
<input type="checkbox" name="emailqa_contact1" value="1">QA Contact
398
<td colspan=2 align="center">
399
<input type="checkbox" name="emailcc1" value="1">CC
400
<input type="checkbox" name="emaillongdesc1" value="1">Added comment
411
This section has been made more complicated in order to make it more powerful. Unfortunately,
412
it is not the easiest to understand. What this section lets you do is search for bugs associated
413
with a certain email address.
417
To search for bugs associated with an email address:
420
<li> Type a portion of an email address into the text field.
421
<li> Click the checkbox for the fields of the bug you expect the address will be within.
426
You can look for up to two different email addresses. If you specify
427
both, then only bugs which match both emails will show up. This is useful to
428
find bugs that were, for example, created by Ralph and assigned to
433
You can also use the drop down menus to specify whether you want to
434
match addresses by doing a substring match, by using <a href="http://www.mozilla.org/bugs/text-searching.html">Regular
435
Expressions</a>, or by exactly matching a fully specified email address.
451
<a name="textsearch"></a>
452
<p><br><center><h3>Text Search</h3></center>
457
<table width="610" bgcolor="#00afff" border="0" cellpadding="0" cellspacing="0">
459
<td align="center" height="210" >
463
<td align="right"><a href="queryhelp.cgi#summaries">Bug summary</a>:</td>
464
<td><input name="short_desc" size="30" value=""></td>
465
<td><SELECT NAME="short_desc_type">
466
<OPTION VALUE="substring">case-insensitive substring
467
<OPTION VALUE="casesubstring">case-sensitive substring
468
<OPTION VALUE="allwords">all words
469
<OPTION VALUE="anywords">any words
470
<OPTION VALUE="regexp">regular expression
471
<OPTION VALUE="notregexp">not ( regular expression )
475
<td align="right"><a href="queryhelp.cgi#descriptions">A description entry</a>:</td>
476
<td><input name="long_desc" size="30" value=""></td>
477
<td><SELECT NAME="long_desc_type">
478
<OPTION VALUE="substring">case-insensitive substring
479
<OPTION VALUE="casesubstring">case-sensitive substring
480
<OPTION VALUE="allwords">all words
481
<OPTION VALUE="anywords">any words
482
<OPTION VALUE="regexp">regular expression
483
<OPTION VALUE="notregexp">not ( regular expression )
487
<td align="right"><a href="queryhelp.cgi#url">Associated URL</a>:</td>
488
<td><input name="bug_file_loc" size="30" value=""></td>
489
<td><SELECT NAME="bug_file_loc_type">
490
<OPTION VALUE="substring">case-insensitive substring
491
<OPTION VALUE="casesubstring">case-sensitive substring
492
<OPTION VALUE="allwords">all words
493
<OPTION VALUE="anywords">any words
494
<OPTION VALUE="regexp">regular expression
495
<OPTION VALUE="notregexp">not ( regular expression )
499
<td align="right"><a href="queryhelp.cgi#statuswhiteboard">Status whiteboard</a>:</td>
500
<td><input name="status_whiteboard" size="30" value=""></td>
501
<td><SELECT NAME="status_whiteboard_type">
502
<OPTION VALUE="substring">case-insensitive substring
503
<OPTION VALUE="casesubstring">case-sensitive substring
504
<OPTION VALUE="allwords">all words
505
<OPTION VALUE="anywords">any words
506
<OPTION VALUE="regexp">regular expression
507
<OPTION VALUE="notregexp">not ( regular expression )
512
<TD ALIGN="right"><A HREF="queryhelp.cgi#keywords">Keywords</A>:</TD>
513
<TD><INPUT NAME="keywords" SIZE="30" VALUE=""></TD>
515
<SELECT NAME="keywords_type"><OPTION VALUE="anywords">Any of the listed keywords set
516
<OPTION VALUE="allwords">All of the listed keywords set
517
<OPTION VALUE="nowords">None of the listed keywords set
526
<p>In this section, you can enter values that are searched for in all the bugs (or whatever you
527
limit the bugs to in other fields).
528
You might want to look at <a href="http://www.mozilla.org/bugs/text-searching.html">Bugzilla Text Searching</a>
529
to see info on <a href="http://www.mozilla.org/bugs/text-searching.html">Regular Expressions</a> and text searching. The box next to these fields decides
530
how a match will be determined.<br>
532
<a name="summaries"></a>
534
<p>This lets you search the summaries. The summary is one line that attempts to sum up the bug.
536
<a name="descriptions"></a>
537
<h4>A description entry</h4>
538
<p>This lets you search comments. Comments can be added by anybody. Comments are the largest
539
searchable area in most bugs. If you really want to find a lot of matches, search the comments.
540
<BR><B>Note:</B>Because comments can get quite extensive in bugs, doing this particular type
541
of query can take a long time.
544
<h4>Associated URL</h4>
545
<p>This lets you search the url field. This contains the url of the web page the bug is
548
<a name="statuswhiteboard"></a>
549
<h4>Status Whiteboard</h4>
550
<p>This lets you search the bug's status whiteboard. The status whiteboard contains general
551
information that engineers add.
556
<a name="keywords"></a>
558
<br><br>Each bug can have keywords specified. The bug reporter or a
559
user with the proper permissions can edit these keywords. The following is a list of the keywords that are
560
stored on this version of Bugzilla:
563
my $tableheader = qq{
564
<p><table border="1" cellpadding="4" cellspacing="0">
565
<tr bgcolor="#6666FF">
566
<th align="left">Name</th>
567
<th align="left">Description</th>
568
<th align="left">Bugs</th>
575
my $max_table_size = 50;
577
SendSQL("SELECT keyworddefs.name, keyworddefs.description,
578
COUNT(keywords.bug_id), keywords.bug_id
579
FROM keyworddefs LEFT JOIN keywords ON keyworddefs.id=keywords.keywordid
580
GROUP BY keyworddefs.id
581
ORDER BY keyworddefs.name");
583
while (MoreSQLData()) {
584
my ($name, $description, $bugs, $onebug) = FetchSQLData();
585
if ($bugs && $onebug) {
586
# This 'onebug' stuff is silly hackery for old versions of
587
# MySQL that seem to return a count() of 1 even if there are
588
# no matching. So, we ask for an actual bug number. If it
589
# can't find any bugs that match the keyword, then we set the
590
# count to be zero, ignoring what it had responded.
591
my $q = url_quote($name);
592
$bugs = qq{<A HREF="buglist.cgi?keywords=$q">$bugs</A>};
596
if ($line_count == $max_table_size) {
597
print "</table>\n$tableheader";
604
<td>$description</td>
605
<td align="right">$bugs</td>
610
print "</table><p>\n";
613
if (UserInGroup("editkeywords")) {
614
print qq{<p><a href="editkeywords.cgi">Edit keywords</a>\n};
632
<a name="moduleoptions"></a>
633
<p><br><center><h3>Module Options</h3></center>
637
<p>Module options are where you select what product, module and version the bugs you want to
638
find describe. Selecting one or more of the products, versions, components, or milestones will limit your search.
640
<p><a name="product"></a>
644
<p>Although all subprojects within the Mozilla project are similar, there are several seperate
645
products being developed. Each product has its own components.
653
$max_table_size = 50;
656
$tableheader = qq{ <p><table border=0><tr><td>
657
<table border="1" width="100%" cellpadding="4" cellspacing="0">
658
<tr bgcolor="#6666FF">
659
<th align="left">Product</th>
660
<th align="left">Description</th></tr> };
668
SendSQL("SELECT product,description FROM products ORDER BY product");
669
while (MoreSQLData()) {
671
my ($product, $productdesc) = FetchSQLData();
672
next if (Param("usebuggroups") && GroupExists($product) && !UserInGroup($product));
673
push (@products, $product);
676
if ($line_count > $max_table_size) {
684
print qq{ <tr><th>$product</th><td>$productdesc</td></tr> };
692
</table></td></tr></table> };
694
if (UserInGroup("editcomponents")) {
695
print qq{<p><a href="editproducts.cgi">Edit products</a><p>};
699
<p><a name="version"></a>
702
<p>This is simply the version that the bugs you want to find are marked for.
703
Many of the bugs will be marked for another version and will have their milestones
704
entered instead (milestones explained below).
715
<table border="1" width="100%" cellpadding="4" cellspacing="0">
716
<tr bgcolor="#6666FF">
717
<th align="left">Component</th>
718
<th align="left">Product</th>
719
<th align="left">Description</th></tr>
723
<p><a name="component"></a>
725
<p>Each product has components, against which bugs can be filed. Components are parts of
726
the product, and are assigned to a module owner. The following lists
727
components and their associated products:
730
foreach $product (@products)
733
SendSQL("SELECT value,description FROM components WHERE program=" . SqlQuote($product) . " ORDER BY value");
735
while (MoreSQLData()) {
737
my ($component, $compdesc) = FetchSQLData();
740
if ($line_count > $max_table_size) {
747
print qq{<tr><th>$component</th><td>$product</td><td>$compdesc</td></tr>};
753
if (UserInGroup("editcomponents")) {
754
print qq{<p><a href="editcomponents.cgi">Edit components</a><p>};
758
<p><a name="targetmilestone"></a>
761
<p>Choosing this section lets you search through bugs that have their target milestones set to certain
762
values. Milestones are kind of like versions. They are specific tentative dates where a massive
763
phasing out of bugs occur and a relatively stable release is produced. For example, Mozilla.org had milestones in the
764
form of "M10" or "M18", but now are in the form of "Mozilla0.9". Bugzilla milestones are in the form of "Bugzilla 2.12",
765
"Bugzilla 2.14", etc.
784
<a name="incexcoptions"></a>
785
<p><br><center><h3>Inclusion/Exclusion Options</h3></center>
790
<table width="480" bgcolor="#00afff" border="0" cellpadding="0" cellspacing="0">
792
<td align="center" height="260" >
797
<SELECT NAME="bugidtype">
798
<OPTION VALUE="include">Only
799
<OPTION VALUE="exclude" >Exclude
802
<INPUT TYPE="text" NAME="bug_id" VALUE="" SIZE=15>
807
Changed in the last <INPUT NAME=changedin SIZE=3 VALUE=""> days
812
Containing at least <INPUT NAME=votes SIZE=3 VALUE=""> votes
818
<SELECT NAME="chfield" MULTIPLE SIZE=4>
819
<OPTION VALUE="[Bug creation]">[Bug creation]<OPTION VALUE="assigned_to">assigned_to<OPTION VALUE="bug_file_loc">bug_file_loc<OPTION VALUE="bug_severity">bug_severity<OPTION VALUE="bug_status">bug_status<OPTION VALUE="component">component<OPTION VALUE="everconfirmed">everconfirmed<OPTION VALUE="groupset">groupset<OPTION VALUE="keywords">keywords<OPTION VALUE="op_sys">op_sys<OPTION VALUE="priority">priority<OPTION VALUE="product">product<OPTION VALUE="qa_contact">qa_contact<OPTION VALUE="rep_platform">rep_platform<OPTION VALUE="reporter">reporter<OPTION VALUE="resolution">resolution<OPTION VALUE="short_desc">short_desc<OPTION VALUE="status_whiteboard">status_whiteboard<OPTION VALUE="target_milestone">target_milestone<OPTION VALUE="version">version<OPTION VALUE="votes">votes
820
</SELECT> changed to <INPUT NAME="chfieldvalue" SIZE="10">
825
During dates <INPUT NAME="chfieldfrom" SIZE="10" VALUE="">
826
to <INPUT NAME="chfieldto" SIZE="10" VALUE="Now">
843
<p>Inclusion/Exclusion options is a powerful section that gives you the ability to include and
844
exclude bugs based on values you enter.
846
<P><b>[Only, Exclude] bugs numbered [text] </b>
848
<p>This lets you put in a comma-delimited list of bugs you want to have your results chosen from, or those
849
of which you want to exclude. It would be nice in the future if you could type in ranges, i.e. [1-1000] for 1
850
to 1000. Unfortunately, you cannot do that as of now.
852
<p><b>Changed in the last [text] days</b>
854
<p>Lets you specify how many days ago - at maximum - a bug could have changed state.
856
<p><b>At least [text] votes</b>
858
<p>With this, you can choose how many votes - at minimum - a bug has.
860
<p><b>Where the field(s) [fields] changed to [text]</b>
862
<p>With this, you can specify values to search for in fields that exist in the bug If you choose
863
one or more fields, you have to fill out one of the fields to the right. It might
864
be difficult to figure out what these fields mean if you are a newbie to the query.
865
They match various fields within the bug information. Optionally, you can
866
also enter what value you want the field to have changed to if you only entered one field.
867
For instance, if the bug changed who it was assigned to from jon\@netscape.com
868
to brian\@netscape.com , you could enter in
869
assigned_to changed to brian\@netscape.com.
871
<p><b>During dates [text] to [text] </b>
873
<p>Here, you can choose what dates the fields changed. "Now" can be used as an entry. Other entries should be in
874
mm/dd/yyyy or yyyy-mm-dd format.
891
<a name="advancedquerying"></a>
892
<p><br><center><h3>Advanced Querying Using "Boolean Charts"</h3></center>
894
<p>The Bugzilla query page is designed to be reasonably easy to use.
895
But, with such ease of use always comes some lack of power. The
896
Advanced Querying section is designed to let you do very powerful
897
queries, but it's not the easiest thing to learn (or explain).
902
<table width="780" bgcolor="#00afff" border="0" cellpadding="0" cellspacing="0">
904
<td align="center" height="140" >
907
<table><tr><td> </td><td><SELECT NAME="field0-0-0"><OPTION SELECTED VALUE="noop">---
908
<OPTION VALUE="groupset">groupset
909
<OPTION VALUE="bug_id">Bug #
910
<OPTION VALUE="short_desc">Summary
911
<OPTION VALUE="product">Product
912
<OPTION VALUE="version">Version
913
<OPTION VALUE="rep_platform">Platform
914
<OPTION VALUE="bug_file_loc">URL
915
<OPTION VALUE="op_sys">OS/Version
916
<OPTION VALUE="bug_status">Status
917
<OPTION VALUE="status_whiteboard">Status Whiteboard
918
<OPTION VALUE="keywords">Keywords
919
<OPTION VALUE="resolution">Resolution
920
<OPTION VALUE="bug_severity">Severity
921
<OPTION VALUE="priority">Priority
922
<OPTION VALUE="component">Component
923
<OPTION VALUE="assigned_to">AssignedTo
924
<OPTION VALUE="reporter">ReportedBy
925
<OPTION VALUE="votes">Votes
926
<OPTION VALUE="qa_contact">QAContact
927
<OPTION VALUE="cc">CC
928
<OPTION VALUE="dependson">BugsThisDependsOn
929
<OPTION VALUE="blocked">OtherBugsDependingOnThis
930
<OPTION VALUE="attachments.description">Attachment description
931
<OPTION VALUE="attachments.thedata">Attachment data
932
<OPTION VALUE="attachments.mimetype">Attachment mime type
933
<OPTION VALUE="attachments.ispatch">Attachment is patch
934
<OPTION VALUE="target_milestone">Target Milestone
935
<OPTION VALUE="delta_ts">Last changed date
936
<OPTION VALUE="(to_days(now()) - to_days(bugs.delta_ts))">Days since bug changed
937
<OPTION VALUE="longdesc">Comment
938
</SELECT><SELECT NAME="type0-0-0"><OPTION SELECTED VALUE="noop">---
939
<OPTION VALUE="equals">equal to
940
<OPTION VALUE="notequals">not equal to
941
<OPTION VALUE="casesubstring">contains (case-sensitive) substring
942
<OPTION VALUE="substring">contains (case-insensitive) substring
943
<OPTION VALUE="notsubstring">does not contain (case-insensitive) substring
944
<OPTION VALUE="regexp">contains regexp
945
<OPTION VALUE="notregexp">does not contain regexp
946
<OPTION VALUE="lessthan">less than
947
<OPTION VALUE="greaterthan">greater than
948
<OPTION VALUE="anywords">any words
949
<OPTION VALUE="allwords">all words
950
<OPTION VALUE="nowords">none of the words
951
<OPTION VALUE="changedbefore">changed before
952
<OPTION VALUE="changedafter">changed after
953
<OPTION VALUE="changedto">changed to
954
<OPTION VALUE="changedby">changed by
955
</SELECT><INPUT NAME="value0-0-0" VALUE=""><INPUT TYPE="button" VALUE="Or" ><INPUT TYPE="button" VALUE="And"
956
NAME="cmd-add0-1-0"></td></tr>
958
<tr><td> </td><td align="center">
959
960
<INPUT TYPE="button" VALUE="Add another boolean chart" NAME="cmd-add1-0-0">
973
<p>The Advanced Query (or Boolean Chart) starts with a single "term". A term is a
974
combination of two pulldown menus and a text field.
975
You choose items from the menus, specifying:
976
<p>Field 1: Where to look for the search term<br>
977
Field 2: How to determine what is a match<br>
978
Field 3: What the search term is<br>
982
<table width="790" bgcolor="#00afff" border="0" cellpadding="0" cellspacing="0">
984
<td align="center" height="160" >
987
<table><tr><td> </td><td><SELECT NAME="field0-0-0"><OPTION SELECTED VALUE="noop">---
988
<OPTION VALUE="groupset">groupset
989
<OPTION VALUE="bug_id">Bug #
990
<OPTION VALUE="short_desc">Summary
991
<OPTION VALUE="product">Product
992
<OPTION VALUE="version">Version
993
<OPTION VALUE="rep_platform">Platform
994
<OPTION VALUE="bug_file_loc">URL
995
<OPTION VALUE="op_sys">OS/Version
996
<OPTION VALUE="bug_status">Status
997
<OPTION VALUE="status_whiteboard">Status Whiteboard
998
<OPTION VALUE="keywords">Keywords
999
<OPTION VALUE="resolution">Resolution
1000
<OPTION VALUE="bug_severity">Severity
1001
<OPTION VALUE="priority">Priority
1002
<OPTION VALUE="component">Component
1003
<OPTION VALUE="assigned_to">AssignedTo
1004
<OPTION VALUE="reporter">ReportedBy
1005
<OPTION VALUE="votes">Votes
1006
<OPTION VALUE="qa_contact">QAContact
1007
<OPTION VALUE="cc">CC
1008
<OPTION VALUE="dependson">BugsThisDependsOn
1009
<OPTION VALUE="blocked">OtherBugsDependingOnThis
1010
<OPTION VALUE="attachments.description">Attachment description
1011
<OPTION VALUE="attachments.thedata">Attachment data
1012
<OPTION VALUE="attachments.mimetype">Attachment mime type
1013
<OPTION VALUE="attachments.ispatch">Attachment is patch
1014
<OPTION VALUE="target_milestone">Target Milestone
1015
<OPTION VALUE="delta_ts">Last changed date
1016
<OPTION VALUE="(to_days(now()) - to_days(bugs.delta_ts))">Days since bug changed
1017
<OPTION VALUE="longdesc">Comment
1018
</SELECT><SELECT NAME="type0-0-0"><OPTION SELECTED VALUE="noop">---
1019
<OPTION VALUE="equals">equal to
1020
<OPTION VALUE="notequals">not equal to
1021
<OPTION VALUE="casesubstring">contains (case-sensitive) substring
1022
<OPTION VALUE="substring">contains (case-insensitive) substring
1023
<OPTION VALUE="notsubstring">does not contain (case-insensitive) substring
1024
<OPTION VALUE="regexp">contains regexp
1025
<OPTION VALUE="notregexp">does not contain regexp
1026
<OPTION VALUE="lessthan">less than
1027
<OPTION VALUE="greaterthan">greater than
1028
<OPTION VALUE="anywords">any words
1029
<OPTION VALUE="allwords">all words
1030
<OPTION VALUE="nowords">none of the words
1031
<OPTION VALUE="changedbefore">changed before
1032
<OPTION VALUE="changedafter">changed after
1033
<OPTION VALUE="changedto">changed to
1034
<OPTION VALUE="changedby">changed by
1035
</SELECT><INPUT NAME="value0-0-0" VALUE=""></td></tr><tr><td><b>OR</b></td><td><SELECT NAME="field0-0-1"><OPTION SELECTED VALUE="noop">---
1036
<OPTION VALUE="groupset">groupset
1037
<OPTION VALUE="bug_id">Bug #
1038
<OPTION VALUE="short_desc">Summary
1039
<OPTION VALUE="product">Product
1040
<OPTION VALUE="version">Version
1041
<OPTION VALUE="rep_platform">Platform
1042
<OPTION VALUE="bug_file_loc">URL
1043
<OPTION VALUE="op_sys">OS/Version
1044
<OPTION VALUE="bug_status">Status
1045
<OPTION VALUE="status_whiteboard">Status Whiteboard
1046
<OPTION VALUE="keywords">Keywords
1047
<OPTION VALUE="resolution">Resolution
1048
<OPTION VALUE="bug_severity">Severity
1049
<OPTION VALUE="priority">Priority
1050
<OPTION VALUE="component">Component
1051
<OPTION VALUE="assigned_to">AssignedTo
1052
<OPTION VALUE="reporter">ReportedBy
1053
<OPTION VALUE="votes">Votes
1054
<OPTION VALUE="qa_contact">QAContact
1055
<OPTION VALUE="cc">CC
1056
<OPTION VALUE="dependson">BugsThisDependsOn
1057
<OPTION VALUE="blocked">OtherBugsDependingOnThis
1058
<OPTION VALUE="attachments.description">Attachment description
1059
<OPTION VALUE="attachments.thedata">Attachment data
1060
<OPTION VALUE="attachments.mimetype">Attachment mime type
1061
<OPTION VALUE="attachments.ispatch">Attachment is patch
1062
<OPTION VALUE="target_milestone">Target Milestone
1063
<OPTION VALUE="delta_ts">Last changed date
1064
<OPTION VALUE="(to_days(now()) - to_days(bugs.delta_ts))">Days since bug changed
1065
<OPTION VALUE="longdesc">Comment
1066
</SELECT><SELECT NAME="type0-0-1"><OPTION SELECTED VALUE="noop">---
1067
<OPTION VALUE="equals">equal to
1068
<OPTION VALUE="notequals">not equal to
1069
<OPTION VALUE="casesubstring">contains (case-sensitive) substring
1070
<OPTION VALUE="substring">contains (case-insensitive) substring
1071
<OPTION VALUE="notsubstring">does not contain (case-insensitive) substring
1072
<OPTION VALUE="regexp">contains regexp
1073
<OPTION VALUE="notregexp">does not contain regexp
1074
<OPTION VALUE="lessthan">less than
1075
<OPTION VALUE="greaterthan">greater than
1076
<OPTION VALUE="anywords">any words
1077
<OPTION VALUE="allwords">all words
1078
<OPTION VALUE="nowords">none of the words
1079
<OPTION VALUE="changedbefore">changed before
1080
<OPTION VALUE="changedafter">changed after
1081
<OPTION VALUE="changedto">changed to
1082
<OPTION VALUE="changedby">changed by
1083
</SELECT><INPUT NAME="value0-0-1" VALUE=""><INPUT TYPE="button" VALUE="Or" NAME="cmd-add0-0-2" ONCLICK="document.forms[0].action='query.cgi#chart' ; document.forms[0].method='POST' ; return 1;"><INPUT TYPE="button" VALUE="And"
1084
NAME="cmd-add0-1-0" ONCLICK="document.forms[0].action='query.cgi#chart' ; document.forms[0].method='POST' ; return 1;"></td></tr>
1086
<tr><td> </td><td align="center">
1087
1088
<INPUT TYPE="button" VALUE="Add another boolean chart" NAME="cmd-add1-0-0" ONCLICK="document.forms[0].action='query.cgi#chart' ; document.forms[0].method='POST' ; return 1;">
1102
<p>The real fun starts when you click on the "Or" or "And" buttons. If
1103
you push the "Or" button, then you get a second term right under
1104
the first one. You can then configure that term, and the result of
1105
the query will be anything that matches either of the terms.
1110
<table width="790" bgcolor="#00afff" border="0" cellpadding="0" cellspacing="0">
1112
<td align="center" height="180" >
1117
<table><tr><td> </td><td><SELECT NAME="field0-0-0"><OPTION SELECTED VALUE="noop">---
1118
<OPTION VALUE="groupset">groupset
1119
<OPTION VALUE="bug_id">Bug #
1120
<OPTION VALUE="short_desc">Summary
1121
<OPTION VALUE="product">Product
1122
<OPTION VALUE="version">Version
1123
<OPTION VALUE="rep_platform">Platform
1124
<OPTION VALUE="bug_file_loc">URL
1125
<OPTION VALUE="op_sys">OS/Version
1126
<OPTION VALUE="bug_status">Status
1127
<OPTION VALUE="status_whiteboard">Status Whiteboard
1128
<OPTION VALUE="keywords">Keywords
1129
<OPTION VALUE="resolution">Resolution
1130
<OPTION VALUE="bug_severity">Severity
1131
<OPTION VALUE="priority">Priority
1132
<OPTION VALUE="component">Component
1133
<OPTION VALUE="assigned_to">AssignedTo
1134
<OPTION VALUE="reporter">ReportedBy
1135
<OPTION VALUE="votes">Votes
1136
<OPTION VALUE="qa_contact">QAContact
1137
<OPTION VALUE="cc">CC
1138
<OPTION VALUE="dependson">BugsThisDependsOn
1139
<OPTION VALUE="blocked">OtherBugsDependingOnThis
1140
<OPTION VALUE="attachments.description">Attachment description
1141
<OPTION VALUE="attachments.thedata">Attachment data
1142
<OPTION VALUE="attachments.mimetype">Attachment mime type
1143
<OPTION VALUE="attachments.ispatch">Attachment is patch
1144
<OPTION VALUE="target_milestone">Target Milestone
1145
<OPTION VALUE="delta_ts">Last changed date
1146
<OPTION VALUE="(to_days(now()) - to_days(bugs.delta_ts))">Days since bug changed
1147
<OPTION VALUE="longdesc">Comment
1148
</SELECT><SELECT NAME="type0-0-0"><OPTION SELECTED VALUE="noop">---
1149
<OPTION VALUE="equals">equal to
1150
<OPTION VALUE="notequals">not equal to
1151
<OPTION VALUE="casesubstring">contains (case-sensitive) substring
1152
<OPTION VALUE="substring">contains (case-insensitive) substring
1153
<OPTION VALUE="notsubstring">does not contain (case-insensitive) substring
1154
<OPTION VALUE="regexp">contains regexp
1155
<OPTION VALUE="notregexp">does not contain regexp
1156
<OPTION VALUE="lessthan">less than
1157
<OPTION VALUE="greaterthan">greater than
1158
<OPTION VALUE="anywords">any words
1159
<OPTION VALUE="allwords">all words
1160
<OPTION VALUE="nowords">none of the words
1161
<OPTION VALUE="changedbefore">changed before
1162
<OPTION VALUE="changedafter">changed after
1163
<OPTION VALUE="changedto">changed to
1164
<OPTION VALUE="changedby">changed by
1165
</SELECT><INPUT NAME="value0-0-0" VALUE=""><INPUT TYPE="button" VALUE="Or" NAME="cmd-add0-0-1" ONCLICK="document.forms[0].action='query.cgi#chart' ; document.forms[0].method='POST' ; return 1;"></td></tr><tr><td> </td><td align="center" valign="middle"><b>AND</b></td></tr><tr><td> </td><td><SELECT NAME="field0-1-0"><OPTION SELECTED VALUE="noop">---
1166
<OPTION VALUE="groupset">groupset
1167
<OPTION VALUE="bug_id">Bug #
1168
<OPTION VALUE="short_desc">Summary
1169
<OPTION VALUE="product">Product
1170
<OPTION VALUE="version">Version
1171
<OPTION VALUE="rep_platform">Platform
1172
<OPTION VALUE="bug_file_loc">URL
1173
<OPTION VALUE="op_sys">OS/Version
1174
<OPTION VALUE="bug_status">Status
1175
<OPTION VALUE="status_whiteboard">Status Whiteboard
1176
<OPTION VALUE="keywords">Keywords
1177
<OPTION VALUE="resolution">Resolution
1178
<OPTION VALUE="bug_severity">Severity
1179
<OPTION VALUE="priority">Priority
1180
<OPTION VALUE="component">Component
1181
<OPTION VALUE="assigned_to">AssignedTo
1182
<OPTION VALUE="reporter">ReportedBy
1183
<OPTION VALUE="votes">Votes
1184
<OPTION VALUE="qa_contact">QAContact
1185
<OPTION VALUE="cc">CC
1186
<OPTION VALUE="dependson">BugsThisDependsOn
1187
<OPTION VALUE="blocked">OtherBugsDependingOnThis
1188
<OPTION VALUE="attachments.description">Attachment description
1189
<OPTION VALUE="attachments.thedata">Attachment data
1190
<OPTION VALUE="attachments.mimetype">Attachment mime type
1191
<OPTION VALUE="attachments.ispatch">Attachment is patch
1192
<OPTION VALUE="target_milestone">Target Milestone
1193
<OPTION VALUE="delta_ts">Last changed date
1194
<OPTION VALUE="(to_days(now()) - to_days(bugs.delta_ts))">Days since bug changed
1195
<OPTION VALUE="longdesc">Comment
1196
</SELECT><SELECT NAME="type0-1-0"><OPTION SELECTED VALUE="noop">---
1197
<OPTION VALUE="equals">equal to
1198
<OPTION VALUE="notequals">not equal to
1199
<OPTION VALUE="casesubstring">contains (case-sensitive) substring
1200
<OPTION VALUE="substring">contains (case-insensitive) substring
1201
<OPTION VALUE="notsubstring">does not contain (case-insensitive) substring
1202
<OPTION VALUE="regexp">contains regexp
1203
<OPTION VALUE="notregexp">does not contain regexp
1204
<OPTION VALUE="lessthan">less than
1205
<OPTION VALUE="greaterthan">greater than
1206
<OPTION VALUE="anywords">any words
1207
<OPTION VALUE="allwords">all words
1208
<OPTION VALUE="nowords">none of the words
1209
<OPTION VALUE="changedbefore">changed before
1210
<OPTION VALUE="changedafter">changed after
1211
<OPTION VALUE="changedto">changed to
1212
<OPTION VALUE="changedby">changed by
1213
</SELECT><INPUT NAME="value0-1-0" VALUE=""><INPUT TYPE="button" VALUE="Or" NAME="cmd-add0-1-1" ONCLICK="document.forms[0].action='query.cgi#chart' ; document.forms[0].method='POST' ; return 1;"><INPUT TYPE="button" VALUE="And"
1214
NAME="cmd-add0-2-0" ONCLICK="document.forms[0].action='query.cgi#chart' ; document.forms[0].method='POST' ; return 1;"></td></tr>
1216
<tr><td> </td><td align="center">
1217
1218
<INPUT TYPE="button" VALUE="Add another boolean chart" NAME="cmd-add1-0-0" ONCLICK="document.forms[0].action='query.cgi#chart' ; document.forms[0].method='POST' ; return 1;">
1231
<p>You can push the "And" button, and get a new term below the
1232
original one - seperated by the word "AND", and now the result of
1233
the query will be anything that matches both sets of terms.
1235
<p>You can keep clicking "And" and "Or", and get a page with many
1236
terms. "Or" has higher precedence than "And". You
1237
can think of the lines of "Or" as having parenthesis around them.
1242
<table width="790" bgcolor="#00afff" border="0" cellpadding="0" cellspacing="0">
1244
<td align="center" height="170" >
1248
<table><tr><td> </td><td><SELECT NAME="field0-0-0"><OPTION SELECTED VALUE="noop">---
1249
<OPTION VALUE="groupset">groupset
1250
<OPTION VALUE="bug_id">Bug #
1251
<OPTION VALUE="short_desc">Summary
1252
<OPTION VALUE="product">Product
1253
<OPTION VALUE="version">Version
1254
<OPTION VALUE="rep_platform">Platform
1255
<OPTION VALUE="bug_file_loc">URL
1256
<OPTION VALUE="op_sys">OS/Version
1257
<OPTION VALUE="bug_status">Status
1258
<OPTION VALUE="status_whiteboard">Status Whiteboard
1259
<OPTION VALUE="keywords">Keywords
1260
<OPTION VALUE="resolution">Resolution
1261
<OPTION VALUE="bug_severity">Severity
1262
<OPTION VALUE="priority">Priority
1263
<OPTION VALUE="component">Component
1264
<OPTION VALUE="assigned_to">AssignedTo
1265
<OPTION VALUE="reporter">ReportedBy
1266
<OPTION VALUE="votes">Votes
1267
<OPTION VALUE="qa_contact">QAContact
1268
<OPTION VALUE="cc">CC
1269
<OPTION VALUE="dependson">BugsThisDependsOn
1270
<OPTION VALUE="blocked">OtherBugsDependingOnThis
1271
<OPTION VALUE="attachments.description">Attachment description
1272
<OPTION VALUE="attachments.thedata">Attachment data
1273
<OPTION VALUE="attachments.mimetype">Attachment mime type
1274
<OPTION VALUE="attachments.ispatch">Attachment is patch
1275
<OPTION VALUE="target_milestone">Target Milestone
1276
<OPTION VALUE="delta_ts">Last changed date
1277
<OPTION VALUE="(to_days(now()) - to_days(bugs.delta_ts))">Days since bug changed
1278
<OPTION VALUE="longdesc">Comment
1279
</SELECT><SELECT NAME="type0-0-0"><OPTION SELECTED VALUE="noop">---
1280
<OPTION VALUE="equals">equal to
1281
<OPTION VALUE="notequals">not equal to
1282
<OPTION VALUE="casesubstring">contains (case-sensitive) substring
1283
<OPTION VALUE="substring">contains (case-insensitive) substring
1284
<OPTION VALUE="notsubstring">does not contain (case-insensitive) substring
1285
<OPTION VALUE="regexp">contains regexp
1286
<OPTION VALUE="notregexp">does not contain regexp
1287
<OPTION VALUE="lessthan">less than
1288
<OPTION VALUE="greaterthan">greater than
1289
<OPTION VALUE="anywords">any words
1290
<OPTION VALUE="allwords">all words
1291
<OPTION VALUE="nowords">none of the words
1292
<OPTION VALUE="changedbefore">changed before
1293
<OPTION VALUE="changedafter">changed after
1294
<OPTION VALUE="changedto">changed to
1295
<OPTION VALUE="changedby">changed by
1296
</SELECT><INPUT NAME="value0-0-0" VALUE=""><INPUT TYPE="button" VALUE="Or" NAME="cmd-add0-0-1" ONCLICK="document.forms[0].action='query.cgi#chart' ; document.forms[0].method='POST' ; return 1;"><INPUT TYPE="button" VALUE="And"
1297
NAME="cmd-add0-1-0" ONCLICK="document.forms[0].action='query.cgi#chart' ; document.forms[0].method='POST' ; return 1;"></td></tr>
1300
<td colspan="2"><hr></td>
1301
</tr><tr><td> </td><td>
1302
<SELECT NAME="field1-0-0"><OPTION SELECTED VALUE="noop">---
1303
<OPTION VALUE="groupset">groupset
1304
<OPTION VALUE="bug_id">Bug #
1305
<OPTION VALUE="short_desc">Summary
1306
<OPTION VALUE="product">Product
1307
<OPTION VALUE="version">Version
1308
<OPTION VALUE="rep_platform">Platform
1309
<OPTION VALUE="bug_file_loc">URL
1310
<OPTION VALUE="op_sys">OS/Version
1311
<OPTION VALUE="bug_status">Status
1312
<OPTION VALUE="status_whiteboard">Status Whiteboard
1313
<OPTION VALUE="keywords">Keywords
1314
<OPTION VALUE="resolution">Resolution
1315
<OPTION VALUE="bug_severity">Severity
1316
<OPTION VALUE="priority">Priority
1317
<OPTION VALUE="component">Component
1318
<OPTION VALUE="assigned_to">AssignedTo
1319
<OPTION VALUE="reporter">ReportedBy
1320
<OPTION VALUE="votes">Votes
1321
<OPTION VALUE="qa_contact">QAContact
1322
<OPTION VALUE="cc">CC
1323
<OPTION VALUE="dependson">BugsThisDependsOn
1324
<OPTION VALUE="blocked">OtherBugsDependingOnThis
1325
<OPTION VALUE="attachments.description">Attachment description
1326
<OPTION VALUE="attachments.thedata">Attachment data
1327
<OPTION VALUE="attachments.mimetype">Attachment mime type
1328
<OPTION VALUE="attachments.ispatch">Attachment is patch
1329
<OPTION VALUE="target_milestone">Target Milestone
1330
<OPTION VALUE="delta_ts">Last changed date
1331
<OPTION VALUE="(to_days(now()) - to_days(bugs.delta_ts))">Days since bug changed
1332
<OPTION VALUE="longdesc">Comment
1333
</SELECT><SELECT NAME="type1-0-0"><OPTION SELECTED VALUE="noop">---
1334
<OPTION VALUE="equals">equal to
1335
<OPTION VALUE="notequals">not equal to
1336
<OPTION VALUE="casesubstring">contains (case-sensitive) substring
1337
<OPTION VALUE="substring">contains (case-insensitive) substring
1338
<OPTION VALUE="notsubstring">does not contain (case-insensitive) substring
1339
<OPTION VALUE="regexp">contains regexp
1340
<OPTION VALUE="notregexp">does not contain regexp
1341
<OPTION VALUE="lessthan">less than
1342
<OPTION VALUE="greaterthan">greater than
1343
<OPTION VALUE="anywords">any words
1344
<OPTION VALUE="allwords">all words
1345
<OPTION VALUE="nowords">none of the words
1346
<OPTION VALUE="changedbefore">changed before
1347
<OPTION VALUE="changedafter">changed after
1348
<OPTION VALUE="changedto">changed to
1349
<OPTION VALUE="changedby">changed by
1350
</SELECT><INPUT NAME="value1-0-0" VALUE=""><INPUT TYPE="button" VALUE="Or" NAME="cmd-add1-0-1" ONCLICK="document.forms[0].action='query.cgi#chart' ; document.forms[0].method='POST' ; return 1;"><INPUT TYPE="button" VALUE="And"
1351
NAME="cmd-add1-1-0" ONCLICK="document.forms[0].action='query.cgi#chart' ; document.forms[0].method='POST' ; return 1;"></td></tr>
1353
<tr><td> </td><td align="center">
1354
1355
<INPUT TYPE="button" VALUE="Add another boolean chart" NAME="cmd-add2-0-0" ONCLICK="document.forms[0].action='query.cgi#chart' ; document.forms[0].method='POST' ; return 1;">
1369
<p>The most subtle thing to notice is the "Add another boolean chart" button.
1370
This is almost the same thing as the "And" button. You want to use this when
1371
you use one of the fields where several items can be associated
1372
with a single bug - including: "Comments", "CC", and all the
1373
"changed [something]" entries. If you have multiple terms that
1374
all are about one of these fields (such as one comment), it's ambiguous whether they are
1375
allowed to be about different instances of that field or about only that one instance. So,
1376
to let you have it both ways, they always mean the same instance,
1377
unless the terms appear on different charts.
1379
<p>For example: if you search for "priority changed to P5" and
1380
"priority changed by person\@addr", it will only find bugs where the
1381
given person at some time changed the priority to P5. However, if
1382
what you really want is to find all bugs where the milestone was
1383
changed at some time by the person, and someone (possibly someone
1384
else) at some time changed the milestone to P5, then you would put
1385
the two terms in two different charts.
1390
<a name="therest"></a>
1391
<center><h3>The Rest of the Form</h3></center>
1395
<table width="650" bgcolor="#00afff" border="0" cellpadding="0" cellspacing="0">
1397
<td align="center" height="190" >
1398
<table cellspacing="0" cellpadding="0">
1401
<INPUT TYPE="radio" NAME="cmdtype" VALUE="editnamed"> Load the remembered query:
1402
<select name="namedcmd"><OPTION VALUE="Assigned to me">Assigned to me</select><br>
1403
<INPUT TYPE="radio" NAME="cmdtype" VALUE="runnamed"> Run the remembered query:<br>
1404
<INPUT TYPE="radio" NAME="cmdtype" VALUE="forgetnamed"> Forget the remembered query:<br>
1405
<INPUT TYPE="radio" NAME="cmdtype" VALUE="asdefault"> Remember this as the default query<br>
1406
<INPUT TYPE="radio" NAME="cmdtype" VALUE="asnamed"> Remember this query, and name it:
1407
<INPUT TYPE="text" NAME="newqueryname"><br>
1409
<SELECT NAME="order">
1410
<OPTION VALUE="Reuse same sort as last time">Reuse same sort as last time<OPTION VALUE="Bug Number">Bug Number<OPTION VALUE="'Importance'">'Importance'<OPTION VALUE="Assignee">Assignee</SELECT>
1417
<INPUT TYPE="button" VALUE="Reset back to the default query">
1420
<INPUT TYPE="button" VALUE="Submit query">
1432
<p>So you have gotten all that down, but "What is this junk at the bottom of the form?"
1433
You can remember the current query as the default query page that is pulled up whenever you are
1434
logged on. There is also an ability to choose how you want your results sorted. When finished,
1445
<br><center><h3>About This Document</h3></center>
1447
<p>Written and adapted from some older Bugzilla documents (by Terry Weissman, Tara Hernandez and others) by <a href="mailto:netdemonz\@yahoo.com">Brian Bober</a>
1448
You can talk to me on irc.mozilla.org - #mozilla, #mozwebtools, #mozillazine, I go by the name netdemon.
1450
<P>Lots of Bugzilla use documention is available through Mozilla.org and other sites:
1451
<br><a href="http://www.mozilla.org/quality/help/beginning-duplicate-finding.html\">
1452
How To Find Previously Reported Bugs</a><br>
1453
<a href="http://www.mozilla.org/bugs/">Bugzilla General Information</a><br>
1454
<a href="http://www.mozilla.org/quality/help/bugzilla-helper.html">Mozilla Bug Report Form</a><br>
1455
<a href="http://www.mozilla.org/bugs/text-searching.html">Bugzilla Text Searching</a><br>
1456
<a href="http://www.mozilla.org/quality/bug-writing-guidelines.html">The Bug Reporting Guidelines</a><br>
1457
<p>My main motive for writing this was to help the engineers by giving new Bugzilla users a way to learn how to use the Bugzilla Query form. I
1458
had done a rewrite of query.cgi, so I said, "What the heck, I'll write this too".
1460
<p><br><center><h3>Why Use This?</h3></center>
1462
<p>You probably looked at the Query page and said, "This page looks too difficult. Now that
1463
I think about it, I don't really need to do a query". It is important to make sure that a bug
1464
doesn't have a duplicate before submitting it, as is stated clearly in
1465
<a href="http://www.mozilla.org/quality/bug-writing-guidelines.html">The Bug Reporting Guidelines</a>.
1466
The people reading your bugs are busy and usually swamped with bugs. Therefore, you are doing everyone
1467
a huge favor to search for a duplicate.
1481
<a name="samplequery"></a>
1482
<p><br><center><h3>Sample Query</h3></center>
1484
<p>Ok. <b>So lets find a bug!</b> We'll borrow the Mozilla.org database because it's handy.
1485
<BR>First, lets make a <a target="_blank" href="http://bugzilla.mozilla.org/query.cgi">
1486
copy</a> of the query window so you can easily switch between this document and the query.
1487
<p>Do the following:
1489
<li>Go to the "Status" field in and select all fields (or deselect all fields).
1490
<li>In Text Search options, put Autoscroll in the summary and Panning in the description entry box
1491
(meaning that panning is somewhere in the comments and the bug's summary has Autoscroll in it).
1493
<p>One of the results should have been <a href="http://bugzilla.mozilla.org/show_bug.cgi?id=22775">bug 22775 - [RFE] AutoScroll/Panning support...</a>
1499
<a name="bottom"></a>