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
How to earn badges on the Atlassian Community

How to earn badges on the Atlassian Community

Badges are a great way to show off community activity, whether you’re a newbie or a Champion.

Learn more
Community showcase
Published Jul 10, 2018 in Marketplace Apps

If you’re an Atlassian app developer, you’ll want to know about Atlas Camp!

This September 6-7, hundreds of Atlassian App developers will flock to Barcelona Spain to build skills, discover product roadmaps, meet face-to-face with the Atlassian team, and learn how to extend t...

177 views 0 4
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