Hello, i have question, why in customer portal in custom field doesn't work search by typing values. In base Jira window over Create button all works fine. There can be a problem?
What and how i made this custom field:
1. I made single text custom field.
2. Then made script to retrieve data from external SQL server.
import javax.ws.rs.core.MultivaluedMap
import javax.ws.rs.core.MultivaluedMap
import javax.ws.rs.core.Response
import java.sql.Driver
@BaseScript CustomEndpointDelegate delegate
eventTypes(httpMethod: "GET") { MultivaluedMap queryParams ->
def query = queryParams.getFirst("query") as String
def rta = [:]
def datasource = ComponentAccessor.getComponent(DatabaseConfigurationManager).getDatabaseConfiguration().getDatasource() as JdbcDatasource
def driver = Class.forName('com.microsoft.sqlserver.jdbc.SQLServerDriver').newInstance() as Driver;
def props = new Properties();
props.setProperty("user", "my_user");
props.setProperty("password", "my_password");
def conn = driver.connect("jdbc:sqlserver://10.10.106.08:108;databaseName=database", props);
def sql = new Sql(conn);
try {
sql
def rows = sql.rows("SELECT column FROM table")
rta = [ items : rows.collect
{ GroovyRowResult row -> [ value: row.get("column"), html: row.get("column"), label: row.get("column"), ] }
,
total: rows.size(),
footer: "choose... "
]
} finally
{ sql.close() conn.close() }
return Response.ok(new JsonBuilder(rta).toString()).build();}
3. In Behaviours write below script:
getFieldById("customfield_11976").convertToMultiSelect([
ajaxOptions: [
url : getBaseUrl() + "/rest/scriptrunner/latest/custom/eventTypes?query=work",
query: true,
data : [
currentJql : "project = PROJECT ORDER BY key ASC"
],
formatResponse: "general",
],
css: "max-width: 500px; width: 500px",
])