Support AND/OR queries

[cboos]

The query view allows you to create "AND" queries: each added filter can only reduce the set of matches.

It would be sometimes useful to be able to add a criterion which would simply gather more content (i.e. that would be "OR"ed to the other constraints).

Example use case:

create a query that would retrieve all tickets have "RSS" either in the summary or in the list of keywords

Of course, the UI should remain as simple as possible with this added capability.

[cmlenz]

So do you have a suggestion on how the UI should look for this? Bugzilla has the feature (boolean charts), and the UI is horrible :-/

[cboos]

Nothing satisfying ATM, but now that there's a ticket, amazing ideas should start to flow in from all over the net :)

[eblot]

I think a basic interface as the message rules in Mail (MacOS) or Thunderbird would already be an improvement:

There's a simple Any (OR) or All (AND) selector that applies to all fields, whereas each field may have a property or NOT the property. This does not allow all the boolean combinations, but already brings some power to the filter rules.

This could be the first implementation, and it would probably require a few modifications to the current code (add the AND/OR selector basically).

[anonymous]

The UI could just be a toggle specifying of you use AND or OR like in iTunes' smart list conditions. To mix AND and OR conditions, you can support nested custom queries like in iTunes again. That would keep the UI simple, but fairly powerful. The nested query would require an ability to have named custom queries to save queries instead of the current URL link system.

[sid <sid.wiesner@…>]

I think the Itunes is elegant and would have a pretty minimal impact on the custom query page. Adding just a checkbox to "Match any or all of these filters" would do the trick:

[sid]

#3389 marked as a duplicate of this ticket.

[cboos]

#6357 closed as duplicate as well, presents another use case.