It's not the same without you

Join the community to find out what other Atlassian users are discussing, debating and creating.

Atlassian Community Hero Image Collage

Advanced search filter for more than one 'exclusion'

Hi all, hope you had a great weekend, 

I was wondering if you could help me in terms of filter.

I am aware that we can exclude certain field by using '!~'

However, if I would like to exclude more than one item. I tried for example !~ xxxx !~ aaaa but it does not work

Is there any way we can achieve that? 

project = yyyy AND summary !~ xxxx AND issuetype = zzzzz AND status in (xyz, "abc", "12345") AND "6789" in cascadeOption(00000, 00000) ORDER BY priority DESC, updated DESC

Thanks so much and kind regards.

Saengrawee

1 answer

Hi Saengrawee Klamdam

Why don't replace:

summary !~ xxxx

With:

summary !~ "xxxx" AND summary !~ "aaaa"

 

Does it work for you?

Regards

Hello,

Thanks for your help.

Unfortunately it does not work as I got the following feedback

Error in the JQL Query: Expecting a field name but got 'AND'. You must surround 'AND' in quotation marks to use it as a field name. (line 1, character 47)

Any futher suggestion?

Thank you

Uops! I made a typo and write a double AND in my response.
Check it out again

I tried both, with a double AND, with one AND, both lead to the same error response.

thank you.

Could you share with us your final JQL query using my proposal? I believe there is something incorrect on it.

sorry, it does not work still.

Thank you

Could you share with us an image to see where error are you getting?

Regards

Query:

project = yyyy summary !~ "xxxx" AND summary !~ "aaaa" AND issuetype = zzzzz AND status in (xyz, "abc", "12345") AND "6789" in cascadeOption(00000, 00000) ORDER BY priority DESC, updated DESC

Hi,
You need to add the 'AND' word between project = yyy and the first summary !~ "xxxx"

 

See:

project = yyyy AND summary !~ "xxxx" AND summary !~ "aaaa" AND issuetype = zzzzz AND status in (xyz, "abc", "12345") AND "6789" in cascadeOption(00000, 00000) ORDER BY priority DESC, updated DESC

 

Thanks in advance :)

Suggest an answer

Log in or Sign up to answer
Community showcase
Posted in Jira

Demo Den Ep. 7: New Jira Cloud Reports

Learn how to use two new reports for next-gen projects in Jira Cloud:  Cumulative flow diagram and Sprint burndown chart. Ivan Teong, Product Manager, Jira Software, demos the Cumulative ...

273 views 1 2
Join discussion

Community Events

Connect with like-minded Atlassian users at free events near you!

Find an event

Connect with like-minded Atlassian users at free events near you!

Unfortunately there are no Community Events near you at the moment.

Host an event

You're one step closer to meeting fellow Atlassian users at your local event. Learn more about Community Events

Events near you