I have a JSM project, let's call it parent, from which we clone issues into two different projects, design and production. Not all issues get cloned into both projects. In other words, some issues from parent may only have an issue cloned to design or production.
We are trying to create automation rules that auto-update the status of parent issues (tickets) for clients based on the statuses of the cloned issues in design and/or production.
What I'm trying to figure out is how to use JQL to set up a structure like this in my automation rule:
Any help would be tremendously appreciated!
Hey @Oto Tabares
What you are asking is possible in Jira on-prem but it is not possible in Jira Cloud. This is due to the restriction on JQL functions imposed by Atlassian on how these functions can interact with their infrastructure.
Regardless, you can still create your automation rule using JQL to compare your cloned issue within your different projects but only if you use Scriptrunner for Jira. The JQL condition you need to use is "issueFunction" and there is documentation about it.
Let me know if this information helps you with your use case.
Hi there @Oto Tabares,
Developer from Automation here.
Depending on your exact setup it might be possible to get the following rule setup to work. I've made a few assumptions with the below examples but it might be able to solve your use-case using a combination of linked issue branches and JQL.
We will need something to link the primary issue in parent with the other issues in design and production, so in my case I assume that design and production tasks have an issue link of "clones" to the parent task. Provided your cloned issue have use some type of issue links then you should be able to achieve the below examples.
To do this I would create 2 rules, one which handles the case of a design issue syncing changes to parent and the second having production make changes back to parent as well. Statuses are linked to issue transitions so you'll need to set that as the triggering event, then attempt to edit/transition the parent issue depending on what you want to happen. You might be able to get it all working in one rule but I think two helps simplify this.
For the second rule you'll need to duplicate this one but change the design project in the conditions to be production. I've added a log action in the example but once you've got it working you can change that to something like edit issue, or transition issue copying from the linked issue if you would like to sync statuses. The related issue conditions with one using some and the other using none will help match the cases that the item is created in one of the sub projects but not in the other.
Since it uses checks in multiple projects the rule will either have to be set as global, or the project scope including the projects used projects.
It's a bit of a complex use-case for Automation so it might not suit your exact requirements, but you can also reach out to support here: https://support.atlassian.com/contact/
Thanks, Yvan. I appreciate you taking a stab at this. Our needs are a bit more complex because we need to update the status of issues in the service project using statuses from cloned issues in two JWM projects. I'm working with a support engineer from the Atlassian team to help with our exact requirements. Thanks again!
Reporting on the status of work is critical to keeping your team on the same page, proactively identifying risks, and staying on track and on budget. But manually compiling this information from different sources is one of the biggest drivers of work about work—busywork that gets in the way of your meaningful, high-impact tasks.
Hello Atlassian Community! We’re thrilled to announce some exciting changes to incident management in Jira Service Management Cloud, in order to give your teams extra muscle during incidents, and ...
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