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

Accepted Answer
0 votes

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.

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.

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
Community showcase
Posted Tuesday in Featured Groups

Tuesday tips & tricks: What is the Atlassian Community?

It's officially Tuesday, which means it's officially time for another tip to help you better navigate this space we call the Atlassian Community. 😄 I got a great question from community member, Sa...

132 views 6 8
View post

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