Summary does not contain letter "t"

Question

I want to create a filter of the issues in which the summary field does not contain one letter "t"

summary !~ t - function still shows issues with the letter "t" in the summary, is it possible to filter the summary by one letter/digit or only one word filter is possible?

Alex Koxaras -Relational- · Accepted Answer

Hi @Svetlana Kom and welcome to the community.

Unfortunately is not possible to filter out the results like this. One workaround would be this one: https://confluence.atlassian.com/jirakb/jql-queries-search-for-issues-that-do-not-contain-text-1018761257.html

Do let me know if that suits your needs.
Alex

Payne · Accepted Answer

Alex's solution works in a limited capacity - the workaround he suggests states that it works only for Server and Data Center instances, and you state that you have a Cloud instance. Further, even in a supported instance type, it would allow one to find only summaries containing a standalone t (summary ~ t) or those containing a word beginning with the letter t (summary ~ "t*")

If you truly wish to find all with a summary that flat-out does not include the letter t, I would suggest exporting to CSV (must be < 1000 issues, so limit as much as you can with JQL, e.g. project = MyProject and created > startOfYear() ), then export to CSV (top right), open in Excel, add a column with function like =FIND("t",D2) and then sort by that column; all the ones without a t will sort to the bottom.