Create
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Sign up Log in
Products
See all
Community resources
Top groups
Explore all groups
Community resources
Learn
Community resources
Events
Community resources

is it possible to access an external ms sql db from a calculated field to grab the field value from there.?

alistairg
alistairg February 25, 2015

Using the calculated field plugging where you write java code in the <-- --> blocks is it possible to access an external database (ms sql 2008) to grab the field value?

Answer
Watch
Like Be the first to like this
241 views

1 answer

0 votes
Jobin Kuruvilla [Adaptavist]
Jobin Kuruvilla [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.
Get recognized
February 25, 2015

Yup. You might want to consider the performance, depending on what and where the data is!

View More Comments
alistairg
alistairg February 25, 2015

Yeah. Db is close on high speed network. Table is well indexed with small volumes. Query will only ever return single record and single value. Code will only execute in specific scenarios limited by project, issue type and other field values and I will try put short time out in place. Performance is a concern of course but I want to try this as it could bring useful visibility to some of the tickets.

Like
Reply

Suggest an answer

Log in or Sign up to answer
Jira
Jira Software
TAGS
AUG Leaders

Atlassian Community Events

    See all events