294937 - Query for bugs changed between date range is somewhat misleading

Status: NEW

(Bugzilla :: Query/Bug List, defect)

Description

[Margaret Smith]

User-Agent:       Mozilla/5.0 (Windows; U; Windows NT 5.0; en-US; rv:1.7.5) Gecko/20041217
Build Identifier: Mozilla/5.0 (Windows; U; Windows NT 5.0; en-US; rv:1.7.5) Gecko/20041217

The query - Advanced Search page has a section for "Bug Changes". I have people
who want to find log items changed between certain dates. I have found that if
you enter a date range but do not enter anything in "where one or more of the
following changed:" then the search is done on 'Changed' field (bugs.delta_ts in
the DB I think). But this is misleading because the bug may have changed
previously to 'Changed' and it doesn't get put into the search results.

I noticed that this was similarly written up on the newsgroup - Mar 29, 2005
"Bugzilla: bugs changed between query bug?". The reply was that you must enter
something in the "where one or more of the following changed:" - i.e it is not
optional. If it is not optional, then it should produce an error if the user
doesn't enter it. But more importantly, most users don't want to put anything in
there, so optional is what we really need, and then we want it to search on any
fields changed during those dates.

On the newsgroup Gerv says optional is a good idea, but I can't find a bug
written up about this, so that's why I'm doing it. Even if you don't implement
the optional thing right away, maybe you can add an error or default.



Reproducible: Always

Steps to Reproduce:
1. Go to Advanced Search page
2. Enter date range in Bugs Changed section, and do not enter anything else in
that section (ie do not select anything from "where one or more of the following
changed:"
3. Click Search 

Actual Results:  
Search results are returned with bugs that have a 'Changed' date between the
dates you entered in the query.

Expected Results:  
Bugs where any field was changed in the date range specified.

Comment 1

[Wayne Mery (:wsmwk)]

Something is indded odd - but there may be more than one bug.   Confirming.

consider the case where a date range is specified, all the items of the "one or
more" are selected, and "new value" is left blank.   for example
https://bugzilla.mozilla.org/buglist.cgi?query_format=advanced&short_desc_type=allwordssubstr&short_desc=&product=Mozilla+Application+Suite&long_desc_type=substring&long_desc=&bug_file_loc_type=allwordssubstr&bug_file_loc=&status_whiteboard_type=anywords&status_whiteboard=&keywords_type=anywords&keywords=&bug_status=UNCONFIRMED&bug_status=NEW&bug_status=ASSIGNED&bug_status=REOPENED&emailassigned_to1=1&emailtype1=exact&email1=&emailassigned_to2=1&emailreporter2=1&emailqa_contact2=1&emailtype2=exact&email2=&bugidtype=include&bug_id=&votes=&chfieldfrom=2000-11-22&chfieldto=2004-11-22&chfield=alias&chfield=assigned_to&chfield=bug_file_loc&chfield=bug_severity&chfield=bug_status&chfield=cclist_accessible&chfield=component&chfield=everconfirmed&chfield=keywords&chfield=op_sys&chfield=priority&chfield=product&chfield=qa_contact&chfield=rep_platform&chfield=reporter&chfield=reporter_accessible&chfield=resolution&chfield=short_desc&chfield=status_whiteboard&chfield=target_milestone&chfield=version&chfield=votes&chfieldvalue=&cmdtype=doit&order=Reuse+same+sort+as+last+time&field0-0-0=short_desc&type0-0-0=substring&value0-0-0=meta&field0-0-1=keywords&type0-0-1=substring&value0-0-1=meta

The query result returns a list where it is apparent that the date range has
been ignored.

Comment 2

[Wayne Mery (:wsmwk)]

(In reply to comment #1)
>
> The query result returns a list where it is apparent that the date range has
> been ignored.

perhaps my cited example is bug 58179?