Closed Bug 127775 Opened 23 years ago Closed 23 years ago

Query returns faulty results if I enter "days" in number instead of the actual 'from/to' dates

Categories

(Bugzilla :: Query/Bug List, defect)

Product:
Bugzilla
Component:
Query/Bug List
Version:
2.10
Platform:
x86
Windows NT
Type:
defect
Priority:
Not set
Severity:
normal

Tracking

()

Status:
VERIFIED DUPLICATE of bug 37749

People

(Reporter: shrir, Assigned: endico)

References

(
URL
)

Details

Jaime showed this problem to me. plf: winNT, trunk 0225 bld Go to the link above and make the following changes in the page: In the field 'Changed in the last' , enter '31' In the field "Where the fields" , select "bug status" . In the textfield titled 'changed to value' , enter RESOLVED Pls make sure that TARGET MILESTONE has nothing selected in it ( by default it has mozilla 1.0). HIT CTRL+CLICK to remove any selection Also remove all keywords from the KEYWORDS field. Hit SUBMIT QUERY button Observe that the result pops up only 2 bugs (which is not true unless the developers are really not working ;)) Now, go bak to the query page and instead of the number '31', enter the date "01/31/02' in the textfield titled 'Dates' to 'NOW' . Leave the 'NOW' as it is. Leave rest of the query info as it was in the earlier case. Hit SUBMIT, and see that the query returns something like...81 bugs. Isn't this a problem in bugzilla? Or am I doing something really wrong?
Summary: Query returns faulty results if I enter "days" in bumber instead of the actual date → Query returns faulty results if I enter "days" in number instead of the actual 'from/to' dates
oops forgot one thing: STATUS selection should be RESOLVED RESOLUTION selection should be FIXED
The "changed in the last [ ] days" is an independent control on the query form, and doesn't make use of the "changed fields" section. It simply checks the last modified date on the bug. I think leaving the "from" field blank is equivalent to saying "today". As an experiment, I tried "changed in the last [1] days, changed fields [bug creation], from [1/1/1970] to [now]" and got 947 bugs. (bugs created since 1970 that had also been touched in the last day). I tried it again with the same query, but changing the date to 2/24/2002 and got 125 bugs (because now it was only bugs created since yesterday)
*** This bug has been marked as a duplicate of 37749 ***
Status: NEW → RESOLVED
Closed: 23 years ago
Resolution: --- → DUPLICATE
good...thx. For a moment, I thought...is this bug invalid ;)
Status: RESOLVED → VERIFIED
QA Contact: matty_is_a_geek → default-qa
You need to log in before you can comment on or make changes to this bug.