In the text field I can't search

Erdem UÇAK

Hello,

I created multiple custom picker and I had write script via Scriptrunner. I am sending request to Database and I see some values. In the text field I can't search another value. In the multiple custom picker is there any limitations. I am seeing 10 value of the 100 value

how can I resolve this search issue

Aswin Raj D

Dear @Erdem UÇAK ,

Welcome to the Atlassian community!

Could you please provide more insights about your script how you are fetching the values and return?

Here's a simplified example of how you might adjust a script to increase the limit of displayed values:

import com.atlassian.jira.component.ComponentAccessor
import com.onresolve.scriptrunner.db.DatabaseUtil
import groovy.sql.Sql

def databaseUtil = DatabaseUtil.getInstance()
def sql = databaseUtil.getSql()

def query = """
SELECT value
FROM your_table
LIMIT 100
"""

def values = []
sql.eachRow(query) { row ->
values << row.value
}

return values.take(100)