Jira Oracle Database queries & Calculations on custom fields

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

3 answers

1 accepted

This widget could not be displayed.

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.

This widget could not be displayed.

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.

This widget could not be displayed.

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

Suggest an answer

Log in or Sign up to answer
Atlassian Summit 2018

Meet the community IRL

Atlassian Summit is an excellent opportunity for in-person support, training, and networking.

Learn more
Community showcase
Posted Wednesday in Teamwork

What teamwork quotes inspire you?

Hey everyone! My name is Natalie and I'm an editor of the Atlassian Blog and I've got a question for you: What's your favorite quote about teamwork?  We've compiled a list here, along with...

140 views 16 7
Join discussion

Atlassian User Groups

Connect with like-minded Atlassian users at free events near you!

Find a group

Connect with like-minded Atlassian users at free events near you!

Find my local user group

Unfortunately there are no AUG chapters near you at the moment.

Start an AUG

You're one step closer to meeting fellow Atlassian users at your local meet up. Learn more about AUGs

Groups near you