Is AIO the only way to log hours in JIRA?

[Kartheek Veeravalli]

Looks like the person who set up JIRA is not here any more (classic, I know!!) Found out that we are using AIO hours object to track time but to get that data out of AIO, we are facing challenges. However, we already consume data from JIRA using JIRA APIs.. so is there a way to track time in JIRA directly. Not sure why we are using AIO to begin with.

[Nic Brough -Adaptavist- · Accepted solution]

Absolutely not!  The time logging in Jira is quite powerful and feeds a lot of reports.

It is closely related to estimating, but you don't have to do estimates if you don't need or want them.  l regularly work in projects that have no estimates but I do log time worked.

Get started at https://confluence.atlassian.com/adminjiracloud/configuring-time-tracking-818578858.html

[Kartheek Veeravalli]

Awesome.. actually now a twist - looks like we are after all we are using Hours object in JIRA. So now we are trying to get the data out to our internal BI application to do reporting.

So we are using JIRA APIs to pull all the data and we see that the object JIRA_Timespent_History has logged hours but we don't see how logged that hours.. where can I get that?

[Nic Brough -Adaptavist-]

Your API calls can also fetch the "work logged" data, which will include the users who logged it.

[Joshwa Marcalle]

And after you have that squared out, you will need a cool tool to see the hour logs in a way that makes sense and adds value. 

I recommend this one: https://marketplace.atlassian.com/apps/1219348/hours-reports-for-jira?hosting=cloud&tab=overview

There is my sales pitch ;) 

Hope it helps

Josh
OB1

[Kartheek Veeravalli]

Thank you but trying to get that data internally using API into our DB to use our BI platform that can combine multiple datasets into one place. Have a question about that though.

We are using JIRA APIs to pull all the data and we see that the object JIRA_Timespent_History has logged hours but we don't see how logged that hours.. where can I get that?

[Joshwa Marcalle]

Which BI Platform are you using?

If its something like Tableau, then there are already add-ons to help you connect your cloud instance quite easily. We use AIO Tableau. 

If the BI tool you are using is popular, then chances are there is a plugin already to help you get the data.

If there are no existing plugins, then your only choice is to develop your own Jira API application for this (not difficult).

You can get the time that workers have logged in Jira using the  Jira API:

https://developer.atlassian.com/cloud/jira/platform/rest/v3/?utm_source=%2Fcloud%2Fjira%2Fplatform%2Frest%2F&utm_medium=302#api-api-3-workflow-get