Forums

Articles
Create
cancel
Showing results for 
Search instead for 
Did you mean: 

Custom field in customer portal doesn't work search by typing values

Dominykas May 8, 2019

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",
])

0 answers

Suggest an answer

Log in or Sign up to answer