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; } } }

Need a JQL to exclude existing JQL from changes I want to make for anything else

Tomasz Bis

HI,

I have created a JQL that triggers our Opsgenie notifications.

I would like to to create an automation that would change priority level from whatever it is to 'Medium' excluding JQL I have mentioned above from this automation.

It is specifically to change priority level from 'Highest' to 'Medium' for issuetype (when issue triggered) 'email request' and exclude my automation. Am I able to add some JQL rule that excludes the one that I am referring to please?

For instance, JQL > 'project = ISD AND issuetype = "Email request" AND JQL excluded = (I WOULD ADD ENTIRE CONTENT OF MY EXISTING JQL)'

In summary, the JQL for the automation would include any "Email request" tickets apart from whatever is in the JQL

PLease advise

Many Thanks

Tomasz

Accepted answers

Rilwan Ahmed

Hi @Tomasz Bis

Imagining your existing JQL is
project = ISD AND issuetype = "Email request" AND (Status = Open OR Reporter = XYZ)

Then the expected JQL would be
project = ISD AND issuetype = "Email request" AND (Status != Open OR Reporter != XYZ)
Make use of ( ) appropriately.

If you can give your full JQL and exact requirement, I can suggest a solution if possible.

All comments

Rilwan Ahmed

Hi @Tomasz Bis

Imagining your existing JQL is
project = ISD AND issuetype = "Email request" AND (Status = Open OR Reporter = XYZ)

Then the expected JQL would be
project = ISD AND issuetype = "Email request" AND (Status != Open OR Reporter != XYZ)
Make use of ( ) appropriately.

If you can give your full JQL and exact requirement, I can suggest a solution if possible.

Tomasz Bis

Thank you @Rilwan Ahmed

Lets say my current JQL is:

project = ISD AND summary ~ "Amzorders low compared to salesholding" AND status not in (done, completed) OR summary ~ "[Platforms P1]" OR summary ~ "[Monitor Alert] [P1] Triggered: No response" AND status not in (done, completed, Canceled) OR summary ~ "EBYUS system time 3 hours behind" AND issuetype = "Email request" AND issuetype = "Email request"

Rilwan Ahmed

Hi @Tomasz Bis ,

I see you are not using a correct format in JQL. not making use of ( ) while using AND/OR keywords.

1. project = ISD AND summary ~ "Amzorders low compared to salesholding" AND status not in (done, completed) OR summary ~ "[Platforms P1]" OR summary ~ "[Monitor Alert] [P1] Triggered: No response" AND status not in (done, completed, Canceled) OR summary ~ "EBYUS system time 3 hours behind" AND issuetype = "Email request" AND issuetype = "Email request"

Above should actually be like

project = ISD AND issuetype = "Email request"
AND (summary ~ "Amzorders low compared to salesholding" OR summary ~ "\\[Platforms P1\\]" OR summary ~ "\\[Platforms P1\\]" OR summary ~ "\\[Monitor Alert\\] \\[P1\\] Triggered: No response" OR summary ~ "EBYUS system time 3 hours behind")
AND status not in (done, completed, Canceled)

2. And if you want to list tickets which are not in above JQL, then use

project = ISD AND issuetype = "Email request"
AND (summary !~ "Amzorders low compared to salesholding" OR summary !~ "\\[Platforms P1\\]" OR summary !~ "\\[Platforms P1\\]" OR summary !~ "\\[Monitor Alert\\] \\[P1\\] Triggered: No response" OR summary !~ "EBYUS system time 3 hours behind")
AND status in (done, completed, Canceled)

Please note:
To search text "[Platforms P1]" in summary, then you need to modify it as
"\\[Platforms P1\\]".
[ ] are special characters.

More details about it in
https://support.atlassian.com/jira-software-cloud/docs/search-syntax-for-text-fields/

https://support.atlassian.com/jira-work-management/docs/use-advanced-search-with-jira-query-language-jql/
Checked "Reserved characters" section

Welcome!

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

Quick Links

Find more posts tagged with

cloud

jira-service-management-cloud

jira-service-management