Update the custom field value based on jql results while creating the ticket

jira_admin_cu

Hi Team,

I tried with something, but I am sure it is not perfect. Could you please help on correct script.

If we create a filter for our JIRA workflow like: “Hub ID” in (xxx, abc, def, 123, etc)  is there any way to have tickets run that filter upon creation and then dynamically update a field to either be checked as “yes” or “no”.

 

import com.atlassian.jira.component.ComponentAccessor
import com.atlassian.jira.issue.search.SearchProvider
import com.atlassian.jira.jql.parser.JqlQueryParser
import com.atlassian.jira.web.bean.PagerFilter
import com.atlassian.jira.issue.ModifiedValue
import com.atlassian.jira.issue.util.DefaultIssueChangeHolder

def jqlQueryParser = ComponentAccessor.getComponent(JqlQueryParser)
def searchProvider = ComponentAccessor.getComponent(SearchProvider)
def issueManager = ComponentAccessor.getIssueManager()

// JQL Query
def query = jqlQueryParser.parseQuery("project = MD AND ("Hub ID" ~ 504 OR "Hub ID" ~ TST)")

// the name of the custom field to update
final String customFieldName = 'Risk Hub Id'

// the new value of the field
final String newValue = 'Yes'

def customFieldManager = ComponentAccessor.customFieldManager
def issue = event.issue

def customField = customFieldManager.getCustomFieldObjects(issue).findByName(customFieldName)
assert customField : "Could not find custom field with name $customFieldName"

if (query.isValid()) {

customField.updateValue(null, issue, new ModifiedValue(issue.getCustomFieldValue(customField), newValue), new DefaultIssueChangeHolder())

}

Martin Bayer _MoroSystems_ s_r_o__

hi @jira_admin_cu your script is not correct. I will try to give you needed snippets You're not using results of query in your snippet but only "isValid" which is not enought I guess. In my snippet I'm evaluating issues count and if the count is > 0, value in "customField" is filled in with newValue.

def jqlToSearch = "project = MD AND ("Hub ID" ~ 504 OR "Hub ID" ~ TST)"
def parseResult = searchService.parseQuery(user, jqlToSearch)
log.error("jql: " + jqlToSearch)
if (parseResult.isValid()) {
def searchResult = searchService.search(user, parseResult.getQuery(), PagerFilter.getUnlimitedFilter())
    if(searchResult.issues.size()>0) {
customField.updateValue(null, issue, new ModifiedValue(issue.getCustomFieldValue(customField), newValue), new DefaultIssueChangeHolder())
    }
}

give it a try and let me know what exactly is not working and we will fix it