533878 - Allow relative date searches involving date/time custom fields

Status: RESOLVED FIXED

(Bugzilla :: Query/Bug List, enhancement, P2)

Description

[Joel Peshkin]

When a boolean search involves the value in a date/time custom field, the comparison should use timestamp_compare and gain the full capabilities of sqlifyDate, but it doesn't.

For example, compare such a field to '7d' and the '7d' winds up in the sql.

This does not appear to be any different on the tip.

Comment 1

[Max Kanat-Alexander]

Thanks for filing this--it's something I've known about for a while but I'm not sure it was filed already (though it may have been, perhaps with a strange summary or something).

Comment 2

[josef radinger]

would be great to have such a capability. maybe it is sufficent to have extra comparisions as "is date", "date before",...

Comment 5

[:glob ✱]

Attachment: patch v1

this patch adds relative date support for all date/datetime fields.

for example, if you had a due-date custom date field, and wanted to search for all bugs due in the next two weeks, you can do:
  (match all of the following against the same field):
    (due date) (is greater than or equal to) "now"
    (due date) (is less than or equal to)    "+2w"

Comment 6

[Frédéric Buclin]

Comment on attachment 770041 [details] [diff] [review]
patch v1

Nice! r=LpSolit

Comment 7

[:glob ✱]

Committing to: bzr+ssh://[e-mail]/bugzilla/trunk/
modified Bugzilla/Search.pm
modified t/011pod.t
Committed revision 8658.