how can i get the user from an external database and make it as asegnee

Question

Hello ,

i need to connect to an external database and get the name of users based in sql requet " Select name from users where product = " CONdition" ,

NB : the value of the condition is an custom field value and i'm using mysql

Nic Brough -Adaptavist- · Answer

You should be able to use the following to fetch a custom field value ( as a simple string you can drop into the SQL as needed)

def theValue = issue.getCustomFieldValue( customFieldManager.getCustomFieldObjectByName( "Field name" ) );

taher shili · Answer

using script runner ... i just know how to connect with an external database ... but i must get the custom field value and inject it in the sql requet 
so how can i do it ?

Nic Brough -Adaptavist- · Answer

You'll need to code to do that.  Do you have any scripting add-ons installed,or do you prefer to write your own add-on?