Hello , is it possible to update fields of all linked issues of an issue if I e.g. add a new Fix Version field to my main Issue......can I than automatically update this Fix Version value in all the linked issues to this issue........or can I make an SQL Query to get all the linked issues of certain issues ??
I would tend to favor a solution without scripting. Easier to maintain and quicker to setup. Your problem would be easy to do if the update happens on a transition of the source issue. You'll need to Misc. Workflow Extension plugin and use the Copy Field Value To Linked Issues post function
Since typically a field like Fix Version would be set when an issue is set Resolved or something similar, that solution would work I think. Or you could add a workflow transition from the status back onto itself and use the post function there. That would be your "edit and copy field value" transition and not actually change the status.
In the workflow editor, in diagram view, you can literally make a transition arrow go from Status A to a different little white dot in the Status A. It looks like a loop, and that's a valid transition. You can even add a condition so that only certain users can see it, and a validator to make sure there's a value in Fix Version.
This "self transition" is a neat trick that can have other applications too. JIRA doesn't have field-level security, but you could use a transition like this to overcome that.
Let's say you want all users to view the Priority of an issue, but want to allow only managers to change it (or maybe the other way around, these pesky managers keep changing priorities for no reason ). What you do is this:
This way, you get a "hidden" transition, accessible only to managers, to edit the Priority, preventing others from editing it.
High level, you can do both. Syncing between parent/child (issue/subtask) or link/link is fairly straightforward. I have an issue/subtask FixVersion sync Script Runner listener that updates the subtasks whenever the parent value is changed, or whenever the child value is changed (say, linking a new child that was out of sync, etc). I posted a copy here:
Beyond that, you can use the (again, Script Runner) issueFunction method in JQL to find such children. For issue/subtask, you could use, for example:
issueFunction in subTasksOf("project=X and FixVersion=\"1.0\"")
This would get you all of the subTasks. There is a similar function for links, "linkedIssuesOf", which takes a subquery like above, plus an optional link name.
For more specific help, we'd need to know how the parent/child relationship is modeled (issue/subtask, or specific outward/inward links, or custom fields, etc, etc).
Connect with like-minded Atlassian users at free events near you!Find a group
Connect with like-minded Atlassian users at free events near you!
Unfortunately there are no AUG chapters near you at the moment.Start an AUG
We're bringing product updates and pro tips on teamwork to ten cities around the world.Save your spot