Where in JIRA database is field "Σ Remaining Estimate" and "Remaining Estimate" stored

Hi. 

 

I am looking inside our JIRA database (SQL server) for the location where the fields  "Σ Remaining Estimate" and "Remaining Estimate" are stored.

 

So I am looking for the table-name and columns name.

Can someone please let me know where I can find this?

Thanks,

Andre

 

2 answers

1 accepted

This widget could not be displayed.

They're not stored in the database, they are calculated.  You'll have to code to accumulate the values yourself, every time.

Please, do not try reporting off a Jira database, it's not designed for it and is the single worst possible way to try to do any reporting for Jira.

This widget could not be displayed.

Hi Nic,

 

Thanks for your quick answer. Do you know where this value is calculated from? (wich fields are used?   formula?

Remaining estimate is stored, but also calculated which makes it "fun".

In a simple case, the users put in an estimate of X, then several worklogs are added, recording time as (say) y1, y2, and y3, giving a total of Y, then when you look at the issue, the "remaining estimate" is simply "X - Y".

But then it gets complex.  Users can also adjust the remaining estimate directly, and the current estimate of time.  If they've done that, then the estimate is adjusted in the database on the issue table as well. 

So you've three columns to read on the issue table, plus all the worklogs.

The "Σ" fields are at least a bit more simple to explain, although even harder to replicate with SQL. They're the same as above, but summed up for all sub-tasks on top-level issues.

Suggest an answer

Log in or Sign up to answer
Community showcase
Published Apr 22, 2018 in Jira Software

How-to setup a secured Jira Software 7.9.0 on Ubuntu 16.04.4 in less than 30 minutes

...PermissionsStartOnly=true User=www-data Group=www-data ExecStart=/opt/jira/bin/startup.sh ExecStop=/opt/jira/bin/shutdown.sh TimeoutStartSec=120 TimeoutStopSec=600 PrivateTmp=true [Install] WantedBy...

1,489 views 10 12
Read article

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