Hi,
I want to make a database query by user email and write the phone number on the screen.
What I tried to do with behaviors is also not working.
I need to try with script field. What kind of path should I follow? An important issue for me, I request your help.
import com.onresolve.jira.groovy.user.FieldBehaviours
import com.onresolve.scriptrunner.db.DatabaseUtil
import groovy.transform.BaseScript
@BaseScript FieldBehaviours fieldBehaviours
def field = getFieldByName("issue.getReporter().getEmailAddress()")
def value = field.value
def info = DatabaseUtil.withSql('BLGMPROD') {sql ->
sql.firstRow("SELECT TELNO FROM SAP_EMPLOYEE WHERE INTERNETMAILADDRESS = ?", value)
}
if (value && !info) {
field.setError ("Dahili Numara Bulunamadı.")
}
else {
field.clearError()
}
