Summary does not contain letter "t"

[Svetlana Kom]

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 solution]

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 solution]

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.

[Daniel Turczanski - JQL Search Extensions]

Hi @Svetlana Kom ,

With standard JQL you can only get a list of issues with summaries and export them to Excel for further processing. This works if you want to do a one-off analysis.

Standard JQL doesn't easily allow it but the results can be quickly found using our professional indexing service:

• JQL Search Extensions

After you install the app you can simply search:

issue not in wildcardMatch("summary", "*t*")

You may want to check out the docs as well.

I hope this helps!

Daniel