Sub-Task not committing inherited account values on database

[James Wicks]

We are running a report on the database (SQL) which is a charge out report for finance. 

We have Jira and Tempo Timesheets.

The "Account" field and "Team" field are automatically inherited from the parent issues when we create a sub-task. On the front end everything looks good. When we open the sub-task it is showing the correct "Account" value.

However, when we interrogate the database, the inherited "Account" value is not showing the correctly on the database (Always gives us a value of 1.000). When we go back into Jira, to the sub-task, we change the "Account" to "None", update. We then edit the sub-task again and select the correct "Account" and then update. We interrogate the database again and only after the above actions does it appear correctly.

Any idea why the inheriting functionality does not commit the correct value for the Tempo Account field on Jira?

[Nic Brough -Adaptavist-]

I'd stop looking in the database, it's not going to help you with much.  It's a data store, not a reporting system, and is the worst place to look at anything in Jira.

[James Wicks]

Not very helpful. 

[Nic Brough -Adaptavist-]

There is nothing we can help you with.  You are doing the wrong thing.  The only help we can really give you is to suggest you move to doing something that might work.