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
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?
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 ?
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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" ) );
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.