How to use "text ~" to exclude issues containing this text from the queue?

[Arnis Riškovs]

Hi,

I changed the conditions for creating the issues queue to exclude tickets containing the text "(Test)" from it:
NOT text ~ "(Tests)" AND (resolution = Unresolved OR status = Postponed) ORDER BY "Time to resolution" ASC

However, issues for which Summary field contains "(Test)" do not disappear from the list. Why?

[Mohamed Benziane · Accepted solution]

Hi,

If you're looking for some text in the Summary you could try this:

summary !~'Tests' AND (resolution = Unresolved OR status = Postponed) ORDER BY "Time to resolution" ASC 

[Arnis Riškovs]

Hi Mohamed Benziane,

Thanks - it works! 👌

[Joseph Chung Yin · Accepted solution]

@Arnis Riškovs 

As stated by other community leaders - you need to use "!~" operator.

In addition, if you are focusing just on the "Summary" field, then You will need to use "summary" instead of "text" in your JQL.   

Lastly, when you evaluate "Resolution" field, it is recommended to use Resolution is empty instead of looking at the word of "Unresolved" in your JQL.  The value of "Unresolved" is actually the internal representation of NULL value in Jira/JSM for the Resolution field.  Unless you have actually introduced a value of "Unresolved" as an option for the Resolution field, if that was the case, you should consider to remove the option ASAP.

Best, Joseph Chung Yin

Jira/JSM Functional Lead, Global Infrastructure Applications Team

Viasat Inc.

[Alex Koxaras _Relational_ · Accepted solution]

Hi @Arnis Riškovs 

The "does not contain" operator is !~

https://support.atlassian.com/jira-software-cloud/docs/advanced-search-reference-jql-operators/#:~:text=top%20of%20page-,DOES%20NOT%20CONTAIN%3A%20!~,-The%20%22!~

Try the above and let me know if that helped.