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

1 answer

1 accepted

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.



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 


Suggest an answer

Log in or Join to answer
Community showcase
Sarah Schuster
Posted Jan 29, 2018 in Jira

What are common themes you've seen across successful & failed Jira Software implementations?

Hey everyone! My name is Sarah Schuster, and I'm a Customer Success Manager in Atlassian specializing in Jira Software Cloud. Over the next few weeks I will be posting discussion topics (8 total) to ...

3,301 views 14 20
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
Atlassian Team Tour

Join us on the Team Tour

We're bringing product updates and pro tips on teamwork to ten cities around the world.

Save your spot