It's not the same without you

Join the community to find out what other Atlassian users are discussing, debating and creating.

Atlassian Community Hero Image Collage

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

0 votes
Answer accepted

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:

<!-- @@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
Published in Marketplace Apps & Integrations

Expose your beautifully crafted Dashboard through the Jira Service Desk Customer Portal

  A picture is worth a thousand words, especially when you're trying to find relationships and understand your data. Here, Dashboards play a vital role in gaining insights from a variety of dat...

331 views 5 4
Read article

Community Events

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

Find an event

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

Unfortunately there are no Community Events near you at the moment.

Host an event

You're one step closer to meeting fellow Atlassian users at your local event. Learn more about Community Events

Events near you