301370 - how do you use the boolean table for "Last Changed Date", with relative dates?

Status: RESOLVED INVALID

(Bugzilla :: Query/Bug List, enhancement)

Description

[Albert Ting]

User-Agent:       Mozilla/5.0 (X11; U; Linux i686; en-US; rv:1.7.5) Gecko/20041223 Firefox/1.0
Build Identifier: Mozilla/5.0 (X11; U; Linux i686; en-US; rv:1.7.5) Gecko/20041223 Firefox/1.0

How does one do a query in the boolean table for "Last Changed Date" using
relative dates?  In particular, I'm looking for is a list of open critical bugs
that have had no activity in the past 4 hours.  


Reproducible: Always

Steps to Reproduce:

Comment 1

[Frédéric Buclin]

Albert, this is not the right place to get support. If you need help, please
visit this link:

http://www.bugzilla.org/support/

Comment 2

[Albert Ting]

(In reply to comment #1)
> Albert, this is not the right place to get support. If you need help, please
> visit this link:
> 
> http://www.bugzilla.org/support/
> 

For what it's worth, I was not able to get the query to work, using:
 
    "last changed date" : "is greater/less than" : 4h

I ended up patching Search.pm to get the above to work.  Is this a bug?

--- Bugzilla/Search.pm	2005-07-07 22:35:20.000000000 -0700
+++ Bugzilla/Search.pm	2005-07-19 15:00:12.000000000 -0700
@@ -1005,12 +1010,22 @@
          ",notregexp" => sub {
              $term = "$ff " . $dbh->sql_not_regexp() . " $q";
          },
+         "^delta_ts,lessthan" => sub {
+             $v = SqlifyDate($v);
+             $q = &::SqlQuote($v);
+             $term = "$ff < $q";
+         },
          ",lessthan" => sub {
              $term = "$ff < $q";
          },
          ",matches" => sub {
              ThrowUserError("search_content_without_matches");
          },
+         "^delta_ts,greaterthan" => sub {
+             $v = SqlifyDate($v);
+             $q = &::SqlQuote($v);
+             $term = "$ff > $q";
+         },
          ",greaterthan" => sub {
              $term = "$ff > $q";
          },