nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

How to exclude work items where summary is equal to TEST in JQL

Joshua Redel

I have to use JQL for a search that connects to a slack integration, and I explicitly want to exclude where the name of the work item is "TEST". However, summary only seems to search for !~, which means anything with TEST in the name would get excluded. How can I exclude an item whose name is TEST specifically?

Accepted answers

All comments

Trudy P Claspill

Hello @Joshua Redel

Welcome to the Atlassian community.

Do I understand correctly that the items you want to exclude have only the text TEST in their Summary, and no other text?

What I have found is that the !~ can exclude items based on a phrase, but if it has only a single word then it excludes all items that contain that word anywhere within the field.

Is it possible for you to change the name of the items to a unique multi-word phrase like "TEST ISSUE"?

Joshua Redel

Yeah, so I can, but it's really hard to enforce that across a team of 50 engineers — just telling them "call it TEST" is easy, but telling them "call it TEST ISSUE" is much harder. Is there really no way to just say you want when summary doesn't equal something? Is it perhaps possible using an embedded AQL query or something?

Trudy P Claspill

AQL is for querying Asset related data. Do these have some relationship to Asset objects?

In an Automation rule you can use string functions to determine if a text field contains just "TEST".

You could use Automation Rules to change or existing items and new items as the get created.

Or you could add a custom field that is more easily filtered upon, and ask the engineers to set that or again use Automation Rules to set it.

Joshua Redel

The problem is that "on create" is also when the Slack Integration runs, so there'd be a race condition for any automation to update a field before the slack integration catches the item and spams our slack channel.

Marc -Devoteam-

Hi @Joshua Redel

Based on your requirement and the response from @Trudy P Claspill would it not be simpler to create a new work type called "Test"?

Use this work type for testing, then in a JQL its way simpler to exclude a specific work type, then basgin this on a test field like summary.

Joshua Redel

It's not a bad idea, but...we'd have to scope all our many, many automations to include Test in addition to whichever work type they're specified for. Then we'd need to update all our automations outside of Jira that create tickets — slack, airtable, etc. etc. to only create Test tickets when testing and create regular tickets otherwise. Which also means needing to switch back and forth for 3p apps that don't have sandboxing (like Airtable), which seems untenable. I guess we could create a dropdown for each automation that allows the creation of either the regular work type or a test one...sounds like a lot of work just to be able to search for a name that matches "Test".

Welcome!

It looks like you're new here. Sign in or register to get started.

Quick Links

Find more posts tagged with

cloud

jql

jira-service-management-cloud

jira-service-management