query that compare field based on a link

Question

Hi everyone ,

I'm trying to build a JQL that allow me to compare a field between some "causes / is caused by" linked issue.

The goal is:

I can use script runner

I got a ticket named Impact into a specific project, link with some other epic tickets in differen other project by "causes / is caused by" link.

I want to compare the product field and see ticket if the product field is different between linked issue.

I try many option but i never get something that match the prerequisite.

Gustavo Félix_5ziaxu · Answer

@fperez You can try to run this first, just to see if this is what you need import com.atlassian.jira.component.ComponentAccessor import com.atlassian.jira.issue.CustomFieldManager import com.atlassian.jira.jql.parser.JqlQueryParser import com.atlassian.jira.web.bean.PagerFilter import com.atlassian.jira.user.util.UserManager import com.atlassian.jira.bc.issue.search.SearchService import com.atlassian.query.Query import com.atlassian.jira.issue.link.IssueLink import com.atlassian.jira.issue.IssueLink import com.atlassian.jira.issue.IssueManager def projectKey = "TEST" def linkType = "Relates" def customFieldName = "test" def customField = ComponentAccessor.getCustomFieldManager().getCustomFieldObjectByName(customFieldName) //JQL to run def queryJql = "project = "+projectKey def user = ComponentAccessor.getJiraAuthenticationContext().getLoggedInUser() def searchResult = ComponentAccessor.getComponent(SearchService).search(user,queryJql,PagerFilter.getUnlimitedFilter()) //It should log the total results after running the jql log.warn searchResult.total //This will iterate all the results in your jql . issueTemp is each issue result. //It will search for every linked issue type. Just to see if it's working. searchResult.getResults().each{ issueTemp -> List allInIssueLink = ComponentAccessor.getIssueLinkManager().getInwardLinks(issueTemp.getId()) def linkedIssue def parentCustom = issueTemp.getCustomFieldValue(customField) for(Iterator inIterator = allInIssueLink.iterator(); inIterator.hasNext();){ IssueLink issueLink = (IssueLink) inIterator.next(); linkedIssue = issueLink.getSourceObject() def childCustom = linkedIssue.getCustomFieldValue(customField) if(parentCustom==childCustom){ log.warn issueLink.getIssueLinkType().getName() + "-" + linkedIssue.getKey() } } }

fperez · Answer

Hi @Gustavo Félix , i'm still trying to find the solution!

Gustavo Félix_5ziaxu · Answer

Hi @fperez  
Did you figure it out? I was going to answer before but this question got lost on my browser tabs.