How to automatically update an existing JQL query

[Rajeev Gill]

Hi all, 

Our current market onboarding process involves us having to manually update multiple JQL statements every time a new market is added to our service desk (in order to apply multiple SLAs to tickets submitted by the new market)

Is there a way to automate this, so when a new market joins our service desk they will automatically be added to the JQL query and thus the SLAs will not need to be updated manually?

The steps I would like to implement are:

1. Listen for new markets being added to service desk

2. Take existing JQL queries for our SLAs

3. Append name of newly added market to JQL query thus updating SLA

Thank you!

[Grigory Salnikov]

Hi @Rajeev Gill 

I'm not sure whether there's an easy way to accomplish this. The only possible one I see is through REST API but that would require some additional scripting.

Maybe someone else has a better solution.

Good luck

[Rajeev Gill]

Hi Grigory, thanks for your reply

If I was to write a custom script using Node.js - Is this something I would have to run locally on my machine, or would I be able to run the script within the Jira platform somehow?

Rajeev

[Grigory Salnikov]

Hi @Rajeev Gill,  you're welcome

There's no difference from where we run a script. I think the most time-consuming part here would be creating a series of API requests. This usually requires some research.

[Jack Brickey]

Can you explain “market” here as it is implemented in you JSD project? Is it a custom field or something else! Can you share an existing JQL?

[Rajeev Gill]

Hi Jack,

By market I mean the country/region where the user submitting a ticket is located. It is a field (custom field I think) which a user would select when creating a new issue request, see screenshot:

I want to be able to, when a new market is added, automatically update our pre-existing SLAs so the newly added market is automatically added to our SLAs.

Thanks for your reply earlier, let me know if there is any other additional info I can add.