Get list of issues from a project and check custom field values

Justin G December 20, 2019

Using Script Runner and Behaviors

I am looking to pull all issue id's for a specific project and then for each issue, compare one of its custom field values to a string. This string will be whatever the user entered into that custom field for that specific issue on the form (CR Number).  If the custom field value (from all the other issues) is equal to that string (what was entered), then I need to raise an error stating that the value needs to be changed (no duplicates of "CR Number" are allowed)

What I have so far is I am able to get the list of all issues from my project and I believe all Issue objects have their field values in the said object.  

So now I want to do my comparison:

import com.atlassian.jira.issue.Issue;
import com.atlassian.jira.component.ComponentAccessor;

def issueMgr = ComponentAccessor.getIssueManager()
def issues = issueMgr.getIssueObjects(issueMgr.getIssueIdsForProject(10000))

//Here - how do I get what was entered into the custom field and compare it to all the CR NUMBER fields of the returned Issue item list (issues)

def input = getFieldById("customfield_10302")
def val = input.getValue() as String

for (int i = 0; i < issues.size(); i++){

if(issues[i].getCustomFieldValue(getFieldById("customfield_10619").equals(val))){
  //raise an error here and user must try a different value
}

}

1 answer

0 votes
brbojorque
Community Leader
Community Leader
Community Leaders are connectors, ambassadors, and mentors. On the online community, they serve as thought leaders, product experts, and moderators.
December 22, 2019

@Justin G 

Hmm what you are trying to do has a lot of performance penalty, imagine looping 20,000 issues just to compare the values every time the Custom Field changes.

What I will do is fix the custom field value of the existing tickets by doing a bulk update.

And in the behavior I will then properly filter the value of what the user will input.

That way you future proof any data that will be written in your instance.

Justin G January 8, 2020

Thanks for your response, however I am not able to understand what you are suggesting.  Can you please also include code snippets or pseudo code?

Suggest an answer

Log in or Sign up to answer