Create
cancel
Showing results for 
Search instead for 
Did you mean: 
Sign up Log in

Next challenges

Recent achievements

  • Global
  • Personal

Recognition

  • Give kudos
  • Received
  • Given

Leaderboard

  • Global

Trophy case

Kudos (beta program)

Kudos logo

You've been invited into the Kudos (beta program) private group. Chat with others in the program, or give feedback to Atlassian.

View group

It's not the same without you

Join the community to find out what other Atlassian users are discussing, debating and creating.

Atlassian Community Hero Image Collage

JQL Question

Hi Community

My question, this is natively not possible with JQL and may need SQL, and as we know it is not recommended to run SQL on Jira production DB.

But would like to get some inputs from you all on how to solve this. Maybe there is an add on or something

My requirement with approaches

I have a few issues (alerts from a monitoring system) being created in our service desk with the following summary

Issue 1-- summary ~ Blahblahblah 1234567 is OPENED

issue 2 ---summary ~ Blahbahblah 1234567 is CLOSED

Issue 3-- summary ~ Blahblahblah 8888999000 is OPENED

issue 4 ---summary ~ Blahbahblah 8888999000 is CLOSED

In each week, we at least get ~150+ alerts that are open and closed and some stay open until our engineers resolve the alert, and once resolved, a closed alert gets generated.

Once an alert with the same number has OPENED & CLOSED words in them, consider that alert has been closed in the alerting system

Apart from normal day to day activities, monitoring these alerts in jira and closing them manually in Jira is a BIG TASK for a few teams.

I can run a JQL to find issues with the same numbers in summary, like

Find all issues where the issue summary CONTAINS 1234567 and close them. If I do this JQL I get 2 issues which are these

Issue 1-- summary ~ Blahblahblah 1234567 is OPENED

issue 2 ---summary ~ Blahbahblah 1234567 is CLOSED

and ideally need to do the same for rest of them and it is a manual tedious work and no one would like to do, but

as an alternate approach, I can user script runner JQL functions with a regular expression like this 

issueFunction in issueFieldMatch("project = XX", "summary","Blahblahblah \\d{9} OPENED")

and this returns all issues with a summary containing "Blahblahblah followed by a 9-digit number and text OPENED. " and I can bulk close these or use script runner job to close them in a timely manner.

But I need some sort of mechanism to compare jql to find matching numbers in summary and close them and this mechanism should return two issues similar to this 

Issue 1-- summary ~ Blahblahblah 1234567 is OPENED

issue 2 ---summary ~ Blahbahblah 1234567 is CLOSED

and close them with a job or something.

This is something to do with comparing numbers in summary and show issues with matching numbers and also return all issue matching the same criteria .

 

If am thinking wrong, please point me in some sense.

Thank you

 

 

0 answers

Suggest an answer

Log in or Sign up to answer
DEPLOYMENT TYPE
SERVER
TAGS
Community showcase
Published in Jira Service Management

Why upgrade to Jira Service Management Premium?

We often have questions from folks using Jira Service Management about the benefits to using Premium. Check out this video to learn how you can unlock even more value in our Premium plan.  &nb...

235 views 1 6
Read article

Community Events

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

Find an event

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

Unfortunately there are no Community Events near you at the moment.

Host an event

You're one step closer to meeting fellow Atlassian users at your local event. Learn more about Community Events

Events near you