Not able to use JQL with Script runner updated Custom Field

Hi ,

updated the Text Field (single line) using script runner  , the script runner has updated the CustomFiled , but  not able to query using JQL with updated customField , it is not displaying any rows if updated custom Field used in JQL , but the value has been updated , updated column is Test_Email with Value 1001

Tried with Text & number in updation 

def tgtField = customFieldManager.getCustomFieldObjects(myIssue).find { == "Test_Email"}
def changeHolder = new DefaultIssueChangeHolder();
tgtField.updateValue(null, myIssue, new ModifiedValue(issue.getCustomFieldValue(tgtField), "1001"),changeHolder);

Output from Database

mysql> select * from customfieldvalue where issue=(select id from jiraissue where issuenum='2079') and CUSTOMFIELD=11300;
| 41245 | 15500 | 11300 | NULL | 1001 | NULL | NULL | NULL | NULL |
1 row in set (0.00 sec)

Screen Shot After updating using the Script runner 


2 answers

1 accepted

Accepted Answer
2 votes

You should use IssueService to update which will do the proper re-indexing for you after the update:

Here is some example code of how to use it in your script:

import com.atlassian.jira.component.ComponentAccessor

def user = ComponentAccessor.jiraAuthenticationContext.user.directoryUser
def issueManager = ComponentAccessor.issueManager
def issueService = ComponentAccessor.issueService

def issue = issueManager.getIssueObject("KEY")
def issueInputParameters = issueService.newIssueInputParameters()
issueInputParameters.setDescription("Updated description")

def validationResult = issueService.validateUpdate(user,, issueInputParameters)

if (validationResult.isValid()) {
    issueService.update(user, validationResult)"Updated issue")
} else {"Invalid update")

@Gabrielle Bautista [ACP-JA] @Adam Markham [Adaptavist]

Thanks for support 

After reindexing it's works fine ,

Added  indexManager.reIndex(issue); in the code to  Reindex the field 


Suggest an answer

Log in or Sign up to answer
Community showcase
Posted Tuesday in Jira

Looking for anyone who made the switch to Data Center

The Jira Marketing team is putting together an ebook on migrating to Data Center. We're looking for pro tips on how you staffed your project team and organized your Proof of Concept. Share yo...

35 views 0 2
Join discussion

Atlassian User Groups

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!

Find my local user group

Unfortunately there are no AUG chapters near you at the moment.

Start an AUG

You're one step closer to meeting fellow Atlassian users at your local meet up. Learn more about AUGs

Groups near you