Sub-queries: Group terms for AND, OR, NOT

[tripleee]

💥 Proposal

I would like to be able to group (perhaps by way of parentheses) groups of terms so that you can search for things like

(( mine AND assigned to myself) OR urgent) AND NOT project:grandmas-web-shoppe

in the ticket search box.

What feature you'd like to see

The current search syntax only lets you set up AND queries, which is too simplistic for many real-world scenarios.

Extending the query language to group terms and perhaps also support OR would significantly improve the query experience and thus the ability of users to target specific sets of tickets.

Motivation

This grew out of a support ticket of mine, which hopefully documents my personal motivation sufficiently.

#1448 (comment)

@andrew requested that I create a feature request for this functionality.

Pitch

If Octobox is supposed to give us detailed control over our tickets, many of us will want to exclude sets of "noise" tickets from our inbox using reasonably complex criteria. Automatically sorting various kinds of "noise" into their own dedicated virtual folders would improve functionality for anyone who needs to find the needles in the haystack that is a constant stream of tickets. (Pardon the metaphor mix. I should probably not try to get into marketing.)