Forums

Articles
Create
cancel
Showing results for 
Search instead for 
Did you mean: 
  • Community
  • Q&A
  • Jira
  • Questions
  • To upgrade to JIRA 7.2, can I remain on SQL Server 2008 R2, or must I upgrade SQL Server, too?

Need to sum the values of 2 custom fields and enter them in the Original Estimate field

Oksana Baier
January 30, 2023

I need to sum the values of 2 custom fields and enter them in the Original Estimate field
Original Estimate is a native field, I dont know type of this field
1) Can I use numeratic custom fields (Dev Estimate & QA Estimate) for sum values to Original Estimate?
2) What can I use for sum of custom fields?

 

I found an example https://support.atlassian.com/cloud-automation/docs/jira-smart-values-math-expressions/#Plus-Minus for story points only:
{{issue.Story Points.plus(issue.subtasks.size)}}

But dont understand how I can use it for custom fields... For example...
{{issue.Original Estimate.plus(???)}}

Help me, please)

1 answer

1 accepted

0 votes
Answer accepted
SMS
Atlassian Team
Atlassian Team members are employees working across the company in a wide variety of roles.
March 21, 2018

Hi Matt,

SQL Server 2008 was supported in 6.0. Where are you seeing it's not? I want to be sure our documentation is properly updated.

Microsoft SQL Server

As for the upgrade, yes, you will need to upgrade your database to MS SQL 2012 or 2014 prior to upgrading to Jira 7.2. It has not been tested with 2008 and therefore is not guaranteed to work properly.

Let us know if you have any questions about that!

Regards,
Shannon

Matt Menees
March 21, 2018

Thanks, Shannon.  Sorry, I meant--but forgot--to include a link to the Supported Platforms page for version 6.0.  Here it is:

https://confluence.atlassian.com/conf60/supported-platforms-852732636.html

Regards,
Matt

SMS
Atlassian Team
Atlassian Team members are employees working across the company in a wide variety of roles.
March 21, 2018

Hi Matt,

That article is for Confluence. Confluence hasn't supported MS SQL 2008 since version 5.8.

I hope that's clear, but do let me know if you have any questions.

Regards,
Shannon

Matt Menees
March 21, 2018

Oh dear, how embarrassing.  That's what I get for doing too many things at once ;^)

Thanks again,
Matt

SMS
Atlassian Team
Atlassian Team members are employees working across the company in a wide variety of roles.
March 21, 2018

No worries, Matt! 

Take care, and have a pleasant day!

Shannon

Suggest an answer

Log in or Sign up to answer