In the text field I can't search

Erdem UÇAK
I'm New Here
I'm New Here
Those new to the Atlassian Community have posted less than three times. Give them a warm welcome!
May 24, 2024

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

1 answer

0 votes
Aswin Raj D
Community Leader
Community Leader
Community Leaders are connectors, ambassadors, and mentors. On the online community, they serve as thought leaders, product experts, and moderators.
May 24, 2024

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) 

 

Suggest an answer

Log in or Sign up to answer