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

[alistairg]

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?

[Jobin Kuruvilla [Adaptavist]]

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

[alistairg]

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.