Query that shows open issues within a group of projectsthat contain ANY term from a list

[Jamie Cannon]

Non-coder here, so there's probably a simple solution to this problem.

I'm trying to create a search query that shows issues that are not Closed/Resolved within a list of Projects that contain ANY of the terms from the list below. There are multiple ways to reference a product (product name, full codename, abbreviated codename, etc), hence the excessive list of search terms.

I think the issue lies with the AND and OR statements & how they're ordered and there's some syntax thing I just don't know yet. Here's the query in plain English:

If the issue contains ANY of the following terms:

Banana 1, Banana 2, B1, B2, Ban1, Ban2

 AND it's found in ANY of the following Projects:

LNG, YLW, FRT

AND the status IS NOT:

Closed, Resolved 

THEN show it in the search results.

Here's the (non-working) query I've put together so far:

text ~"Banana 1" OR text ~"Banana 2" OR text ~"B1" OR text ~"B2" OR text ~"Ban1" OR text ~"Ban2" AND project in (LNG, YLW, FRT) AND status WAS NOT IN ("Closed", "Resolved")

Any help is greatly appreciated. Thanks in advance.

[Mehmet A _Bloompeak_ · Accepted solution]

Hi @Jamie Cannon ,

Try below, hope it works.

(text ~"Banana 1" OR text ~"Banana 2" OR text ~"B1" OR text ~"B2" OR text ~"Ban1" OR text ~"Ban2") AND project in (LNG, YLW, FRT) AND status WAS NOT IN ("Closed", "Resolved")

[Jamie Cannon]

See, I knew there was an easy answer: just add ( ) around the first part. Thanks for your answer!