Forums

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

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

taher shili July 12, 2017

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

 

1 answer

0 votes
Nic Brough -Adaptavist-
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
July 12, 2017

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 July 12, 2017

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-
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
July 14, 2017

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

Suggest an answer

Log in or Sign up to answer
TAGS
atlassian, likes for trees, atlassian community, social impact, tree planting campaign, community kudos, atlassian giving, environmental impact, sustainability, likes for good, atlassian social responsibility, community challenge

Make every click count—help us plant 50,000 trees! 🌳

Want to make your everyday Community actions directly contribute to reforestation? The Atlassian Community can achieve this goal by liking a post, attending an ACE, sending your peers kudos, and so much more!

Help us plant more trees
AUG Leaders

Atlassian Community Events