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)

4.2.1
defect
Not set
normal

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.
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.