Get issues based on selected fixVersions
1 answer
1 accepted
Hi @Yogesh Mude
After going through your description, I understand that you are trying to find Issues that have Fix Version/s which match the values from the current Issue's Version custom field.
And once the current Issue transitions, you want to link it to the Issues that have Fix Version/s, which match its Versions custom field. Is this correct?
If so, you could try something like this in your post function:-
import com.atlassian.jira.component.ComponentAccessor
import com.atlassian.jira.project.version.Version
def customFieldManager = ComponentAccessor.customFieldManager
def versionManager = ComponentAccessor.versionManager
def issueLinkManager = ComponentAccessor.issueLinkManager
def loggedInUser = ComponentAccessor.jiraAuthenticationContext.loggedInUser
def customVersion = customFieldManager.getCustomFieldObjectsByName("Custom Versions")[0]
def versions = issue.getCustomFieldValue(customVersion) as List<Version>
versions.findAll {
def vIssues = versionManager.getIssuesWithFixVersion(it)
vIssues.findAll {
issueLinkManager.createIssueLink(issue.id, it.id, 10003, 1, loggedInUser)
}
}
Please note, this sample code is not 100% exact to your environment. Hence, you will need to make the required modifications.
For this example, you will need to use the Custom script post-function
Below is a print screen of the Post-Function configuration.
Below is an example test case:-
1) For the Issue I am going to transition, the value selected for the Versions field is 1 as shown in the print screen below:-
2) For the issues that are going to be linked with it, the Fixed Version/s selected is 1 as shown in the print screens below:-
Finally, once I try to transition the issue from To Do to In Progress, the issues will be linked as shown in the image below:-
I hope this helps to solve your question. :)
Thank you and Kind Regards,
Ram
Hi @Yogesh Mude,
For your requirement, you will need to do work with a couple of components, i.e. REST Endpoint, Behaviour and Listener.
The URL you will need to access is <JIRA HOME>/rest/api/2/project/${projectKey}/versions.
In the example below, the URL used is http://localhost:9091/rest/api/2/project/GV/versions and GV is the project key.
Before using the REST Endpoint to filter the fields, below is a sample output you should receive:-
1) First, to get the list of versions from another project using the URL shown above, you will need to use the REST Endpoint.
Please note, the sample codes shared here are not 100% exact to your environment. Hence, you will need to make the required modifications.
Below is a sample code for your reference:-
import com.onresolve.scriptrunner.runner.rest.common.CustomEndpointDelegate
import groovy.json.JsonBuilder
import groovy.transform.BaseScript
import groovyx.net.http.ContentType
import groovyx.net.http.HTTPBuilder
import groovyx.net.http.Method
import javax.ws.rs.core.MultivaluedMap
import javax.ws.rs.core.Response
@BaseScript CustomEndpointDelegate delegate
convertToJson { MultivaluedMap queryParams ->
def hostUrl = "http://localhost:9091"
def userName = "admin"
def password = "q"
def projectKey = "GV" // Project Key from which to get the Version list
def httpBuilder = new HTTPBuilder(hostUrl)
def issueJson = httpBuilder.request(Method.GET, ContentType.JSON) { req ->
uri.path = "/rest/api/2/project/${projectKey}/versions"
headers.'Authorization' = "Basic ${"${userName}:${password}".bytes.encodeBase64().toString()}"
response.failure = { resp, reader ->
log.warn("Failed to query JIRA API: " + reader.errorMessages)
return
}
}
def issueMap = [
items : issueJson.collect { Map row ->
[
value: row.get("name"),
html : row.get("name"),
label: row.get("name")
]
}
]
return Response.ok(new JsonBuilder(issueMap).toPrettyString()).build()
}
Below is a print screen of the REST Endpoint Configuration:-
When you test the REST Endpoint, you should get something like this:-
2) Second, you will need to use the Behaviour initialiser to convert a text field to a single select / multi-select and pass the output from the REST Endpoint to the field.
Below is a sample code for the Behaviour:-
import com.onresolve.jira.groovy.user.FieldBehaviours
import groovy.transform.BaseScript
@BaseScript FieldBehaviours behaviours
def linkedProjectVersions = getFieldByName("Linked Project Versions")
linkedProjectVersions.convertToSingleSelect([
ajaxOptions: [
url : "${baseUrl}/rest/scriptrunner/latest/custom/convertToJson",
keyInputPeriod: 500,
formatResponse: "general"
]
])
Below is a print screen of the Behaviour configuration:-
Below is a print screen of the Create dialog with the text field converted to single select:-
If you observe, you can see the list of version similar to the REST Endpoint result.
3) Finally, you will need to add a Listener to link the issues. In this example, I am using the Custom Listener with the Issue Created event and Issue Updated event.
Below is a sample code for the Listener:-
import com.atlassian.jira.component.ComponentAccessor
def issue = event.issue
def customFieldManager = ComponentAccessor.customFieldManager
def issueLinkManager = ComponentAccessor.issueLinkManager
def issueManager = ComponentAccessor.issueManager
def loggedInUser = ComponentAccessor.jiraAuthenticationContext.loggedInUser
def customVersion = customFieldManager.getCustomFieldObjectsByName("Linked Project Versions")[0]
def customVersionValue = issue.getCustomFieldValue(customVersion).toString()
def issueIds = issueManager.getIssueIdsForProject(11900)
def issues = issueManager.getIssueObjects(issueIds)
issues.each { sourceIssue ->
def versions = sourceIssue.fixVersions
versions.findAll {version ->
if(version.name == customVersionValue) {
issueLinkManager.createIssueLink(issue.id, sourceIssue.id, 10003, 1, loggedInUser)
}
}
}
In the Listener, you will need to modify this line of code according to your environment, i.e.
def issueIds = issueManager.getIssueIdsForProject(11900)
In my instance, the project id for the GV project is 11900. So you will need to modify it accordingly to match the id of the source project from which the versions are taken.
Below is a print screen of the listener configuration:-
Once the ticket has been created, you should see the issues from the other projects which have the same version as the issue created linked to the issue as shown in the image below:-
I hope this helps to solve your question. :)
Thank you and Kind regards,
Ram
Hi @Yogesh Mude,
As I explicitly mentioned in my previous comment, I was using the single select example in the sample code that I shared. Hence, you are only able to make one selection at a time.
If you want to select multiple versions, you will need to modify the Behaviour code and the Listener code accordingly.
In the Behaviour, you will need to change from
linkedProjectVersions.convertToSingleSelectto
linkedProjectVersions.convertToMultiSelectThis will allow you to choose multiple versions.
Below is the sample code for your reference:-
import com.onresolve.jira.groovy.user.FieldBehaviours
import groovy.transform.BaseScript
@BaseScript FieldBehaviours behaviours
def linkedProjectVersions = getFieldByName("Linked Project Versions")
linkedProjectVersions.convertToMultiSelect([
ajaxOptions: [
url : "${baseUrl}/rest/scriptrunner/latest/custom/convertToJson",
keyInputPeriod: 500,
formatResponse: "general"
]
])
And for the Listener, you will need to modify the customVersionValue to output as a List instead of a String, i.e. from
def customVersionValue = issue.getCustomFieldValue(customVersion).toString()
to
def customVersionValue = issue.getCustomFieldValue(customVersion).toString() as List<String>
and also modify the if condition from
if(version.name == customVersionValue)
to
if(version.name in customVersionValue)
Below is a sample code for your reference:-
import com.atlassian.jira.component.ComponentAccessor
def issue = event.issue
def customFieldManager = ComponentAccessor.customFieldManager
def issueLinkManager = ComponentAccessor.issueLinkManager
def issueManager = ComponentAccessor.issueManager
def loggedInUser = ComponentAccessor.jiraAuthenticationContext.loggedInUser
def customVersion = customFieldManager.getCustomFieldObjectsByName("Linked Project Versions")[0]
def customVersionValue = issue.getCustomFieldValue(customVersion).toString() as List<String>
def issueIds = issueManager.getIssueIdsForProject(11900)
def issues = issueManager.getIssueObjects(issueIds)
issues.each { sourceIssue ->
def versions = sourceIssue.fixVersions
versions.findAll {version ->
if(version.name in customVersionValue) {
issueLinkManager.createIssueLink(issue.id, sourceIssue.id, 10003, 1, loggedInUser)
}
}
}
Please note, the example codes are not 100% exact to your environment. Hence, you will need to modify them accordingly.
Below are a few print screen examples:-
Below are print screens of some of the linked issues
I hope this helps to solve your question. :)
Thank you and Kind regards,
Ram
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.