In the text field I can't search

Erdem UÇAK 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) 

 

Erdem UÇAK June 20, 2024

Dear @Aswin Raj D 

thank you for comment. I have resolved this case. 

I added MaxSearchRecord in script.

Suggest an answer

Log in or Sign up to answer