how can i run background queries using customfield values?

[C_ Faysal]

Hi.
i want to build something equal like the SEN field in support.atlassian.com
my goal is..

if a user enters a number in a field...some queries should be done on an external server using this number.
the results should be displayed below this field...

i think something like this is used to verify a customers SEN.

[francis · Accepted solution]

You should use the script runner plugin.

The code would look like

import groovy.sql.Sql;
import groovy.sql.GroovyRowResult;
import java.sql.SQLException;

Sql connection;


try {
connection = Sql.newInstance( 'jdbc:postgresql://localhost:5432/database','user','password', 'org.postgresql.Driver' );
} catch (SQLException e) {
return "Unknown (Issue connecting to the database: ${e.getMessage()})";
}


GroovyRowResult result = null;
try {
    result = connection.firstRow("select name from customers where id = ${customerid} ");
} catch (SQLException e) {
    return "Issue retrieving data from the database: " + e.getMessage();;
}





if (result == null) {
   // no value given
   return "Customer not known";
}

return "The customer is " + result.get("name");

[C_ Faysal]

hmm

i get some result like:

javax.script.ScriptException: groovy.lang.MissingPropertyException: No such property: username for class: Script24 A stacktrace has been logged.

in my case i've set up a field "username"

by entering a user name a query should be performed to show me the users email_address

running the query in the local db works fine. am i missing something here?

[francis]

Its hard to tell without code
Propably you use something like $username without declaring it.

You need to retrieve the value from the customfield. The script runner wiki has many examples how to do this.

Francis

[Nic Brough -Adaptavist-]

You'll need to do a bit of coding to get this. I've not seen a plugin that will do this off-the-shelf.

[C_ Faysal]

yeah that's what i expected. but could you share any idea?

i mean i don't think it is done by some jelly scripts doesn't it