diff options
| author | Gervase Markham <gerv@gerv.net> | 2013-01-02 18:58:34 +0100 |
|---|---|---|
| committer | Gervase Markham <gerv@mozilla.org> | 2013-01-02 18:58:34 +0100 |
| commit | 725f2fb7958c6a251efdb056d49063fc4f8da91a (patch) | |
| tree | 068dd4c94d2a9f7bf3ae85f6019d4c2ba4a67989 /Bugzilla/Search.pm | |
| parent | 21b50cba4e08e723f8c2d8e8b5800d0a13e2c180 (diff) | |
| download | bugzilla-725f2fb7958c6a251efdb056d49063fc4f8da91a.tar.gz bugzilla-725f2fb7958c6a251efdb056d49063fc4f8da91a.tar.xz | |
Bug 801664 - Add DATE type for custom fields. r=LpSolit.
Diffstat (limited to 'Bugzilla/Search.pm')
| -rw-r--r-- | Bugzilla/Search.pm | 9 |
1 files changed, 9 insertions, 0 deletions
diff --git a/Bugzilla/Search.pm b/Bugzilla/Search.pm index b9c37b4ed..71893a5fc 100644 --- a/Bugzilla/Search.pm +++ b/Bugzilla/Search.pm @@ -108,6 +108,7 @@ use Storable qw(dclone); # When doing searches, NULL datetimes are treated as this date. use constant EMPTY_DATETIME => '1970-01-01 00:00:00'; +use constant EMPTY_DATE => '1970-01-01'; # This is the regex for real numbers from Regexp::Common, modified to be # more readable. @@ -310,6 +311,7 @@ use constant OPERATOR_FIELD_OVERRIDE => { FIELD_TYPE_FREETEXT, { _non_changed => \&_nullable }, FIELD_TYPE_BUG_ID, { _non_changed => \&_nullable_int }, FIELD_TYPE_DATETIME, { _non_changed => \&_nullable_datetime }, + FIELD_TYPE_DATE, { _non_changed => \&_nullable_date }, FIELD_TYPE_TEXTAREA, { _non_changed => \&_nullable }, FIELD_TYPE_MULTI_SELECT, MULTI_SELECT_OVERRIDE, FIELD_TYPE_BUG_URLS, MULTI_SELECT_OVERRIDE, @@ -2511,6 +2513,13 @@ sub _nullable_datetime { $args->{full_field} = "COALESCE($field, $empty)"; } +sub _nullable_date { + my ($self, $args) = @_; + my $field = $args->{full_field}; + my $empty = Bugzilla->dbh->quote(EMPTY_DATE); + $args->{full_field} = "COALESCE($field, $empty)"; +} + sub _deadline { my ($self, $args) = @_; my $field = $args->{full_field}; |