Jira Oracle Database queries & Calculations on custom fields

[KP11]

We are looking to add JIRA fields and want to do calculations on these fields for RISK Management. We looked at some of the plugins and most did not have the number of fields we need or could not be supported with compatible JIRA releases. Has anyone ever used Oracle queries to stripp of fields per issue abd then calculate them with an Oracle Query or API against JIRA database?

Any way to do thus with JQL?

We can query each field:

project = FND AND "Risk Importance" AND "Risk Detectibility AND "Risk Probability"

We then want to calculate all the custome fields "RISK" above and display per issue a number.

I have tried Kepler plugins but do not want to use additional plugins. Instead soemthing with JIRA or JQL or Oracle API or query. Excel maybe too cumbersome as well

I saw this in another record. has anyone used it on the script console? Any report features available?

<!-- @@Formula: (issue.get("customfield_10236") != null ? issue.get("customfield_10236") : 0) * (issue.get("customfield_10237") != null ? issue.get("customfield_10237") : 0) -->

[Nic Brough -Adaptavist- · Accepted solution]

JQL is for finding issues, not manipulating the data. So you can use it to do the queries and get lists of issues.

But the calculation is a separate issue, and that's not something Jira does. It's why the risk plugins exist - there's an arbitrary calculation to be done. As they're not working for you, you need to find or write something better for you. Exactly as Harry says, I'd reach for the calculated custom fields in the script runner.

[KP11]

One more question. Using JIRA Misc Custom Fields Is there a formula in the JIRA Calculated field that allows multipliction of 3 fields? This was the code i saw from Natalie: https://answers.atlassian.com/questions/102299/jira-misc-workflow-fields-plugin-how-to-multiply

<!-- @@Formula: (issue.get("customfield_10236") != null ? issue.get("customfield_10236") : 0) * (issue.get("customfield_10237") != null ? issue.get("customfield_10237") : 0) -->

Can we add a third field? If so what would be the code? Thanks

[Harry Chan]

Have you looked at Script Runner plugin? This has calculated custom fields that you can write a Groovy script for.

Jamie is quite active here and the plugin is regularly updated.