Create new Project View filtering with AND, OR, NOT operators

[jwerre]

Is there a way to filter Projects with the AND, OR, NOT operators? I tired to create a Project View with the filter ( repo:"x" OR repo:"y" ) AND -status:Done but that didn't seem to work. I was looking at the docs and they is suggest that these operators are possible but not much about how to use them:

You can't construct a query using more than five AND, OR, or NOT operators

I found some more details on NOT here but I could only get the - to work not the NOT operator. Is it safe to say that the GitHub search syntax doesn't work for GitHub Projects?

[michael-hawker]

Related to #15655

[dkfellows]

According to the documentation:

Using multiple filters will act as a logical AND filter. For example, label:bug status:"In progress" will return items with the bug label and the "In progress" status. You can also provide multiple values for the same field to act as a logical OR filter. For example, label:bug,support will return items with either the bug or support labels. Projects does not currently support logical OR filters across multiple fields.

It's a shame that full OR remains unsupported; it means I can't filter to, say, the Issues and PRs where either I'm assigned to work on them or where I'm a reviewer (that is, all the items in the project where I'm actioned to do something with them). Or the equivalent for someone else. Especially as well as combining that with other filters (e.g., to exclude the closed issues).

[mcmire]

Agreed. This is a big limitation in my opinion. I end up having to create multiple views when I really just want one view. Seems like something that should be easy if filtering on multiple values of the same field is possible.

[TimGuendel]

We need this as well 👀

[bholbrook73]

I read #15655 and it seemed like commas acted like "or", but trying this to find tasks missing something:
no:product , no:type , no:status , no:priority didn't work at all. Would really love to be able to have additional logical operators.

[JohannKaspar]

same here

[ElliotKetchup]

I need this to filter all the issues with missing fields, something like:
no:repo OR no:assignee OR no:label
It's a shame this is not implemented

[Gergling]

I would also like the filter to include OR functionality.

[douglasg14b]

I get the feeling that projects is an abandoned feature at this point, it's missing so many fundamental features to make it competitive. Like filter/query operators for example....

[Gergling]

Fine. I'll build my own. With blackjack. And hooks.

[amenity]

+1.