116425 - a way to exclude "Future" from the query

Status: RESOLVED WORKSFORME

(Bugzilla :: Query/Bug List, enhancement)

Description

[Frank Tang]

currently, when I query bugzilla, it is very hard to produce a list which
exclude a particulare milestone, for example, I constantly need to query any bug
those I put into "future" milestone.  If I select every milestone and deselect
the "Future" one, then the query is broken (I think there are some length
limitation) I want a way to exclude "Future" milestone.

Comment 1

[Andreas Franke (gone)]

I tried this with a query for open bugs in product=Browser,
component=Internationalization, using Mozilla 0.9.7.

- Without any additional constraints/conditions, I got 413 bugs.

- When I clicked the back button and selected all target milestones except
Future, I got nearly 9000 bugs, but then I discovered that this was due to a bug
with the javascript code for component selection: In the current version on
bugzilla.mozilla.org, the component selection is cleared on back. I think this
is bug 83033.

- After reselecting component=Internationalization and selecting all milestones
 except Future, I get 229 bugs, which is a plausible result.

- Alternatively, you can perform an "Advanced Query using Boolean Charts" with
the condition ("Target Milestone", "not equal to", "Future"). Again, the result
is 229 bugs.

Based on these tests, I think this is either worksforme or a dupe of bug 83033.

Comment 2

[Matthew Tuck [:CodeMachine]]

There is a good point about exclusion, especially given you might add new things
and they wouldn't be included when they should.

However all this applies equally well to all fields.  I would be very hesitant
to add an exclusion checkbox to each field.

And as stated, this can be done via advanced query.  Moving to Future and we'll
see if any better ideas come up.

Comment 3

[Shane H. W. Travis]

There are two ways to get this functionality: 
1) One can deselect all the milestones (or insert-other-picklist) except the
   ones you want, and run the query. This works just fine for me.

2) One can use the Advanced Searching Using Boolean Charts and select 
   "Target Milestone|is not equal to|Future" 
   (or even "NOT "Target Milestone|is equal to|Future" if you want)

Both/all three of these methods return the same number of bugs for me. If you 
need to exclude more than just one thing, then remove the extra items from the 
picklist too (using control-click), or add another item to the boolean search.

This is more than enough functionality to cover the original request. 
Marking as WORKSFORME.

Comment 4

[Dave Miller [:justdave]]

clearing target of DUPLICATE/WONTFIX/INVALID/WORKSFORME so they'll show up as
untriaged if they get reopened.