Filter out issues where Summary contains a particular word

john.jerome

Hi Guys,

I'm looking to filter out "user submissions" as my key words from my open queue, but i've been struggling with doing this the basic way, so i've had a look at via JQL, however i'm struggling on the SQL also.

My current queue looks like this: 

status in ("Awaiting CAB approval", "Awaiting implementation", Escalated, Implementing, "In Progress", Open, "Peer review / change manager approval", Pending, Planning, Reopened, "Under investigation", "Under review", "Waiting for approval", "Waiting for customer", "Waiting for support", "Work in progress") AND resolution = Unresolved ORDER BY "Time to resolution" ASC

Does anyone know how i can remove the words "user submissions" from my summary so that these don't appear in my open queue, and also where this would be added in my filter above? Sorry i'm new to this, and any help would be greatly appreciated.

Thanks,

John

Max Foerster - K15t

Hi @john.jerome 

this is a bit tricky. You could use 

summary !~ "\"user submission\""

to exclude the exact phrase (refer to the very good JQL documentation here: https://support.atlassian.com/jira-software-cloud/docs/search-syntax-for-text-fields/).

But I just gave it a quick try and unfortunately, the result also excluded an example not matching the exact phrase but having both words in the summary. So it seems to be working only server only. But give it a try and see if it works for you!  

Best, Max