Timetracker, how to use the fields as a filter columns to make a dashboard or use REST API?

I was wondering how I could use the "Worklog Author", "Total Logged", and "Date Started" fields that are shown in timetracker reporting in the normal JIRA filter search columns.

 

I am wanting to make a static dashboard that shows all employees time spent over the past 30 days. Instead of having to go in to the reporting area every single time and change the dates manually.

 

All I need to see is the "user" and "total logged" for the last 30 days. Is there another way to do this and just have a static page for managers to go to and see all employees?

 

Could REST API be used to do this?

1 answer

Hello there,

Unfortunately, Timetracker does not provide any additional JQL function to get these fields yet.

I suggest you to use the JIRA REST API or our Worklog Query Plugin to gather your required worklog data and develop your dashboard gadget or some kind of application to display the data.

To be clear, "author", "timeSpent", "started", etc. are all default JIRA fields, what you can use with REST API. 

You can get a JSON response like this for example:

"...
"started": "2017-02-06T16:03:48.097+0000",

"timeSpent": "3h 20m",

"timeSpentSeconds": 12000,

"id": "100028",

"issueId": "10002"

..." 

If I get the Worklog Query Program would I be able to make a page that displays data that looks exactly like the User Quick Summary on Timetracker reporting? If so, how?

Do I need to have Timetracker to use Restful Worklog Query or can I just use the ladder?

 

Every time I go to reporting on Timetracker the page takes an extremely long time to load, so it doesn't seem viable for me, plus I would like just a static page for the last 30 days.   

You don't need the Timetracker to use our Worklog Query plugin.

I cannot describe to you exactly how to build your application, but yes, you can develop something that will show you exactly the same data. You just need to retrieve the work log data using Worklog Query plugin or the default JIRA REST API. Basically, you need to query for the users you want ("author" or "worklogAuthor"), in an interval with 30 days using the "started" field and the current date and summarize the "timeSpent" value for each user. Use the documentations what I already posted in my previous answer.

You can do this as a simple web app, Excel app, Google app, etc. or you can even make a JIRA gadget. (here is the documentation to how).

In the future, we want to add some gadgets like this to Timetracker, but I can't tell you the exact date.

 

I just don't see much documentation on how to make specific queries to pull certain things.

I'm sorry if I was not clear. You cannot exactly query the summarized data. You need to develop some logic to query, select and summarize logged times for users, etc. I can't give you an out-of-the-box solution for your problem, but maybe you can find some customizable dashboard gadget add-on on the Marketplace.

Can you tell me why the reporting is so slow with the Timetracker plugin? It takes so long that Chrome thinks it is non-responsive and wants to kill the page. This is anytime I load it, change the date range, or filter.

I'm sorry to hear that. But the good news is, that we are currently working to improve the performance of the Reporting. Thank you for your patience!

So this is normal and not just me?

Definitely not normal. Please contact me at feedback.jttp@everit.biz to discuss your performance issue!

We just released the new Timetracker version with bug fixes and some changes that can improve the performance. Please update, try it out and I hope that you will experience a performance improvement on the Reporting page.

Suggest an answer

Log in or Sign up to answer
Atlassian Community Anniversary

Happy Anniversary, Atlassian Community!

This community is celebrating its one-year anniversary and Atlassian co-founder Mike Cannon-Brookes has all the feels.

Read more
Community showcase
Bridget Sauer
Published Thursday in Marketplace Apps

Calling all developers––You're invited to Atlas Camp 2018

 Atlas Camp   is our developer event which will take place in Barcelona, Spain  from the 6th -7th of   September . This is a great opportunity to meet other developers and get n...

362 views 0 6
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