DatabasePicker for scriptrunner

[Ufuk Uysal]

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()
}

[Jeroen Poismans]

Hi there!

Adaptavist has a good KB article on accessing and reading DB tables:

https://scriptrunner.adaptavist.com/4.3.4/jira/recipes/misc/connecting-to-databases.html 

Let me know if this helped you!

Regards,

Jeroen