summaryrefslogtreecommitdiffstats
diff options
context:
space:
mode:
-rw-r--r--CHANGES6
-rwxr-xr-xbuglist.cgi18
-rwxr-xr-xmakebugtable.sh3
-rwxr-xr-xquery.cgi4
4 files changed, 28 insertions, 3 deletions
diff --git a/CHANGES b/CHANGES
index 14336949b..eb2fbb78b 100644
--- a/CHANGES
+++ b/CHANGES
@@ -10,6 +10,12 @@ query the CVS tree. For example,
will tell you what has been changed in the last week.
+5/5/99 Added the ability to search by creation date. To make this perform
+well, you ought to do the following:
+
+ alter table bugs change column creation_ts creation_ts datetime not null, add index (creation_ts);
+
+
4/30/99 Added a new severity, "blocker". To get this into your running
Bugzilla, do the following:
diff --git a/buglist.cgi b/buglist.cgi
index a8c10d1c2..9d42528ed 100755
--- a/buglist.cgi
+++ b/buglist.cgi
@@ -359,7 +359,23 @@ sub SqlifyDate {
}
-
+if (defined $ref) {
+ my $which = lsearch($ref, "[Bug creation]");
+ if ($which >= 0) {
+ splice(@$ref, $which, 1);
+ $query .= "and bugs.creation_ts >= " .
+ SqlifyDate($::FORM{'chfieldfrom'}) . "\n";
+ my $to = $::FORM{'chfieldto'};
+ if (defined $to) {
+ $to = trim($to);
+ if ($to ne "" && $to !~ /^now$/i) {
+ $query .= "and bugs.creation_ts <= " .
+ SqlifyDate($to) . "\n";
+ }
+ }
+ }
+}
+
if (defined $ref && 0 < @$ref) {
diff --git a/makebugtable.sh b/makebugtable.sh
index c142b2d5a..18d83a66c 100755
--- a/makebugtable.sh
+++ b/makebugtable.sh
@@ -34,7 +34,7 @@ assigned_to mediumint not null, # This is a comment.
bug_file_loc text,
bug_severity enum("blocker", "critical", "major", "normal", "minor", "trivial", "enhancement") not null,
bug_status enum("NEW", "ASSIGNED", "REOPENED", "RESOLVED", "VERIFIED", "CLOSED") not null,
-creation_ts datetime,
+creation_ts datetime not null,
delta_ts timestamp,
short_desc mediumtext,
long_desc mediumtext,
@@ -52,6 +52,7 @@ qa_contact mediumint not null,
status_whiteboard mediumtext not null,
index (assigned_to),
+index (creation_ts),
index (delta_ts),
index (bug_severity),
index (bug_status),
diff --git a/query.cgi b/query.cgi
index 5ee513ec0..83609b0a7 100755
--- a/query.cgi
+++ b/query.cgi
@@ -345,6 +345,8 @@ push @::legal_target_milestone, "---"; # Oy, what a hack.
print $jscript;
+my @logfields = ("[Bug creation]", @::log_columns);
+
print "
<FORM NAME=queryForm METHOD=GET ACTION=\"buglist.cgi\">
@@ -403,7 +405,7 @@ Changed in the <NOBR>last <INPUT NAME=changedin SIZE=2 VALUE=\"$default{'changed
<td rowspan=2 align=right>Where the field(s)
</td><td rowspan=2>
<SELECT NAME=\"chfield\" MULTIPLE SIZE=4>
-@{[make_options(\@::log_columns, $default{'chfield'}, $type{'chfield'})]}
+@{[make_options(\@logfields, $default{'chfield'}, $type{'chfield'})]}
</SELECT>
</td><td rowspan=2>
changed.