Database picker search SQL based on custom field

[alex]

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

[alex · Accepted solution]

I resolve problem.

[agustin-barreto]

Hi alex, can you share how did you solve this?

Thanks,

Agustín

[Himanshi Maheshwari]

how did you resolved this. Please share