JQL Query to filter out issues where Summary contains a particular word

I need to create a search filter that excludes all issues that contain the word "CLONE" in the Summary field.  (I have 5 issues used to clone to make new issues and don't want my users to accidentally update those when looking in search results.  They have Summary text with variations of "00-CLONE ME" etc.)

Right now my query is this - just need to add that last filter.  Have tried a number of variations, but with no luck. Any help is appreciated!

project = PM AND status in (Open, "In Progress", "Initiate Campaign", "Gathering Rqmts", "Testing Camp Setup", "Pending Doc", "Assgd to PM", "Assgd to Tech", "Modify DO Template", "In Prog - DO Templ Mods", "Clt Approved Script", "In Progress - PM", "Approval Requested", "Pending Client Apprvl", "Request Client Revisions", "Pending Client Revisions", "In Progress (Tech)", "Pending Data Contact Revs", "C-List Load Issues", "Extract Test Data", "Pending Data Contact Apprvl", "Test DO Approved", "Pre-Flight Complete", "Validate Pre-Flight", "Ops In Progress", "Ops Compl - Awaiting Closure", Assigned) ORDER BY created DESC

2 answers

1 accepted

This widget could not be displayed.

Keith, Do you want to create a serch filter that excludes all issues that contain the word CLONE in the Summary filed?

So you can put 

*summary !~ "CLONE"*

at the search issue.

Regards.

Lameck.

That got me there, though it isn't exact so figured I should post this update.  Here's what I added to my existing query that worked:

AND summary !~ CLONE 

The * characters threw an error.  (working in Cloud version, so maybe that's why? Not sure)

Bottom line - it's working for me and will save me many headaches in the days to come.  Thank you.

Keith, good! 

The * is a typo. :/ 

But it's very good read that filter will save your time. laugh 

Regards.

This widget could not be displayed.

It still doesn't work for me. 

I'm trying to return back-end stories that are labelled as [BE] in the issue summary. Can someone tell me what is wrong with this JQL? 

project = "X" summary ~ "\"[BE]\"" ORDER BY summary ASC, priority DESC, updated DESC 

It's not returning any issues even though a lot of issues has "[BE]" in the summary. 

Hi @Eren

Jira cannot properly do partial word searching.  In turn it does not actually do well at searching mixed character strings.   Instead it is built to search for complete words.  Since this tag is rather short and contains other characters of "[" and "]" that is going to make it more difficult to find those issues when trying to extract this text out of summary field.   This partial word searching limitation is also noted in our documentation on Search syntax for text fields: Limtations: Whole words only.

However there could be other ways to find this information.  For example, the scriptrunner plugin for Jira will allow you to use regex searches in JQL searching.  Check out https://scriptrunner.adaptavist.com/latest/jira/jql-functions.html#_issuefieldmatch

This function provided via this plugin would then allow you to create a JQL syntax of something like this:

issueFunction in issueFieldMatch("project = X", "summary", "\[BE\]")

In turn this should then allow you to find the issues that might have that specific string in them.

It is also possible there are other plugins for Jira that can help here, I only cited the scriptrunner one because I know it has this regex search ability within JQL.

I hope this helps.

Andy

Hi @Andrew Heinzer

You save my life.  Thank you very much.

Suggest an answer

Log in or Sign up to answer
Atlassian Summit 2018

Meet the community IRL

Atlassian Summit is an excellent opportunity for in-person support, training, and networking.

Learn more
Community showcase
Posted Aug 06, 2018 in Jira Service Desk

A is for Activate: Share your top Jira Service Desk onboarding tips for new users!

Hi, everyone! Molly here from the Jira Service Desk Product Marketing Team :).  In the spirit of this month's  august-challenge, we're sourcing stories of Jira Service Desk activation fro...

578 views 25 15
Join discussion

Atlassian User Groups

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

Find a group

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

Find my local user group

Unfortunately there are no AUG chapters near you at the moment.

Start an AUG

You're one step closer to meeting fellow Atlassian users at your local meet up. Learn more about AUGs

Groups near you