Fields not updating Groovy Script Runner

RobertH

When creating a scripted field, I'm pulling information from an external database in my script.  It seems relatively simple, and it seems to work once, but then it will never work again.  Everything depends on issue.reporterId, but when that reporter changes, my fields don't seem to update.  I've tried disabling the cache, but that wouldn't help.  Any thoughts on this script or some updates or settings I'm missing?  

Also, my logging doesn't appear to work, probably because I'm bad at this!  

 

import groovy.sql.Sql
import java.sql.Driver
import com.atlassian.jira.component.ComponentAccessor
import com.atlassian.jira.user.util.UserManager


enableCache = {-> false}
log.info("Disabled Cache")
def userManager = ComponentAccessor.getUserManager()


// All for the SQL stuff.
def driver = Class.forName('com.microsoft.sqlserver.jdbc.SQLServerDriver').newInstance() as Driver 
def props = new Properties()
props.setProperty("user", "xxxxx") 
props.setProperty("password", "xxxxxxx")
def conn = driver.connect("jdbc:sqlserver://SQLBOX:1433;instance=CP;DatabaseName=xxxxxxx", props) 
def sql = new Sql(conn)
log.info("Connected to Database")
log.info(issue.reporterId)
try {
    def wow = sql.firstRow("SELECT t.ManagerPartyID, t.Segment AS segment, t.CostCenter AS costcenter, (SELECT s.NetworkLogin from MasterData.NOV.Employee as s WHERE s.PartyID = t.ManagerPartyID) as Manager FROM MasterData.NOV.Employee as t WHERE NetworkLogin = ${issue.reporterId}")
    return userManager.getUserByKey(wow.Manager)
} finally {
    sql.close()
    conn.close()
}

I've tested the SQL query and these work when querying manually.  It's also occurring with fields that don't rely on SQL.

Any input is greatly appreciated!

Chris Solgat

You may need to check and see what type of "Searcher" is being used for the field.  Those Searcher templates are used to tell JIRA what type of field it should be classified as when used for Search Results.  This also tells JIRA that it should store the value in JIRA's indexes.  If you set the Searcher template to "None", this should keep JIRA from storing it in the Indexes and force the field to re-load on page render.

To make this change, you will need to go to Admin > Issues > Custom Fields, find the field in question and then "Edit" and update the Search Template used.
You may also need to check and make sure that there is no DB caching happening as well.