Closed
Bug 758468
Opened 13 years ago
Closed 13 years ago
"OR" queries don't work with "changed to"
Categories
(Bugzilla :: Query/Bug List, defect)
Tracking
()
RESOLVED
WORKSFORME
People
(Reporter: ghopcraft, Unassigned)
Details
User Agent: Mozilla/5.0 (Windows NT 6.1; WOW64) AppleWebKit/536.5 (KHTML, like Gecko) Chrome/19.0.1084.52 Safari/536.5
Steps to reproduce:
In an advanced query, set
Status changed to ASSIGNED Or
Status changed to REOPENED
Actual results:
No bugs found
Expected results:
Showed bugs that were changed to assigned or ones that were changed to reopened. Either line by itself works fine.
|
||
Comment 1•13 years ago
|
||
The OR button no longer exists in 4.2.1. Make sure you selected "Match ANY of the following" in the select box in the Custom Search section. You can also append &debug=1 to the URL to see if the SQL has been correctly built. You should see something of the form (only relevant parts are shown):
...
LEFT JOIN bugs_activity AS act_9_0 ON bugs.bug_id = act_9_0.bug_id AND act_9_0.fieldid = 9 AND act_9_0.added = 'ASSIGNED' LEFT JOIN bugs_activity AS act_9_1 ON bugs.bug_id = act_9_1.bug_id AND act_9_1.fieldid = 9 AND act_9_1.added = 'REOPENED'
...
AND ( act_9_0.bug_when IS NOT NULL OR act_9_1.bug_when IS NOT NULL )
Assignee: general → query-and-buglist
Status: UNCONFIRMED → RESOLVED
Closed: 13 years ago
Component: Bugzilla-General → Query/Bug List
Resolution: --- → WORKSFORME
You need to log in
before you can comment on or make changes to this bug.
Description
•