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

[taher shili]

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-]

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?

[taher shili]

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-]

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" ) );