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?
Yup. You might want to consider the performance, depending on what and where the data is!
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.
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.