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
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)
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.