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.
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")
See, I knew there was an easy answer: just add ( ) around the first part. Thanks for your answer!
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.