Hello
Could you help me.
I need get value from sql. I wrote script. but value in database picker not value and show error.
import com.onresolve.scriptrunner.canned.jira.fields.editable.database.SqlWithParameters
import com.atlassian.jira.component.ComponentAccessor
import com.atlassian.jira.issue.Issue
def customFieldManager = ComponentAccessor.getCustomFieldManager()
def lotTovara = customFieldManager.getCustomFieldObject("customfield_13001")
getSearchSql = { String inputValue, Issue issue ->
new SqlWithParameters("select OFFCNT_NAME from KSAS_DCT.OFFER_CONTENT WHERE OFFCNT_NAME like '%' || ? || '%'", [issue.getCustomFieldValue(lotTovara) ?: '', inputValue])
}
Hi alex, can you share how did you solve this?
Thanks,
Agustín
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.